row does not move to bottom of list when cell is populated with date

**marrco45** · 02-27-2014, 06:42 PM

I am new to Excel and the developer portion of it. I am in need of a formula or macro that allows a row which has been populated with date in cell to be automatically moved in sequential order to bottom of completed list. Both lists are on the same sheet. Date for Column N is entered manually and rows are B2:B25. The completed list is B30:B50 currently. I want to move top rows to bottom rows when a valid date is entered. I would really apprecaite your help!

**Bhuvi** · 02-28-2014, 10:08 AM

Hi,
Welcome to the forum

This can be done with help of a macro,
Could you please attach a workbook withe sample data in it OR your original worksheet ?

**marrco45** · 02-28-2014, 10:37 AM

Thank you Bhuvi for your assitance. I most appreciate it. I have attached the sample sheet for your review.

**marrco45** · 02-28-2014, 10:39 AM

The spreadsheet I have attached does not contain all the columns I have for the original one so the cell which will be populated will be column F.

**Bhuvi** · 03-01-2014, 08:47 AM

Hi,

In the attached sheet once you fill the values in colF , you can run the macro "move rows" .
Note: the completed list should always start from row 30 and col b should not have blank values.

I hope this meets your requirements.