Absolute Sheet Reference
 

I have sent out a large number of copies of a 'questionnaire' style workbook,
which are being returned to me as separate files. In order to analyse and
collate the large amount of numerical data, I have developed a 'summary'
sheet that draws information out of the various worksheets within each
workbook. I had hoped to copy one 'summary' worksheet into each of the
returned workbooks and then copy the summary sheets into a 'master' workbook.

I know it is possible to create absolute cell references using the $ sign,
but need what can best be described as an 'absolute sheet reference' to stop
external references appearing when I copy the 'summary' worksheet to the
different workbooks.

Does anyone have any suggestions please?

Many thanks
Richard

Absolute Sheet Reference
 

Try explaining that with concrete examples: say 3 files with 2 sheet in each
best wishes
--
Bernard V Liengme
Microsoft Excel MVP
http://people.stfx.ca/bliengme
remove caps from email

"richardgsmith" wrote in message
...
I have sent out a large number of copies of a 'questionnaire' style
workbook,
which are being returned to me as separate files. In order to analyse and
collate the large amount of numerical data, I have developed a 'summary'
sheet that draws information out of the various worksheets within each
workbook. I had hoped to copy one 'summary' worksheet into each of the
returned workbooks and then copy the summary sheets into a 'master'
workbook.

I know it is possible to create absolute cell references using the $ sign,
but need what can best be described as an 'absolute sheet reference' to
stop
external references appearing when I copy the 'summary' worksheet to the
different workbooks.

Does anyone have any suggestions please?

Many thanks
Richard

Absolute Sheet Reference
 

Hi,

Consider replacing things like
=Sheet3!A1 with
=INDIRECT("Sheet3!A1")

--
If this helps, please click the Yes button

Cheers,
Shane Devenshire


"richardgsmith" wrote:

I have sent out a large number of copies of a 'questionnaire' style workbook,
which are being returned to me as separate files. In order to analyse and
collate the large amount of numerical data, I have developed a 'summary'
sheet that draws information out of the various worksheets within each
workbook. I had hoped to copy one 'summary' worksheet into each of the
returned workbooks and then copy the summary sheets into a 'master' workbook.

I know it is possible to create absolute cell references using the $ sign,
but need what can best be described as an 'absolute sheet reference' to stop
external references appearing when I copy the 'summary' worksheet to the
different workbooks.

Does anyone have any suggestions please?

Many thanks
Richard

Absolute Sheet Reference
 

Many thanks Shane

Problem solved!


Richard

"Shane Devenshire" wrote:

Hi,

Consider replacing things like
=Sheet3!A1 with
=INDIRECT("Sheet3!A1")

--
If this helps, please click the Yes button

Cheers,
Shane Devenshire


"richardgsmith" wrote:

I have sent out a large number of copies of a 'questionnaire' style workbook,
which are being returned to me as separate files. In order to analyse and
collate the large amount of numerical data, I have developed a 'summary'
sheet that draws information out of the various worksheets within each
workbook. I had hoped to copy one 'summary' worksheet into each of the
returned workbooks and then copy the summary sheets into a 'master' workbook.

I know it is possible to create absolute cell references using the $ sign,
but need what can best be described as an 'absolute sheet reference' to stop
external references appearing when I copy the 'summary' worksheet to the
different workbooks.

Does anyone have any suggestions please?

Many thanks
Richard