Macro updateing scorecard

[nightcrawler-jay]

Good afternoon all.

I have recorded a macro to run each of my reports and give me different results. I have a scorecard that I record my daily progress. Is there by anychance after I run the macro that it could update in the scorecard automatically? I have 6 macro that I have recorded in differnt workbooks due to the size. All I need is that the total gets pulled into a single cell for the day. Is there a formula I can put into my scorecard that will pull the info out daily into the correct days?

Scorecard below. In the macro the results will be in like tab pivot-MB51 cell A50 for the day


Thanks

[stnkynts]

Not quiet sure what you truly need but Vlookup might work for you. I think it works across closed workbooks for referencing a value. Something like:

Please Login or Register  to view this content.

You will need to edit for your situation.