Previous Topic Next Topic

Excel

Closed
Activetransport Posts 1 Registration date Tuesday April 15, 2014 Status Member Last seen April 15, 2014 - Apr 15, 2014 at 08:05 PM
 Activetransport - Apr 24, 2014 at 06:06 PM
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,
Related:

1 response

Answer 1 / 1
venkat1926 Posts 1863 Registration date Sunday June 14, 2009 Status Contributor Last seen August 7, 2021 811
Apr 16, 2014 at 01:25 AM
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.
0
Activetransport
Apr 24, 2014 at 06:06 PM
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.
0

Similar discussions

Date formatting in dd/mm/yyyy
nisha -
appu -

11 responses
How to calculate positions (1st,2nd,3rd...) in Excel
hardy -
TrowaD -

6 responses