Home |
Search |
Today's Posts |
#1
|
|||
|
|||
Extract sheet name/number to cell
Hi, I have a long series of sheets: Sheet1, Sheet2, Sheet3 etc. In each of those sheets, i want to extract the sheet name and turn it into a reference in A1 of that sheet. So, A1 of Sheet1 would refer to cell A1 in the Main sheet (=Main!A1), A1 of Sheet2 to refer to A2 in the Main sheet (=Main!A2) etc. How can I do this? Thanks, Bertie. -- claytorm ------------------------------------------------------------------------ claytorm's Profile: http://www.excelforum.com/member.php...o&userid=11610 View this thread: http://www.excelforum.com/showthread...hreadid=382416 |
#2
|
|||
|
|||
See http://www.xldynamic.com/source/xld.xlFAQ0002.html
-- HTH Bob Phillips "claytorm" wrote in message ... Hi, I have a long series of sheets: Sheet1, Sheet2, Sheet3 etc. In each of those sheets, i want to extract the sheet name and turn it into a reference in A1 of that sheet. So, A1 of Sheet1 would refer to cell A1 in the Main sheet (=Main!A1), A1 of Sheet2 to refer to A2 in the Main sheet (=Main!A2) etc. How can I do this? Thanks, Bertie. -- claytorm ------------------------------------------------------------------------ claytorm's Profile: http://www.excelforum.com/member.php...o&userid=11610 View this thread: http://www.excelforum.com/showthread...hreadid=382416 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Chart Title or Text Box Linked to cell & sheet | Charts and Charting in Excel | |||
Does excel recognise names rather than cells? | Excel Worksheet Functions | |||
Same cell added to master summary sheet | Excel Worksheet Functions | |||
referencing a sheet named in a cell then using data from that sheet | Excel Worksheet Functions | |||
Naming & renaming a sheet tab | Excel Worksheet Functions |