Sleeper: Shift Columns Down

[asugianto]

Hi,

There are two parts in this worksheet. Part 1 is before Macro and Part 2 is what it is supposed to look after Macro. On the part 1, the table on the left is for last month and the table on the right is for this month. How do I write the Macro so that everytime there is a new ID, which is the first column in each table, the table on the left shifts down 5 rows so that the final result will be part 2.

I tried to attach the results on this thread, but the file is too big by 10KB. Please e-mail me at alvin.sugianto@gmail.com for the results file.

Thank you!

[Jacob Hilderbrand]

You can Insert cells above the table.



For i = 1 to 5
Range("A1:D1").Insert Shift:=xlDown
Next i

[OBP]

To upload your file zip it first.

[asugianto]

Attached is the sample Results in pdf format. Thanks!