smartpat19
Board Regular
- Joined
- Sep 3, 2014
- Messages
- 114
When we get an updated spreadsheet my job is to update the sheet to the new sheet but still have all our data we added to the old sheet. This involves checking any adds or drops. We use the address column to check.
Currently:
If the new sheet doesn’t have an address from the old sheet I cut the row and paste it in a drops tab.
If there is a new address that isn’t on the old sheet, I copy that row from the new sheet and add it to the old sheet.
We need to keep a record of the adds and the drops.
I have always used and index match formula but with it being slow right now, I would like to automate this.
I then sort the old sheet based on the new sheets order.
Having a prompt to select the columns (for old and new sheets) would be great to insure it’s the right column.
Any ideas for VBA?
Thank you, I'm using windows 7 with Excel 2013
Currently:
If the new sheet doesn’t have an address from the old sheet I cut the row and paste it in a drops tab.
If there is a new address that isn’t on the old sheet, I copy that row from the new sheet and add it to the old sheet.
We need to keep a record of the adds and the drops.
I have always used and index match formula but with it being slow right now, I would like to automate this.
I then sort the old sheet based on the new sheets order.
Having a prompt to select the columns (for old and new sheets) would be great to insure it’s the right column.
Any ideas for VBA?
Thank you, I'm using windows 7 with Excel 2013
