macro need to create a new column for location

hi all,

attached file is the system generated report in sheet 1. i have location name in cel B2 and B8.

what i want a macro which can create a clomn and copy and paste location from above cells to all the way down from location to another location. so that i can filter location wise date. Sheet 2 is my requirement.

If any one help me out, will be highly appreciated.

Thanks in advance.

Hi tariqnaz,

Instead of VBA, why not put this formula in C2 and pull it down?

Formula:

Please Login or Register  to view this content.

FillDown with formula.xlsx