Alignment of column as per specific

[anish147]

Hi Team,

Please find the attached as a sample, where I have to align the data's in sheet 1 to as per the sheet 2.

- I am looking for the filter option in the date settled field in sheet 2
- Alignment of column.

Kindly help us on the formula or Vlookup or Macro to do the necessary.

Many thanks in advance.

Thanks,
Anish

[Rudi]

Have you considered a Pivot Table?
It is VERY low maintenance and flexible to manipulate the way you need it...