Help with creating a macro needed

kasbac · Feb 28, 2011

Hi there

I need help writing a macro that will complete the following steps:

Select the tab ”Overview Q1 2011”
Select the last column in the sheet containing data (Column A will always be blank and should be disregarded.
Copy the selected column
Paste the column into the next column
Find ”$Q$4:$Q$5000” in the newly pasted data and replace it with "$P$4:$P$5000"
Select the tab “xxx”
Copy the cells P1:P2
Return to the tab ”Overview Q1 2011”
Paste special values only into the cells in the newly created column in line 2 and 3.

I hope that someone will be able to help me out, if any clarification is needed please let me know.

Thanks in advance

kasbac · Mar 1, 2011

Champion Andrew worked like a charm thank you very much!