Absolute Sheet Reference

[richardgsmith]

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

 

[Bernard Liengme]

Try explaining that with concrete examples: say 3 files with 2 sheet in each
best wishes

 

[Shane Devenshire]

Hi,

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

 

[richardgsmith]

Many thanks Shane

Problem solved!


Richard

Hi,

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

--
If this helps, please click the Yes button

Cheers,
Shane Devenshire