Extract the data into multiple sheets

[seenuguddu]

Hi Gurus,

i need a help on this to generate the sheets in excel for Sep 1 to Sep 30

i have a main sheet with the data and need to generate the report for the every Month.

Creating multiple sheets based on the condition.

Ex:-

Sep 1:  31-Aug-2018 to 01-Sep-2018
Sep 2:  01-Sep-2018 to 02-Sep-2018
Sep 3:  02-Sep-2018 to 03-Sep-2018
Sep 4:  03-Sep-2018 to 04-Sep-2018

Please find the attached sheet for more details.

Thanks in Advance.

 

[bosco_yip]

1] Set-up a helper table for Date and SheetName in F1:H5

2] In "Main" Sheet B2, Copied across and down :

=IF($A2="","",IFERROR(VLOOKUP($A2,INDIRECT("'"&VLOOKUP(0+TEXT($A2,"dd/mm/yyyy"),$F$2:$H$5,3,0)&"'!A1:C100"),MATCH(B$1,$A$1:$C$1,0),0),IFERROR(VLOOKUP($A2,INDIRECT("'"&VLOOKUP(0+TEXT($A2,"dd/mm/yyyy"),$G$2:$H$5,2,0)&"'!A1:C100"),MATCH(B$1,$A$1:$C$1,0),0),"")))

Regards
Bosco