Filter Cells by Date & Paste to Another Sheet

[lsteinbach]

I have 900 rows of data of which there is a cell in each row that designates the date the data was entered.
I made another sheet where I'd like to run a macro that will go through each row and determine if the date the data was entered is >= the (current date - 1).
This way I would have all data entered within the past 24 hours.

I am not anywhere near a programmer, but this is what I thought of:

for i = 1 to 900
if "N " & i + 1 >= "todays date" - 1

[lsteinbach]

I have 900 rows of data of which there is a cell in each row that designates the date the data was entered.
I made another sheet where I'd like to run a macro that will go through each row and determine if the date the data was entered is >= the (current date - 1).
This way I would have all data entered within the past 24 hours.

I am not anywhere near a programmer and most of my code is junk, but it should paint a picture of what I'm trying to accomplish (the date is in column N in each sheet):

Please Login or Register  to view this content.

Thanks in advance!

Luke

[lsteinbach]

I just realized I made a mistake in the paste location.
It would be in sheet "Daily Data" but in row i + 1, not in cell "N".

[Oredigger90]

This is what I would do, more or less. If you post an example before/after file I can write it specifically.

Please Login or Register  to view this content.

[lsteinbach]

Thanks for the post. Your code looks very close to what I'm trying to accomplish. I tried tweaking it myself to no avail. The changes I'm looking for:
I'd like to run the macro once I open the file, so the code would select the sheet "All Data" then copy the rows that have the data entry of "date - 1" from column "N" and paste those rows into the next available row in a different sheet called "Daily Data".
Thats all Ihave for now. Once I have the daily data, then I have to see how I want to sort it in order to graph. But this macro will do wonders for me since I'll be able to adjust it to copy data from the past week or past month as well.
Thanks, again, in advance.

Luke

[lsteinbach]

Someone else on this forum help me get this, but it wasnt perfect for my application. I've been trying to tweak it all morning, but for whatever reason, my if statement only copies the first row of data to the other sheet instead of all the rows which pass the condtion.

In case you cant tell from the code, I'm comparing the dates in column N to the current date minus 1. If the date is greater than (within the past 24 hours) then it copies that whole row and pastes it into the same row on another sheet. FYI: my level of competency with macros is very elementary. Thanks in advance! - Luke

Please Login or Register  to view this content.

[shg]

Please Login or Register  to view this content.

Make sure that the correct sheet is active when the code runs.

[Cutter]

Hello , and welcome to the forum.

Unfortunately you have inadvertently broken one of the forum rules. Please read the following. Thanks.

You have posted duplicate threads and, thereby, broke Rule 5 of our forum rules. The duplicate threads would normally be closed but on this occasion they have been merged. Please continue in the one thread until it reaches a conclusion.