On 12/9/2009 10:25 AM, Johnny Rosenberg wrote:
2009/12/8 John Meyer<[email protected]>:
I have several sheets in a workbook with data in the same format (same
columns). I want to take that information from all the sheets and put it in
a new sheet. The data is in the same format, but I want a column on the
side that tells me from what sheet that information comes from (say, if row
1 comes from "Sheet1", I want it to print out Sheet 1). Is that possible
with a formula?
Have you tried =CELL(…)?
Doesn't have an infotype returning the sheet name.
---------------------------------------------------------------------
To unsubscribe, e-mail: [email protected]
For additional commands, e-mail: [email protected]
