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
