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.
|