Updating spreadsheet that makes a log of entered data

[acwenger22]

I am trying to make a spread sheet for my company that when you enter data on the main page it will automatically save the data on another spreadsheet creating a log of the data that can be looked back on.

[Mumps1]

Would the two sheets not be identical and if so, why save to another sheet?

[acwenger22]

no i work in a lab and i want the main sheet to be a collection of my results for that week while the other sheets be a log of the results for certain sample types from past weeks

[Mumps1]

Can you post a copy of your file detailing which samples from past weeks you want copied to the other sheet. It is difficult to make a suggestion unless we know what to copy over and where that data is located on the source sheet.

[acwenger22]

Here it is this isn't the full document as i am not allowed to post it due to company policies. In this document you will see the curent materials and their composition. I want to be able to change the composition in current materials and have them creat a log in the other sections.

[Mumps1]

Just to clarify ... if a value in column A in your 'Current Materials' sheet is changed, you want the row in which the change is made to be copied to the sheet 'A' and to do the same for changed values in the other columns. Is that correct?

[acwenger22]

yes and once that happens I want it so the next time i change the values it copies it onto another column in sheet a so i can look at the past results

[Mumps1]

Copy and paste this code into the module for worksheet 'Current Materials (not in a regular module). It should do the copy automatically when you enter or change the data. I'm having some trouble getting it to copy into another column properly. Right now it uses the range of columns from A to H. Change this range to suit your needs.

Please Login or Register  to view this content.

[Mumps1]

Hello again. I have managed to solve the problem of copying the data to the first blank column at the end of your data for that row. The only issue may be that you have a formula in column DL so the data is copied starting in column DM. Here is the revised code:

Please Login or Register  to view this content.