LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
TK TK is offline
external usenet poster
 
Posts: 177
Default Match,Update & insert new data - Please HELP!

I have a master.csv (source) and myrpt.xls (destination)file, I need to match
the acct#.
1) if acct# match update the amount (total column)
2) if acct# don't match insert new data (Account, State & Total) from master
to myrpt to next blank row.

Master.csv
A B D E F
ACCOUNT State PAST_60 PAST_90 TOTAL
11-12792 CA 225.15 886.44 1,111.59
11-25851 ME 591.94 130.80 722.74
11-32239 AZ - 2,676.00 2,676.00
11-34849 AR 1,350.00 900.00 2,250.00
11-35239 ID 135.67 134.42 270.09
11-40015 CO 106.75 353.74 460.49


myrpt.xls (sheet1)
A B C
ACCOUNT State TOTAL
11-25851 ME 650.74
11-35239 ID 150.00

Thank you in advance.
 
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
INDEX/MATCH update limitation mariekek5 New Users to Excel 3 June 5th 09 11:25 PM
How to insert a row and not update existing formulas? Bobshaw Excel Discussion (Misc queries) 2 November 17th 08 09:36 AM
Data Validation lists update orginal cell with list update [email protected] Excel Worksheet Functions 3 July 11th 08 07:56 AM
Update of cell values after insert row? dazman Excel Worksheet Functions 2 August 23rd 05 07:07 AM
insert into a cell the last update Ramiro Cubillan Excel Worksheet Functions 1 December 29th 04 08:45 PM


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

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

About Us

"It's about Microsoft Excel"