Need Assistance With Complicated Mcaro

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:-

  1. Change the value in cell D3 on a sheet called Supplies of the Datafigures file to "Outstanding".
  2. Run a macro in the Datafigures file called "UpdatedFormulas".
  3. 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".
As you can see this is a complicated task and I would therefore appreciate any guidence/help.

Thanks in advance.
 

Some videos you may like

Excel Facts

Difference between two dates
Secret function! Use =DATEDIF(A2,B2,"Y")&" years"&=DATEDIF(A2,B2,"YM")&" months"&=DATEDIF(A2,B2,"MD")&" days"

bobsan42

Well-known Member
Joined
Jul 14, 2010
Messages
1,343
Open the two workbooks before trying this:
Code:
Sub testme()
Workbooks("Datafigures").Activate
Workbooks("Datafigures").Sheets( "Supplies").Range("D3") = "Outstanding"
call UpdatedFormulas
Sheets( "Supplies").Range ("B3:CD5671").copy
Workbooks("Report").Activate
Sheets("PrintOutstanding").Range ("B3:CD5671").PasteSpecial xlPasteAll
End Sub
will this do?
 

Watch MrExcel Video

Forum statistics

Threads
1,108,727
Messages
5,524,478
Members
409,584
Latest member
RedHelp

This Week's Hot Topics

Top