LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 16
Default Merging/Combining workbook data

I have two workbooks, one worksheet in each.
Workbook one contains customer data A1:K362 Column C is blank and is where
I need to enter the cutomers fgt acct numbers which are in workbook two.
ColA ColB ColC ColD ColE
Cust# FgtCarrier FgtAcct# CustName CustAdd

Workbook two contains two columns A1:B570
ColA ColB
Cust# FgtAcct#

ColA from both worksheets contain the customer numbers, although not all
customers are listed on the worksheet in workbook one. I need to fill in ColB
with the fgt account numbers. Rather than manually going through both lists
to match up customer acct. and then enter the corresponding fgt. number I am
hoping there is another way. If the cust numbers in ColA match on both
worksheets than enter the fgt acct number for the corresponding cust. acct
(located in ColB on workbook2) in ColC on workbook 1.

Thank you

Lee
 
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
Combining and merging lines Dawn Excel Discussion (Misc queries) 1 January 3rd 08 03:44 PM
shared workbook appending/merging rows of data from several worksh Smilingout_loud Excel Discussion (Misc queries) 1 December 26th 06 07:52 PM
Merging Workbook Data lee Excel Discussion (Misc queries) 1 October 3rd 06 10:12 PM
Merging Workbook Table data Based upon Value comparisons jayceejay New Users to Excel 5 January 8th 06 11:28 PM
Merging data in workbook y_not New Users to Excel 2 February 16th 05 03:14 PM


All times are GMT +1. The time now is 09:37 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"