Dear Friendz..
please guide me in splitting the Input data in 3 sheets according to below conditions..
Input Sheet - This sheet contains Data Dump.
this needs to be sorted with date & then by Name.
Output1(Acc) Sheet - Contains Data for One date only from Input Sheet..
The data should be sepereate with a blank row after every "Name" change..
Output1(Rpit) Sheet - Contains Data for One date only from Input Sheet..
The data should be sepereate with a blank row after every "Name" change..
The Name "Main" should be excluded from the data.
Output1(RDce) Sheet - Contains Data for two dates from Input Sheet..
The data should be bioffurcated with dates & blank row after every name change
the sample is shown in the attached file..
Please guide.. Thank you
Bookmarks