Search : in
By :

Macro for excel column compile

aeracer03, on Sep 14, 2009 3:46:42 pm BST 
 Report this message to moderators

Hello,

I am trying to write a macro to compile multiple columns of data into on set of columns. For instance I have A thru L, M thru X and Y thru AJ as sets of data and would like to put M thru X under A-L and then Y thru AJ under A-L. In addition, each data set may have blank row that need to be deleted. Is there some dialogue that would define the regions and then copy them to the end of the data set? Then I know there is a simple delete row macro I could tag to the end but I would like to avoid this if possible.

Thanks

Configuration: Windows XP
Firefox 3.5.3

Best answers for « Macro for excel column compile » in :
Delete duplicates in an Excel column ShowDelete duplicates in an Excel column To remove duplicates in an Excel column: Click on the Data menu Filter Advanced Filter In this menu, select the column where the duplicates Check the box "Extract without duplication"...
Basic Excel Formulas ShowBasic Excel Formulas Below are some basic formulas for Microsoft excel: Basic formula : ADDITION cell A1 to A10 = sum (A1: A10) AVERAGE cell A1 to A10 = average (A1: A10) MAXIMUM cell A1 to A10 = max (A1: A10) MINIMUM...
EXCEL: The INTERSECTION function ShowEXCEL: The INTERSECTION function You have a table consisting of rows and columns. Want to know the value of the cell at the intersection of a particular row / column in your table Example: Your table: - starts C3 to F3 ......
Ask your question Reply
They need your help