How do I insert a blank row if the previous row is not = to TODAY?

[gmr4evr1]

Howdy y'all,
I have used this forum A LOT to gain the knowledge that I now have. I still have a lot to learn though. Anyhow, it's been a while since I've needed some help, but alas, here I am asking for help.

I have a user form that when the update button is clicked, it places all the data on the next available row. What I'd like to do is...If the previous row in column A (date column) is not = to TODAY, then insert a blank row and then place the data in the row after the blank row. Basically, for every day change in the date column, add a blank row.

Thank you in advance, and a BIG thanks to all those that have helped in the past!

[protonLeah]

Please Login or Register  to view this content.

[Jim885]

something like this?

Please Login or Register  to view this content.

Not sure what you are doing, but this will get you there with maybe a little bit of modifying

[gmr4evr1]

Thank you both. I have placed both of your codes (not at the same time) into my existing code and wasn't able to get either one to work yet. I will keep modifying and trying. If I cant figure it out, I will let y'all know. In the meantime, here is a before and after:
Insert row if date not today.xlsx

EDIT* IN the attached on the first sheet (BEFORE) is the result I'm getting. The 2nd sheet (AFTER) is the result I want. If the last rows date is not today, then insert a blank row after the last row and place the data after the blank row. If the date is today, then place the data in the next empty row. So, if all the dates are the same, they will be placed in continuous rows. If the date in the last row is different from today then add a blank row then place data after the blank row.

Sorry, That explanation was a bit repetitious.

[Jim885]

Since I don't know how your user form is laid out, I'm not sure I, or anyone can provide exactly what you need. So, here's my last attempt to give you something you can work with. Hope it helps. I also assumed that new entries would have a newer date than the previous row, hence the change in code to using "<"

You will still need to modify it to suit your Userform, but it does what you describe. I tested it on your workbook.

Please Login or Register  to view this content.

[protonLeah]

Please Login or Register  to view this content.

[gmr4evr1]

Again, thank you both. I haven't been able to test these yet, and might not be able to for a couple of days. As soon as I try it out, I will let you know how it goes.

[mikerickson]

Where you currently have

Please Login or Register  to view this content.

use

Please Login or Register  to view this content.

[gmr4evr1]

Ok, I tried but failed epically. Below is the last code I tried (in red) along with the code for my userform. I tried different variations of each of the provided codes and was unable to get any of them to work properly. All of them still place the data on the very next row instead of skipping a row if the previous rows date is not today. The code highlighted in orange is another one that I tried to use.

Please Login or Register  to view this content.

[jaslake]

Hi Tom

It'll be something like this...you'll need to adapt the Code to your UserForm...

Please Login or Register  to view this content.