Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Appending/Updating records
I'm a little new to VBA but I could follow some code to
help with the following. The concept is probably easier than this explanation. I download at the end of each month from our accounting system the Name and Balance for each customer, so lets say I have Name in column A and a balance in column B. At the end of the next month I would download the data for this month on another worksheet. What I'd like to do is take each name from the second worksheet and if I found a match on the first sheet put the balance in column C. If I didn't find a name match would mean its a new account and I'd add a record to the end of the old sheet with the Name in column A and the balance in column C. On re- reading I'm saying Huh and I wrote this. Hopefully someone can help. Thanks. Michael |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Updating & Archiving Records | Excel Worksheet Functions | |||
userform for updating records | Excel Discussion (Misc queries) | |||
Updating old records | Excel Discussion (Misc queries) | |||
appending worksheet records into 1 worksheet | Excel Worksheet Functions | |||
Updating Master Log records | Excel Worksheet Functions |