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?
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?
