Extract Info from 1 sheet to the next

Here's what I think I want, I would like to click a button to move certain information from one sheet to the next. I've attached an example with the 2 sheets and cell references of which I'll need. Idea being data entry and calculation on one sheet then information stored and archived for a period of time to generate some reports on later so each entry you would copy and paste on to another and then you would clear the page and do it again.

This is the code that you can use. Just copy it over to the Module. Open the excel file, click on Alt+F11. In the VBE Editor, right click on Microsoft Excel Objects. Then Insert -> Module. Copy the code and save.

I have even included the code to clear the cells in the "Entry" tab for the next person's information. The formulae fields will be untouched.

Please Login or Register  to view this content.

I receive an error on this line...

Please Login or Register  to view this content.

Not sure what to do next.

What is the error you are getting? I had tested it before providing it to you and it worked perfectly.

Run-time error '1004': Application-defined or Oject-defined error

This is the error message that I have received.

Could it be the difference between Excel Versions? This work book was written to run in 2003 but it was all built in 2007. Again I'm a noob just a thought.

Originally Posted by arlu1201

I created the macro in 2007 and ran it in 2007 and it works perfectly. I am not sure why you should get the object defined error. The code resides in a module right?

Yes, it is installed in a module.

If I open the workbook exactly as I sent it to you and pasted in the code and ran it, it works fine. But if I got into the "archive" tab and remove the information back to a state of having nothing but the headers that is when I receive the error. If I input data back into the archive manually then try to run it, it seems to work. Sorry but thats the best explanation I can give.

Ok. I got your issue. I have modified the code a bit. You can use this. It works perfectly in the archive tab even if you leave just the header there.

Please Login or Register  to view this content.