Hi,
I have created different tables on different sheets from a3:m50...... 1 table on each sheet
in cell A1 I have entered a value which is showing as tab name...
I want A1 value as table name of that sheet.
Is is possible?
If yes thanx in advance
Hi,
I have created different tables on different sheets from a3:m50...... 1 table on each sheet
in cell A1 I have entered a value which is showing as tab name...
I want A1 value as table name of that sheet.
Is is possible?
If yes thanx in advance
Attach a sample spreadsheet with expected results, remove any sensitive data, create a mockup example if necessary.
Use the Go Advanced option at the bottom of the page then scroll down to Manage Attachments as the "paperclip" method does not work on this forum.
Regards
Special-K
Ensure you describe your problem clearly, I have little time available to solve these problems and do not appreciate numerous changes to them.
Please find the attachment of sample
I want value in cell A1 of every sheet as table name for every sheet
Are you saying
You want the tab name fior every sheet to appear in A1?
You can do this using
in A1
=MID(CELL("filename",A1),FIND("]",CELL("filename",A1))+1,255)
No,
I don't want tab name ... for that there is a macro which I have already added in the file
I want value in Cell A1 as name for table which I have created on those sheets.
For table1 i.e. in Date 15-02-2016 sheet the table name must be change as Date 15-02-2016 instead of Table1
& rest of others tables as per the sheet names
In tab 15-02-2016 you have named range called Table1
You want to change the name of the table to 15-02-2016 ?
You cant do that, Excel will return an error.
The reasons why are displayed on the error window.
in cell A1 I have mentioned text that is
date 15-02-2016
I want this text as table name for table1 in same sheet
Just edit the table name under Formulas / Name Manager
ACtually I knew it ... but i want is there any macro to rename it automatically....
I am not a macro expert, though quite why you didnt explain it simply like that in the first place I don't know.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks