Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 1
Default 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
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Updating & Archiving Records sandy Excel Worksheet Functions 4 June 11th 09 05:43 PM
userform for updating records Terry Excel Discussion (Misc queries) 2 August 27th 08 04:16 PM
Updating old records law Excel Discussion (Misc queries) 0 December 2nd 07 03:01 PM
appending worksheet records into 1 worksheet JASelep Excel Worksheet Functions 0 September 4th 07 02:44 PM
Updating Master Log records Sinner Excel Worksheet Functions 7 June 18th 07 01:39 PM


All times are GMT +1. The time now is 04:04 PM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"