Excel Enthusiast
Member
I have made 3 Workbooks all have INWARD & OUTWARD sheets, having different kinds of Column Headers. Some column headers are common too. Now i want to create a daily report which should have all the data from all the sheets for everyday reporting in a new workbook. I also need to have to the option of selecting the FROM DATE & TO DATE. So, that whenever my superiors want report for the last 6 days i need to specify those dates & the report should be created.
I tried SUMIF & VLOOKUP but it's too time consuming and i might make a mistake.
So can you suggest some easier way, maybe a VBA code that can solve this issue or how to create Buttons for the Date option????
I've seen many Videos online, but not able to follow them properly.
I'm attaching the files. So please give me some clues on how to tackle this issue.
I have put in some sample data in all the sheets.
MS OFFICE VERSION 2016 PROFESSIONAL PLUS
Thank You.
I tried SUMIF & VLOOKUP but it's too time consuming and i might make a mistake.
So can you suggest some easier way, maybe a VBA code that can solve this issue or how to create Buttons for the Date option????
I've seen many Videos online, but not able to follow them properly.
I'm attaching the files. So please give me some clues on how to tackle this issue.
I have put in some sample data in all the sheets.
MS OFFICE VERSION 2016 PROFESSIONAL PLUS
Thank You.