Range.Copy Macro

[manuscriptguru]

Hello,

I need a Macro that can copy a variable range from the attached Excel sheet into a new Excel sheet. The row number of the range is variable each time, but the columns are the same.
For example, one time I need to copy the information from row 4, another time from row 20, another from row 45. However, in all three cases, the columns will remain the same.
The range of columns is always the same: D, E, F, G, H, I, K, L, M, N, O, P, Q

In the target sheet, each column will pull the information from one of the sheets in the original in the proper order (January, February..etc). So the target sheet will always have 12 rows, and each row will have the information from the columns above.

I hope this is easy to understand.

[David A Coop]

Sorry, not clear.
For one thing, I don't know what the "target" sheet is. Unfortunately, the workbook is protected, so I can't insert a sheet. (When you said sheet, did you mean that, or did you want another workbook?)

I would probably use the INDIRECT() function rather than a macro. All you would need is a column with the month names (identical to the tabs on your sample workbook), and a cell where you enter the Row Number you want to examine (presumably a Vendor, and they are in the same row on every sheet).

=INDIRECT("'"&$A4&"'!"&SUBSTITUTE(ADDRESS($B$4,COLUMN(),4),"1",""))

Will achieve this. Column A is assumed to have the Month Name, and $B$4 the row number.
This formula should be able to be entered once, and copied across and down. (The SUBSTITUTE() formula enables this by picking up the column name as you copy across).

Hope this is of some help.

Trust you and yours are well.

Regards,

David

[manuscriptguru]

Thank you, David. I will look into this.