Hi, i have got a database which has about 6k rows, every month i get about 200 fresh data (rows) which i have to add to the database. the trick is these fresh entries can be in any part of the database, but the best part is the existing data will match with the fresh database
For e.g.
existing database next month output
item value 1 item value 2 item value 1 value 2
a 10 a 20 a 10 20
b 20 aa 10 aa 20 10
c 30 b 30 b 30 30
c 40 c 40
I will have to search where this aa has been added and insert a new row and the data to it. and i have to do it for the whole 6k rows!
Can anyone pls suggest a way / macro to solve this issue. It would be of great help
Thanks
Bookmarks