i am new to this forum. hope that someone will be able to help me. i have a file (report that i pull out of SAP) with a list of customers and the aging (1-30, 31-60 etc)...daily, i write comment next to each of them..to remind me when to call, when they will pay...
the next day i pull the same report out of SAP. is there a way that i can update automatically the new file with the comments without using vlookup? maybe a macro... i can't attach a file, for some reason i get an error all the time, but the file looks like this:

Customer Customer name Balance Credit Total Past due 1-30 31-60 61-90 91-180 180-365 Comments

thank you in advance for your help.