macros

Public Schedule Face-to-Face & Online Instructor-Led Training - View dates & book

Forum home » Delegate support and help forum » Microsoft Excel Training and help » Macros

Macros

resolvedResolved · 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.


 

Excel tip:

Working with 3D formulas

You can only use fill-down if you remove $ for Absolute References.

View all Excel hints and tips


Server loaded in 0.09 secs.