help with a formula please

[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

 

[trip_to_tokyo]

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

=Sheet1!A1

The above will pull in data from the said sheet and cell number.

 

[dido22]

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

=Sheet1!A1

The above will pull in data from the said sheet and cell number.

 

[trip_to_tokyo]

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 -

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

 

[dido22]

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 -

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