98.7% Of all customers recommend us, we're so confident about our results we publish all reviews and stats
View Live Stats View ReviewsForum home » Delegate support and help forum » Microsoft Excel Training and help » Macros
Macros
Resolved · Low Priority · Version 2007
Beth has attended:
Excel Intermediate course
Excel Advanced course
Macros
Is it possible to run a macro to copy and paste from another workbook?
For example, updating a spreadsheet week on week with the new week's figures. E.g. we have weekly sales that are downloaded from our companys system to excel. can there be a macro to then copy and paste these sales into a separate spreadsheet that we update week on week?
RE: Macros
Beth
The only problem with recording such a macro is that it would copy and paste the information in the same place as recorded and would overwrite information if you ran it again.
Do you want the copied information to overwrite existing data or do you want it appended to existing data?
The answer to this question will determine the kind of macro you record.
RE: Macros
Hi Beth
We are reviewing questions on our forum where we are waiting for a response from the delegate to a request for clarification.
If your question is still active could you please respond to our request for clarification within the next few days. If however, it is no longer active, then ignore this post and we will remove it at the end of the week.
Thanks
Stephen
Sun 31 Oct 2010: Automatically marked as resolved.
Training information:
See also:
Welcome. Please choose your application (eg. Excel) and then post your question. Our Microsoft Qualified trainers will then respond within 24 hours (working days). Frequently Asked Questions
Any suggestions, questions or comments? Please post in the Improve the forum thread. |
Excel tip:Working with 3D formulasYou can only use fill-down if you remove $ for Absolute References. |