Can data in Excel 2003 be set up to automatically move from one sheet to another in a workbook?

5 pts.
Tags:
Excel 2003
Excel macros
Macros
Microsoft Excel
Is it possible to create a macro, or multiple macros to upon a button push move data from one sheet to another in the same workbook in Excel 2003? We have a workbook with three sheets, instead of having to manually copy and paste information once we have completed it from sheet one to the others we would like to create a drop down menu or button that would automatically move the data to another sheet in the workbook. Can this be done, and if so how?

Answer Wiki

Thanks. We'll let you know when a new response is added.

Review your ‘@lookup’ function under the database section of help. You’ll find useful things that will allow you to pull it out of other workbooks, maybe being worked on by someone else. The most simplest procedure is to create your formula so that where it requires the results of the cell on page one, literally go to page one and touch the cell. Excel will automatically create the reference info for you. If you don’t need to process the results of the previous page, just show it, same thing, touch the reference cell and it will appear and change as the other cell does.

I wrote a program to do contract work for customers, where page one was the totals for each section of work to be completed. On page two, were the adds created by the owner for additional fees and they were added to the base bid. Progress payments were made based upon agreed amounts of work that would be done before we could get a draw against the total. SO, in layman english, you would have Contracted Amount + Additional Work to be Performed – Progress Payments = Remaining Total Due. The command would look like this =PROPOSAL!L13+’ADDS – PMTS’!L15, where “Proposal” is page 1, the ‘!’ tells Excel that it a sheet name, then the row & column numbers on that page. In this case, page 2, ‘Adds-Pmts’ sheet has already processed some information and is requiring the info off of page one, to make it’s final summation. In the example above, the single quotes represent the active page making the call for the information.

Discuss This Question: 3  Replies

 
There was an error processing your information. Please try again later.
Thanks. We'll let you know when a new response is added.
Send me notifications when members answer or reply to this question.

REGISTER or login:

Forgot Password?
By submitting you agree to receive email from TechTarget and its partners. If you reside outside of the United States, you consent to having your personal data transferred to and processed in the United States. Privacy
  • Jaideep Khanduja
    I don’t think it is possible through a macro or set of macros. It has to be done manually as usually you are doing. And even ‘track changes’ is not going to help in this case for what you want to achieve.
    8,955 pointsBadges:
    report
  • Jaideep Khanduja
    You can do this by using an add-in from Microsoft called dataloader, see: http://www.add-ins.com/office/data_loader.htm
    8,955 pointsBadges:
    report
  • Kaylee
    [...] Original post by unknown [...]
    0 pointsBadges:
    report

Forgot Password

No problem! Submit your e-mail address below. We'll send you an e-mail containing your password.

Your password has been sent to:

To follow this tag...

There was an error processing your information. Please try again later.

REGISTER or login:

Forgot Password?
By submitting you agree to receive email from TechTarget and its partners. If you reside outside of the United States, you consent to having your personal data transferred to and processed in the United States. Privacy

Thanks! We'll email you when relevant content is added and updated.

Following