Concatenate function...same spread sheet different tabs

[saffrondbull]

Hi,

I want to concatenate two columns in a separate tab but when I do, the values appear as =Sheet1!I$8,Sheet1!J$8,...instead of Sheet1!I$8,Sheet1!I$9,etc. Pls help.

Thanks

 

[Smitty]

Welcome to the Board!

Sorry I'm getting in on this late (we had a power outage at work).

Lemme see if I get this right:

You have student names in sheet 1 from I8 down/vertically and you want to populate them in the other sheets across/horizontally instead of down?

If so, then I think you're looking for INDIRECT as opposed to CONCATENATE:

=INDIRECT("Sheet1!I"&COLUMN()+7)

Assuming that you're starting at column A on the other sheets.

Hope that helps,