Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Excel Formulas getting information from 1 workbook to another
I have a huge customer base, 4 columns, 1st column has the number of the
customers, sceond one has name, third one has location. Because my program is so big that I cant have many on one file so I need to put my customers on a sepearate workbook, when I insert the customer number on the main workbook then I want it to access the customer number in column one, and the name in column two plus the location in column three. I understand how to do those formulas its just gettting it from one workbook to another. Thanks I appreciate the help as always. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
copy worksheet to a new workbook with formulas .... but new file not point to old one | Excel Discussion (Misc queries) | |||
Excel: Use a name with external workbook reference for data valida | Excel Worksheet Functions | |||
Excel workbook fails to display when selecting from my documents. | Excel Worksheet Functions | |||
Excel workbook does not open in open window on desktop | Excel Discussion (Misc queries) | |||
Stubborn toolbars in Excel | Excel Discussion (Misc queries) |