I work in laboratory and collect my data in excel file in day and night shift separately,so I have 2 excel files for every 24 hours like 990812_M for day shift and 990812_N for night shift ,thus in 1 month I put all of these 60 files in subfolder is named 6_May ,after 1 year I have 12 subfolder for every month ,all fo these subfolders put in folder year_99.
No I want to extract data in cell for example F26 in amine sheet(My sheet name) from 720 excel file in year_99 folder and put them in another excel file (in one column and the date of file in adjacent column)to procee them like drawing graph or even count them ,because few days or nights F26 does not have datum .plz help me It is very vital for me
No I want to extract data in cell for example F26 in amine sheet(My sheet name) from 720 excel file in year_99 folder and put them in another excel file (in one column and the date of file in adjacent column)to procee them like drawing graph or even count them ,because few days or nights F26 does not have datum .plz help me It is very vital for me