Excel [Closed]

Report
Posts
1
Registration date
Tuesday April 15, 2014
Status
Member
Last seen
April 15, 2014
-
 Activetransport -
Description:
1. I have an excel workbook containing multiple sheets (about 28-33) eg. Book1 and the worksheets are labelled eg. 01-March DS, 02-March NS, 02-March DS, 02-March NS ..... 31-March DS, 31-March NS in that order

2. Each of the sheets contains similar records or parameters but on different dates and shifts.

3. So, I need to find a function or macro which will do the following: if I enter a worksheet name in a new sheet (or new workbook) eg. Sheet (02- March DS) it will find/lookup across the whole workbook -Book1 (with all the sheets) and will give the reference for the respective cell as indicated in worksheet "02- March DS".

Regards,

1 reply

Posts
1862
Registration date
Sunday June 14, 2009
Status
Contributor
Last seen
July 30, 2015
791
why do you need such a round about method.
right click the first arrow in the bottom left of the any sheet (there are four arrows).
you can see the list of sheets. click anything you want.

Thanks Venkat1926 for your reply but that is not what i am looking for. i think i did not make my point clearer.
1. Apart from Book1, i have another workbook say Book2 and for sheet 1, i have dates in rows such as

A2 =01-March DS
A3 =01-March NS
A4 =02-March DS
* = *
* = *
* = *
A*=30-Nov NS

2. So, I need to find a function or macro which will do the following: if I enter a worksheet name in a Book 2 eg. 02- March DS it will find/lookup across the whole workbook -Book1 (with all the sheets) and will give the reference for the respective cell as indicated in worksheet "02- March DS".

I hope this time is a bit clear.

Thanks for your time on my question.