Help required to populate data in specified format through VBA macro

[Nitesh Mathur]

HI ,

Help required to populate data in specified format through VBA macro

I have attached sample file , which has two sheets :

Sheet1 named Datasheet : This is a data sheet in which I have updated my data.
Sheet2 named OutputSheet: This is a output sheet in which I need to populate the data (as specified in my format) and using Filter (drop down) for identifying list of people are assigned or assigning in future in selected program.



Thanks
NItesh

 

[Hui]

Datasheet D7: =IF(D$6<=DataSheet!$E2,DataSheet!$D2, IF(D$6<=DataSheet!$G2,DataSheet!$F2,IF(D$6<=DataSheet!$I2,DataSheet!$H2,IF(D$6<=DataSheet!$K2,DataSheet!$J2,"-"))))
Copy across and down

Then apply a Filter to the Output table
see attached file

 

[Hareesh_KLD]

Hi Nitesh

check the attachment
click on FillData button and see the result in NewOutput sheet
***did some changes in your data (changed date from 12/18/2018 to 12/1/2018) to make all dates uniform i.e. first day of the month

Thanks,
Hareesh