M
Maxwell-5000
Hello,
I am running a report with many tabs.
What I would like to do is to have the TAB of a specific sheet
reference a cell (lets say $A$1) for that specific sheet I am on.
For examble, tab 1 will reference cell $A$1 which is the name of a
person.
Tab 2 will reference another name specific to the cell and tab it is
on.
At the end, each tab should have a different name per the cell/tab it
is referencing.
How would it do this? do I need to do this in VBA? if so, can you write
the code out?
I am not VBA proficient...AT ALL...
Please help!!!
Thanks
I am running a report with many tabs.
What I would like to do is to have the TAB of a specific sheet
reference a cell (lets say $A$1) for that specific sheet I am on.
For examble, tab 1 will reference cell $A$1 which is the name of a
person.
Tab 2 will reference another name specific to the cell and tab it is
on.
At the end, each tab should have a different name per the cell/tab it
is referencing.
How would it do this? do I need to do this in VBA? if so, can you write
the code out?
I am not VBA proficient...AT ALL...
Please help!!!
Thanks