Getting data from different worksheets in another workbook

[kareen20]

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

 

[Guest]

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