i need to make a report using excel. im given a few data in excel document for a 1 month report (1 document for each week). each data document have a few work sheet.i need only certain information in each week data. before this i do it manually by copy-paste each information i want to a new excel where i compile all the data for the month.i want to do some automation process.the problem is i dont have any idea on how to do that. can you all help me?
my question:
how open a certain excel document?
how do i copy only certain data in that document?
how do i arrange it and paste it accordingly in a new excel document?
thanks in advance for your help