| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Worksheet Tab Name
Worksheet Tabe Name
In MS EXCEL, I am pulling in some records from Access Database. using Import External Data feature. I am looking for a particular country and importing the data. The First Column contains the country. Is there anyway, the SHEET NAME to get renamed automatically by looking at Country name in Cell A1. If the country name is €śSingapore€ť, the worksheet tab should get changed to Singapore. When I import data next time into the same sheet for €śJapan€ť, the worksheet tab should change to €śJAPAN€ť automatically. |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Search one worksheet for values in another worksheet? | Excel Discussion (Misc queries) | |||
| Worksheet not showing up in VBE | Excel Worksheet Functions | |||
| Inserting Filtered RC cell information into other worksheets | Excel Discussion (Misc queries) | |||
| Search/Match between 2 x separate Worksheets and populate result in third worksheet | Excel Discussion (Misc queries) | |||
| Weekly Transaction Processing | Excel Worksheet Functions | |||
Threaded Mode
