Hi,

I'm new to VBA and have managed to put together some basic VBA i.e. delete blank rows.,I am now stuck (extensive googling hasn't turned much up).

I am looking to use VBA to find a DD/MM/YYYY within a range in Sheet 2 (column A), so that when it finds a DD/MM/YYYY to insert that date's cell's row into the closest match of DD/MM/YYYY in column J on Sheet 1.

I am using this for weekly work, so the data in sheet 2 will always be a Monday (Previous, Current and Future). I need to insert the dates into Sheet 1 by week. Sheet 1 is sorted by DD/MM/YYYY (old to new).

Any help is much appreciated.