help with a formula please

  • Thread starter Thread starter dido22
  • Start date Start date
D

dido22

Hello,

I have a workbook with several sheets. The 1st sheet is called 'Sums', and
is used to analyse and summarise the data from one of the other sheets.

At the moment I just use copy & paste to copy the data from e.g. sheet
'March' into 'Sums'. This is OK, but it would be nice to be able to enter a
string 'March' into a cell in sheet 'Sums' and have the sheet pick up the
correct data automatically. I can see how to do this (I think) but it is a
bit messy, .

Is there an elegant way of doing it ?

Thanks

KK
 
Hello,

I have a workbook with several sheets. The 1st sheet is called 'Sums', and
is used to analyse and summarise the data from one of the other sheets.

At the moment I just use copy & paste to copy the data from e.g. sheet
'March' into 'Sums'. This is OK, but it would be nice to be able to entera
string 'March' into a cell in sheet 'Sums' and have the sheet pick up the
correct data automatically. I can see how to do this (I think) but it is a
bit messy, .

Is there an elegant way of doing it ?

Thanks

KK
Click to expand...

=Sheet1!A1

The above will pull in data from the said sheet and cell number.
 
Thanks, but this means I have to edit 'Sheet1' in every cell if I want
'Sheet2' ?

K


Hello,

I have a workbook with several sheets. The 1st sheet is called 'Sums', and
is used to analyse and summarise the data from one of the other sheets.

At the moment I just use copy & paste to copy the data from e.g. sheet
'March' into 'Sums'. This is OK, but it would be nice to be able to enter
a
string 'March' into a cell in sheet 'Sums' and have the sheet pick up the
correct data automatically. I can see how to do this (I think) but it is a
bit messy, .

Is there an elegant way of doing it ?

Thanks

KK
Click to expand...

=Sheet1!A1

The above will pull in data from the said sheet and cell number.
 
Thanks, but this means I have to edit 'Sheet1' in every cell if I want
'Sheet2' ?

K







=Sheet1!A1

The above will pull in data from the said sheet and cell number.- Hide quoted text -

- Show quoted text -
Click to expand...

No, just copy the formala and you will get the relative references.
 
OK thanks, I think I understand

K
Thanks, but this means I have to edit 'Sheet1' in every cell if I want
'Sheet2' ?

K







=Sheet1!A1

The above will pull in data from the said sheet and cell number.- Hide
quoted text -

- Show quoted text -
Click to expand...

No, just copy the formala and you will get the relative references.
 
Back
Top