benong
10-05-2010, 08:07 PM
hi,
i have data in sheet1 column A.
i want to add worksheets(sheet2, sheet3,...) based on the data found in sheet1 column A.
The added worksheet name should be the same as each data row in sheet1 column A.
I want to add hyperlink from sheet1 column A data to each added worksheets for easy navigation.
Does anyone know how to accomplish this automatically?
Many thanks for guidance.
i have data in sheet1 column A.
i want to add worksheets(sheet2, sheet3,...) based on the data found in sheet1 column A.
The added worksheet name should be the same as each data row in sheet1 column A.
I want to add hyperlink from sheet1 column A data to each added worksheets for easy navigation.
Does anyone know how to accomplish this automatically?
Many thanks for guidance.