Recording the History of Multiple Cells at the Same Time

Hello,

So I will just say that this topic has most likely been covered and I have read a few other threads concerning alterations of it. However, I have seen administrator's saying to create a new thread to get specific responses tailored for a specific situation and to not ask a question on someone else's thread. So here it is :D.

I am looking to record the history of multiple cells at one time instead of as soon as I hit enter after changing one cell's value. There are other threads concerning just the history of a single cell as you input another value and hit enter.

So for example, I have multiple cells that are calculated using formula's in their respective cells using input cells in the worksheet. I will be changing the input cell's values in the worksheet to update the calculated cells. I want to record the input cell's values as well as the new calculated values at one time after changing the input cells. I dont know if I can add a button to a cell or something to that accord to accomodate this. I am still new to vba coding in excel.

From there forward I will interate this as new situations arise and want to record the input and output (calculated) cells on another tab or worksheet along with the date it was recorded.

Please let me know if I am confusing or unclear about any part of this. Thank you ahead of time for any help or responses concerning this topic.

Kind Regards,

Mlumpy1225

I can think of a couple of ways to do this. However, to make it easier, could you upload a copy of your workbook (with any sensitive information removed) which depicts clearly what you want to where.

stnkynts,
Thank you for your response. Today will be a very busy day for me and I will try to upload a copy of the workbook tonight. Just wanted to let you know that I saw your post and I will respond when I have a minute or two to upload. Thank you for your time and help with this.

Regards,

Mlumpy1225

I apologize for the delay. I have attached a workbook with all proprietary information removed and random numbers (1-9) used. In the Calculation sheet I have 1-9 in the first column and on the second workbook is where I would like to record them with the date added at the end. The first row in the second workbook will be used for cloumn headers to know exactly what is in each column. Please let me know if you need more information. Thank you again for your help and time with this.

Kind Regards,
Mlumpy1225

From my perspective, your attached workbook indicates that you want Sheet "Calculation" Range A1-A9 to be copied to Sheet "Records" in the row instead of as a column. You then want the date of transfer placed in Sheets "Records" column J of that transfered row. If you need it to do more than that you need to clearly identify it on the workbook. You can create a command button and assign this code or just run it as normal if you wish.

Please Login or Register  to view this content.

I think I should have made the workbook not a transpose. Some of my excel files work like this but others do not. I appreciate the help. Looking at your code I am starting to see how some of the syntax works with VBA. The following question should take care of the rest of my workbooks.

If I want any cell "x" in ws 1 to be copied to location "y" in ws 2, is there a way to group multiple cell copies into one command?

so:
ws1 A1 to ws2 B2
ws1 C4 to ws2 C2
ws1 F8 to ws2 D2
ws1 C3 to ws2 E2

Basically is there a way to code any cell in worksheet 1 to copy to worksheet 2? Then can I group multiple cells to together to have them all copy over at one time?

I have attached a workbook to show the above. It is the same situation, I would like for all three cells to copy over at one time.

Once I can understand this then I can adapt this for my much longer workbooks.

Once again, thank you for your help. It is most appreciated.

Mlumpy1225