Delta Star
Board Regular
- Joined
- Oct 28, 2009
- Messages
- 184
I've had a look on previous posts but cannot find what I'm after, so once again I'm asking for help.
I have a workbook called Report and another called DataFigures. I need to setup a macro on the Report workbook that will:-
Thanks in advance.
I have a workbook called Report and another called DataFigures. I need to setup a macro on the Report workbook that will:-
- Change the value in cell D3 on a sheet called Supplies of the Datafigures file to "Outstanding".
- Run a macro in the Datafigures file called "UpdatedFormulas".
- Copy the data from the Supplies sheet (cells B3:CD5671) of the DataFigures file and paste into the Report file into a sheet called "PrintOutstanding".
Thanks in advance.