enter data two worksheets but not in the same cell as first

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

hi i have got five worksheet all with diffrent info in.
i wish to transfer some of the data from each worksheet
into the sixth worksheet. so info from the first would go into a1,a2,and
carry on like that there after. the ifo in the first five worksheets always
come from the same cells. so in the end the sixth worksheet will end up with
row after row of answers from the five work sheet
ei team one won
team two lost
ect
 
One way to set up a summary sheet to draw results from the 5 source sheets
Assume source sheets are identical in structure and named as: Sheet1, Sheet2,
...

In the summary sheet (Sheet6, say),

List the 5 source sheetnames across in B1:F1:
Sheet1, Sheet2, Sheet3, Sheet4, Sheet5
(ensure sheetnames entered are consistent with actual tabnames)

List the desired cell references to be extracted from each sheet
in A2 down, for example:

A2
B3
C2
etc

Then just place in B2:
=INDIRECT("'"&B$1&"'!"&$A2)
Copy B2 across to F2, fill down to populate the table

Adapt to taste ..
 
Back
Top