I have been sent approximately 25 different workbooks from my boss who needs
them compiled into one. Whoever designed the layout of the workbook in which
the users supplied their entries used "Drop Downs", that point to "INDIRECT"
and "OFFSET" functions all on one summary sheet. My question is, how can I
take what is on the summary sheet from the 25 different workbooks and compile
into one, without having to open each book, go to each INDIRECT function
which only displays a number, and trace it back to what text data it is
referencing? I will be happy to send a workbook to someone for you to look
at if you think you can help with a solution.

Thank you in advance

Have you tried Copy / Paste Special and choosing "Values" ?
--
Charles Chickering

"A good example is twice the value of good advice."


"Vince" wrote:

I have been sent approximately 25 different workbooks from my boss who needs
them compiled into one. Whoever designed the layout of the workbook in which
the users supplied their entries used "Drop Downs", that point to "INDIRECT"
and "OFFSET" functions all on one summary sheet. My question is, how can I
take what is on the summary sheet from the 25 different workbooks and compile
into one, without having to open each book, go to each INDIRECT function
which only displays a number, and trace it back to what text data it is
referencing? I will be happy to send a workbook to someone for you to look
at if you think you can help with a solution.

Thank you in advance

Copy paste won't work as I will try te explain below.

Data Entry Sheet with Drop Down show selected text as "Continuous"

Sheet "Summary" contains:
Cell F12 Value = "2" Cell F12 formula = "=INDIRECT("Data!E4"&(3+$A12))"
Cell F13 Value = "1" Cell F13 formula = "=INDIRECT("Data!E4"&(3+$A13))"

Sheet "Data"
Cell E42 contains the text "Continuous" which is one of the options for the
drop down box on the Data entry sheet.

If you just copy and paste values, all that gets pasted in the new cell is
the value of "2".

Thanks for the suggestion

"Charles Chickering" wrote:

Have you tried Copy / Paste Special and choosing "Values" ?
--
Charles Chickering

"A good example is twice the value of good advice."


"Vince" wrote:

I have been sent approximately 25 different workbooks from my boss who needs
them compiled into one. Whoever designed the layout of the workbook in which
the users supplied their entries used "Drop Downs", that point to "INDIRECT"
and "OFFSET" functions all on one summary sheet. My question is, how can I
take what is on the summary sheet from the 25 different workbooks and compile
into one, without having to open each book, go to each INDIRECT function
which only displays a number, and trace it back to what text data it is
referencing? I will be happy to send a workbook to someone for you to look
at if you think you can help with a solution.

Thank you in advance