Home |
Search |
Today's Posts |
|
#1
|
|||
|
|||
Matching data from seperate excel files
I need to match data from 2 seperate excel spreadsheets.
Where the same data (ie a reference number) appears in the 2 spreadsheets, I want the reference number and other data such as invoice number and date to be pasted to the first file in the same row as where the reference number appears in the first file. |
#2
|
|||
|
|||
Matching data from seperate excel files
Hi
Something like ='C:\My Documents\My Excel Files\[My Source Workbook.xls]SourceSheet'!A2 or =IF('C:\My Documents\My Excel Files\[My Source Workbook.xls]SourceSheet'!A2="","",'C:\My Documents\My Excel Files\[My Source Workbook.xls]SourceSheet'!A2) -- Arvi Laanemets ( My real mail address: arvil<attarkon.ee ) "Stephen H" <Stephen wrote in message ... I need to match data from 2 seperate excel spreadsheets. Where the same data (ie a reference number) appears in the 2 spreadsheets, I want the reference number and other data such as invoice number and date to be pasted to the first file in the same row as where the reference number appears in the first file. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
AHHHH-Get Data from Multiple Excel workbooks | Excel Discussion (Misc queries) | |||
Excel Files Acting Weird | Excel Discussion (Misc queries) | |||
How do i copy columns of data in notepad into microsoft excel? | Excel Discussion (Misc queries) | |||
Pulling data from 1 sheet to another | Excel Worksheet Functions | |||
How do I merge 2 Excel files, each with different names and data?. | Excel Discussion (Misc queries) |