Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
find and copy data from one sheet to another
Hi All, I'm running Excel97 on Win2K and need some advice.
I have a workbook with several worksheets (revenue workbook). One of the worksheets gets filled in with user data. One of the pieces of data is a store number. Another workbook (store information) on the same machine has the store information such as address, zip, phone, contact info, etc. I need to get the information from the information workbook to the revenue workbook upon entering of the store number. I.E. if someone enters store number 111, I want all of the address and contact information taken from the information workbook and populated in the revenue workbook. Thanks |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Urgent:Find match between two worksheets and copy to another sheet | Excel Worksheet Functions | |||
find and copy to another sheet | Excel Discussion (Misc queries) | |||
visual basic. find copy row past into new sheet | Excel Worksheet Functions | |||
Macro to find matching date and copy values to another sheet | Excel Discussion (Misc queries) | |||
Find text in cell, copy row to new sheet | Excel Discussion (Misc queries) |