Excel
Closed
Activetransport
Posts
1
Registration date
Tuesday 15 April 2014
Status
Member
Last seen
15 April 2014
-
15 Apr 2014 à 20:05
Activetransport - 24 Apr 2014 à 18:06
Activetransport - 24 Apr 2014 à 18:06
Related:
- Excel
- Excel mod apk for pc - Download - Spreadsheets
- Kernel for excel repair - Download - Backup and recovery
- Vat calculation excel - Guide
- Arrow keys not working in excel - Guide
- Excel clear formatting - Guide
1 response
venkat1926
Posts
1863
Registration date
Sunday 14 June 2009
Status
Contributor
Last seen
7 August 2021
811
16 Apr 2014 à 01:25
16 Apr 2014 à 01:25
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.
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.
24 Apr 2014 à 18:06
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.