Easiest way to Copy/Paste data from Recurring Form to an Historical Data Sheet

1) Fill out the form.
2) Turn on the Macro > Recorder
3) Go through all the steps to manually copy the values to your database and reset the form for next use
4) Turn off the recorder
5) Paste the resulting code here and we'll help you streamline it into a dynamic macro
(remember to use code tags)

There is confidential information in here so I just deleted all of it and used some dummy data for a couple of the cells and figure I can repeat based on the copy/paste macro for those two that you provide. Also keep in mind that each form will be named something different (edited by the user, I have no control over this) and some of the cells are merged together (do they need to be unmerged before copy/pasting?) Code below:

Please Login or Register  to view this content.

'Opened blank Sheet(Book1) to record this macro

Please Login or Register  to view this content.

'Copied second data cell from Example Form and pasted in Historical Data

Please Login or Register  to view this content.

'Saved Historical Data and closed that sheet

Please Login or Register  to view this content.

Please edit the post above and add the code tags as reminded.

This should do it. Just expand the 'etc... part:

Please Login or Register  to view this content.

It's possible you're trying to hijack someone else's thread with a your own questions.

Be sure to read through the Forum Rules so you can use and follow them effectively.

Then post your own thread with your own proper title and your own attached sample workbooks New thread get the most new attention, too.

Originally Posted by astrodon

Jeesssh. How could it be hijacking the thread when my question is about the same damn thing?!

You know I have been involved with things like this since they were called bulletin boards and never have I had the problems from legalistic jerks that I have had on this one. Perhaps you should just remove me from this rag!

Then use a different forum, as requested you are banned

Let's see you get your hands dirty now.

'WORKBOOKS TO 1 SHEET
I have a macro for collecting data from all files in a specific folder.

Workbooks to 1 Sheet

Normally this macro just copies a whole sheet into the master database. The section marked This is the section to customize is where your current copy/paste commands would need to go instead of what is there now.

Give it a crack. No it's not easy if you've never done it before, but doing it (or trying to) will force you to learn more about macros, which is a good thing and the point of the forum.

Originally Posted by willy91785

Thank you, I will work on this and let you know if I come across any problem. Can I ask you an unrelated question since you seem knowledgeable? I am running Excel 2003 at work unfortunately and am running into issues with the 32,000 data point limit on graphs. I have more data points than that -- do you know of any fixes to include all the data?

Post new questions into new threads. New threads garner the most attention.

Originally Posted by willy91785

I just noticed that it was a coincidence that the two cells being copied (A4 and C4) were the same on both sheets. This will not be the case in reality. Does there need to be any update to the code?

You have to finish writing the code first, I just gave you the first two examples.

Please Login or Register  to view this content.