Copying rows based on a matching date

[mps80y]

Hi All,

I've found so many variations on how to do this, but none seem to fit exactly what I'm after so I'm getting lost in that spiral - so I would appreciate any advice/help.

I have a spreadsheet that has several sheets.

Sheet 'Calc_Sheet' contains a value in cell E1 which lists the last date of the previous month in the format dd/mm/yyyy and is formatted as a Date field - *dd/mm/yyyy.

I have another sheet 'Previous Month' that has all the data of bookings made. Column C in that sheet also has a date in the format dd/mm/yyyy and is also formatted as a Date field - *dd/mm/yyyy

I need to copy all the rows from the 'Previous Month' sheet, that match the date in cell E1 in sheet 'Calc_Sheet' and copy them to the end of a third sheet 'Current Month' and then sort that sheet based on column A.

Is this something easily done?

TIA guys :D

 

[mps80y]

Thanks heaps for your help so far mumps. I've created a new thread here

I'll let you know if I get an answer.

 

[mumps]

Perfect. Thank you.

 

[mps80y]

After doing some research, it seems to be with the way cDate manages the date format.

I know there is probably a cleaner way to do this, but to get around it I created a new column with the date formatted as a serial then filtered and copied based on the serial then deleted the serial column.

The new file is here if you want to have a look. I've left the other post up to see if someone else has a cleaner way of manipulating the date.

 

[mumps]

Thanks so much for getting back to me and congrats on finding a work-around. It sounds good.

 

[mps80y]

No problems. Thanks again for all your help.

I've just posted a new thread hoping to get some help with index & match.

What are your thoughts on index & match vs VLookup?