Forum home » Delegate support and help forum » Microsoft Excel Training and help » Macros
|
|
|
The UK's most regular 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. |
Macros
Resolved · Low Priority · Version 2007
Reply Thu 16 Sep 2010, 16:53Delegate Beth said...
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?
For upcoming training course dates see: Pricing & availability
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.
|