Hi
I need a code for extracting some data:
1:sheets name and
2:start time and 3:end time (In column Q)
in one sheet as an example1 that I have attached : result sheet
thank you
Hi
I need a code for extracting some data:
1:sheets name and
2:start time and 3:end time (In column Q)
in one sheet as an example1 that I have attached : result sheet
thank you
Last edited by fakhteh; 05-21-2021 at 04:14 AM.
You can use these formulae in the cells stated in the Results sheet:
B1: =INDIRECT("'"&$A1&"'!Q2")
C1: =MAX(INDIRECT("'"&$A1&"'!Q:Q"))
Copy down as required).
Hope this helps.
Pete
Firstly, you have to define a formula to extract worksheet names in Name Manager.
Row row row your boat
Gently down the stream
hi
thank you for your code
but please help me to complete it you know unfortunatlly I understand that in some sheets column Q dosnt have data in related column R :
I have attached another sheet
if there is no data in R for year in Q:
1380 1067.0375
1381 1066.815
1382 1067.076667
1383 1066.878333
1384
1385 1067.460833
1386 1067.8225
1387 1067.872
1388
1389
1390
1391
1392
1393
1394
1395
then I must set start 1380 and end 1387
or another sheet
1380
1381
1382
1383
1384
1385 1078.3775
1386 1078.883333
1387 1078.348
1388
1389
1390
1391
1392
1393
1394
1395
start 1385 and end 1387
thank you
change the formulas to
Formula:Please Login or Register to view this content.
and
Formula:Please Login or Register to view this content.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks