Hi, I am new to recording macros and was just trying to find out if there is a way of making them progressive.

For example I have recorded a macro which takes all our weekly sales, then splits it by unit then feeds that info through to a week by week report page (unfortunatley it wont let me attach an example)

But basically I need to find a way of getting the data that feeds through to the relevant week to change column each time, for example week one goes into column a week two goes into column b etc?

Does anybody have any suggestions?