Macros

Hi Deepak

Thanks for your example.
I've set up a similar one where there are monthly headings and 3 rows of data for Jan, Feb and Mar in Sheet1. The formulas link back to cells in Sheet2.

I'll try to upload the file but in case you can't open it here is the code: (Created by recording with Relative Record switched on). Where it adds "A1:A3" it means the block relative to the active cell which moves to the right each month.

Sub Macro1()
Range("A2").Select
Selection.End(xlToRight).Select
ActiveCell.Range("A1:A3").Select
Selection.Copy
ActiveCell.Offset(0, 1).Range("A1").Select
ActiveSheet.Paste
Application.CutCopyMode = False
End Sub

Here is my data (hard to read on the post but can if you copy to Excel then use Text to Columns and tick space delimiter).

Sheet1

Jan Feb Mar Apr May Jun Jul
100 200 300
40 80 120
60 120 180

Sheet2



Jan Feb Mar Apr May Jun Jul
Sales 100 200 300 400 500 600

Costs 40 80 120 160 200 240

Profit 60 120 180 240 300 360


The important part is to select Use Relative REcord before recording the macro.

Hope that gets you a bit further.

Doug
STL