Copying Headers/Titles from one Table to Another

[steveh1873]

Hi All,

I have the following issue that I'd like assistance with.

I have 12 spreadsheets named 'Jan' - 'Dec' that all have an absence tracker in a tabulated format.

What I'm aiming to do is input staff names on the January worksheet and for February-December to populate their tables respectively with the exact same data.

What I have tried up until now is the following;

Within 'Feb', cell A5, I have tried simply typing "=" and then clicking cell A5 in 'Jan' which returns the following =tblJanuary[@Eco].

This ultimately returns "0" and not the name that's currently in cell A5 in 'Jan'.

Thanks in advance, all assistance is gladly welcomed.

[bmouse]

This should work, perhaps the cell formatting is off?

I wonder, if you need the exact data in all sheets, why not just duplicate the entire sheet?

[bmouse]

The formula should look like this =Sheet1!A1

[steveh1873]

Thanks for the reply,

I've just solved it now having used your latest reply.

For some reason, (I can only assume because it both cells are in their respective tables) it wouldn't work and defaulted to '=tblJanuary[@Eco]'.

What I've done for now is to manually type '=January!A4' and it has now returned the correct value.

For now it's a solution and it works but I'd still like to know how to get around the copying from one table to another.

Thank you for your brisk reply

[bmouse]

So, can't you just duplicate the entire sheet and work your way from there?

[steveh1873]

Thanks for the reply,

I've just solved it now having used your latest reply.

For some reason, (I can only assume because it both cells are in their respective tables) it wouldn't work and defaulted to '=tblJanuary[@Eco]'.

What I've done for now is to manually type '=January!A4' and it has now returned the correct value.

For now it's a solution and it works but I'd still like to know how to get around the copying from one table to another.

Thank you for your brisk reply