Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Merge data from one sheet to another
Have one workbook with two worksheets (Store Number and Store
Database) Store Database has these headers Store Address City Zip Phone Number There are 3000 different stores with this information on this worksheet Store Number currently has the identical headers. Store Address City Zip Phone Number Here is the difference though and our challenge. We get a list of stores each week that we need to do a match from the Store Database sheet. So if Store number worksheet had 23 in A1 it would retrieve the address, city,zip and phone number from the Store Database sheet that has the same store number. This would happen to various amounts of stores. Meaning sometimes our Store Number worksheet would contain 1000 stores, sometimes more , sometimes less. The store number list is supplied and we just copy it to the Store Number worksheet. Thoughts, Ideas, help <grin Thanks |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How can you merge data from one sheet to another sheet which has . | Excel Discussion (Misc queries) | |||
How to merge data in Excel - one sheet to template sheet? | Excel Worksheet Functions | |||
Merge data from one sheet to another and print | Excel Programming | |||
I have 100 excel sheets how can I merge all data into one sheet | Excel Worksheet Functions | |||
merge data in different excel sheets of same format in one sheet | Excel Worksheet Functions |