VBA Compare and Move Edits

wenyusa

Board Regular
Joined
Jan 16, 2009
Messages
50
I have a process I am working to automate using VBA. The process goes like this:

1) Data is run and put into raw data tab
2) raw data tab populates pivot table.
3) since pivots are not editable, formulas are used in another sheet to copy the data from the pivot to the new worksheet.
4) an analyst reviews the data and can type words from the key tab into a cell to overwrite the formula.
5) next month the process happens again, but last months changes don't get carried over.

I want to find where the analyst typed in their changes, record the location using the column and row headers (updated data can cause the headers to shift from time to time, to header names would likely need to be used rather than col/row numbers), and then put the changes into the new months sheet so they can continue with the updated/expanded data. Each month, the rows will grow. Columns will grow too from time to time but not regularly.

I haven't started the code yet as I am having trouble figuring out the best way to attack this and I am not professional (more beginner/intermediate). Any way to accomplish this?
 

Excel Facts

Formula for Yesterday
Name Manager, New Name. Yesterday =TODAY()-1. OK. Then, use =YESTERDAY in any cell. Tomorrow could be =TODAY()+1.
Master Excel Bundle

Excel contains over 450 functions, with more added every year. That’s a huge number, so where should you start? Right here with this bundle.

Forum statistics

Threads
1,163,517
Messages
5,832,211
Members
430,116
Latest member
d1pakjha

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Top