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 |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
find and copy data from one sheet to another
I guess I should have said that cell A1 in the information
workbook has the store number and I'm asking the user to enter the store number in cell A1 in the revenue workbook, so what I need to do is as soon as the user enters the store number into A1 of the revenue workbook I need to performa lookup in cell A1 of the information workbook. When I find a match I need to copy the store information from cells A2 to A7 of the information workbook into cells A2 to A7 of the revenue workbook...does this make sense??? Thanks -----Original Message----- 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 . |
Reply |
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) |