Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
import excel data into existing excel report
I have a report that is prepared quarterly in excel, and the database is over
2500 rows of info. One column numbers( accounting number) changes quarterly and has to be entered manually, which takes forever. I can create a new report(excel file 2) that contains the unit number and the accounting number. The common denominator in both report is the unit number. Is there a way of importing the numbers from excel file 2 to excel file 1 by looking up the unit number in file 2, pick the numbers to the right and entering it in excel file 1 to the right of the same unit number? |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
import excel data into existing excel report
Depending on how your data is laid out, maybe =vlookup() or =index(match())
would work: You may want to read Debra Dalgleish's notes: http://www.contextures.com/xlFunctions02.html (for =vlookup()) and http://www.contextures.com/xlFunctions03.html (for =index(match())) Viggoros wrote: I have a report that is prepared quarterly in excel, and the database is over 2500 rows of info. One column numbers( accounting number) changes quarterly and has to be entered manually, which takes forever. I can create a new report(excel file 2) that contains the unit number and the accounting number. The common denominator in both report is the unit number. Is there a way of importing the numbers from excel file 2 to excel file 1 by looking up the unit number in file 2, pick the numbers to the right and entering it in excel file 1 to the right of the same unit number? -- Dave Peterson |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
TRYING TO SET UP EXCEL SPREADSHEET ON MY COMPUTER | New Users to Excel | |||
how do I import data (distance and time) from MapPoint to Excel? | Excel Discussion (Misc queries) | |||
Printing data validation scenarios | Excel Worksheet Functions | |||
Import data from files with different names to EXCEL D'base. | Excel Discussion (Misc queries) | |||
how do i import data from excel, sort it then that information is. | Excel Discussion (Misc queries) |