Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Getting data from different worksheets in another workbook
I need help using excel. I have an inventory divided into different
workbooks according to product type, each workbook contains multiple worksheets for the different providers. What I need is to be able to access the prices of the different products I have, from a different workbook, I would like a formula to acces the price according to the type of product I have and be able to use CTRL+D to propagate the formula to similar items. For example: In cell A2 I have CAPA0003 which is the product code and is stored in worksheet APA in workbook ceramics.xls and to get the price I have the formula =VLOOKUP(A2,[Ceramicas.xls]!APA,16,FALSE) all worksheets have the same format and the prices are store in column 16 The formula works perfectly but with this formula I have to type the worksheet name of each product every time. Since the worksheet name is embedded into the product code is there a way to get the worksheet name from the product code automatically so that I can copy the formula to all items in the same worksheet to get their prices? I hope the question is clear enough. Thank you |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Getting data from different worksheets in another workbook
Hi,
Merge workbooks 1. Make sure the copies of the shared workbook (shared workbook: A workbook set up to allow multiple users on a network to view and make changes at the same time. Each user who saves the workbook sees the changes made by other users.) that you want to merge are all stored in the same folder. To do this, you must give each copy a different name. 2. Open the copy into which you want to merge changes. 3. On the Tools menu, click Compare and Merge Workbooks. 4. If prompted, save the workbook. 5. In the Select Files to Merge into Current Workbook dialog box, click a copy that has changes to be merged, and then click OK. To merge more than one copy at the same time, hold down CTRL or SHIFT and click the file names, and then click OK. Challa Prabhu " wrote: I need help using excel. I have an inventory divided into different workbooks according to product type, each workbook contains multiple worksheets for the different providers. What I need is to be able to access the prices of the different products I have, from a different workbook, I would like a formula to acces the price according to the type of product I have and be able to use CTRL+D to propagate the formula to similar items. For example: In cell A2 I have CAPA0003 which is the product code and is stored in worksheet APA in workbook ceramics.xls and to get the price I have the formula =VLOOKUP(A2,[Ceramicas.xls]!APA,16,FALSE) all worksheets have the same format and the prices are store in column 16 The formula works perfectly but with this formula I have to type the worksheet name of each product every time. Since the worksheet name is embedded into the product code is there a way to get the worksheet name from the product code automatically so that I can copy the formula to all items in the same worksheet to get their prices? I hope the question is clear enough. Thank you |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Making a chart using data from different worksheets in a workbook. | Charts and Charting in Excel | |||
transferring data between 2 worksheets in same workbook | Excel Worksheet Functions | |||
How do I link data between worksheets within a workbook? | Excel Discussion (Misc queries) | |||
How do I sort data from various worksheets in the same workbook i. | Excel Worksheet Functions | |||
Linking Data between worksheets in a workbook | Excel Worksheet Functions |