Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
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 |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Combining and merging lines | Excel Discussion (Misc queries) | |||
shared workbook appending/merging rows of data from several worksh | Excel Discussion (Misc queries) | |||
Merging Workbook Data | Excel Discussion (Misc queries) | |||
Merging Workbook Table data Based upon Value comparisons | New Users to Excel | |||
Merging data in workbook | New Users to Excel |