Linking set of worksheets between different workbooks!

G

gp

Hi,

We have a workbook A- with 50 worksheets named as Week1 Week2 etc.
We have to create a new workbook B- with same number of worksheets, grabbing
values of 3 cells from corresponding A's worksheets.

B's Week1 will pull values from 3 cells in A's Week1
B'1 Week2 will pull values from same 3 cells in A's Week2 and so on..

HOw can this be accomplished without manually changing the SHeet name on the
formulas.
Thanks
Priya
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Averaging Data across multiple sheets 0
Please Help! Can't solve excel problem 4
Translating Formulas to Functions 0
COPY AND PASTE CUMULATIVE VALUES TO 17 SHEETS 4
Array across multiple worksheets 1
saving values to cells 2
Command of Insert and Delete column to effect in different workshe 0
Adding rows in several worksheets along with formulas 0

Top