Copying and Pasting---Another question...

[Guest]

The original question is at the bottom, but I was still struggling with it so
this is more information in the hopes that someone else can help me. Thanks!


I'm having trouble with the formula....

If my worksheets are:

Apr. 3
May 5
March 13

and I want cell B14 from every worksheet to all appear in a new worksheet.
What would my formula look like???

Thanks for your time and assistance!!

Tia

You refer to "tables" in a workbook.

Do you mean "worksheets" in a workbook?

If the latter, how are they named?

If Sheet1, Sheet2 etc. enter this formula in A1 of a sheet.

=INDIRECT("Sheet" & (ROW() & "!B5")

Drag/copy down column B.

If sheets have unique names, enter the sheet names in a column and use this
formula.

=INDIRECT(A1 & "!B5")

Assume sheet names were in A1:A10 you would copy down 10 cells.

Your ranges may differ, so adjust to suit.


Gord Dibben Excel MVP

Expand AllCollapse All

 

[Guest]

If you don't care about elegance, this is what they'd look like.

='Apr. 3'!B14
='May 5'!B14
='March 13'!B14