I want to transfer data from excel files to one excel sheet. Not all data but few.
ex: 50 excel character files & 1st row sheet 1 contain prices & some other details. I want to transfer only price value fo all 50 files to one excel file. how can I do it?