Extracting data from same cell in dierent workheets and files inside a folder or sub [Archive]

View Full Version : Extracting data from same cell in dierent workheets and files inside a folder or sub

amal

10-31-2018, 12:21 AM

This is for my professional work. Actually l want to extract data from more than 1000 excel sheets . I need data from AW56 and A5 cell numbers of all these sheets. All the sheets are inside one folder but they may be in sub folders and workbooks. Can I do this task using VBA tools ? Can anyone help?