Hi, all. I'm very rusty with macros at the moment so I hope I can explain this properly.
I want to have a macro that will open a document called "Sales Data -7 to +14" in location W:\CALL CENTRE OPERATIONS\WORKFORCE PLANNING\RESOURCE PLANNING\Reporting\Autorun Reports It then needs to copy all the data in a tab called 'Data' in the range columns A:Y and however far down it goes (it will vary from day to day) and paste into my document in a tab called 'Raw Data' and then close down the file called "Sales Data -7 to +14"
I have tried recording a macro so I can edit it but I do not get reference to the file path of "Sales Data -7 to +14", even though I open it whilst recording the macro so now I am confused
Thanks in advance
Andy
I want to have a macro that will open a document called "Sales Data -7 to +14" in location W:\CALL CENTRE OPERATIONS\WORKFORCE PLANNING\RESOURCE PLANNING\Reporting\Autorun Reports It then needs to copy all the data in a tab called 'Data' in the range columns A:Y and however far down it goes (it will vary from day to day) and paste into my document in a tab called 'Raw Data' and then close down the file called "Sales Data -7 to +14"
I have tried recording a macro so I can edit it but I do not get reference to the file path of "Sales Data -7 to +14", even though I open it whilst recording the macro so now I am confused
Thanks in advance
Andy