Help extracting all data from sheet 1 carried out within the last 7 days to sheet 2.

.

Paste in Routine Module:

Please Login or Register  to view this content.

Thanks for your advice. There is no sensitive information on this document, I opted for the photo as I have seen some programmers not agree with downloading the spreadsheet.

Anyways, I have done as requested.

Jett

Originally Posted by Logit

.

Paste in Routine Module:

Please Login or Register  to view this content.

Wow, thankyou so much for your help. It came up with an error saying subscript out of range. Did i do something wrong?

.
Are your sheets named Sheet1 and Sheet2 ... that is the most likely error area.

Please Login or Register  to view this content.

Please Login or Register  to view this content.

Sheet1 is where the data is being reviewed / copied from.

Sheet2 is where the data is being pasted to.

.
The corrections would be :

Please Login or Register  to view this content.

Please Login or Register  to view this content.

The complete macro:

Please Login or Register  to view this content.

Originally Posted by Logit

.
The corrections would be :

Please Login or Register  to view this content.

Please Login or Register  to view this content.

The complete macro:

Please Login or Register  to view this content.

Any idea why it changes the date value to a number when converting it to sheet 2 or (Jobs 7 Days) it goes from a date format to 429212, 429213 etc?

Also it doesn't filter out any entries over 7 days old. Tried adding an IF statement but that didnt work for me.

Cant thankyou enough for all your help.

.
On sheet "Jobs 7 Days" you need to highlight the Col A - Right Click - Format Cells - Date - Type - 3/14/2001 .


It doesn't filter out any dates older than 7 because you specified "equal to or less than one week" .


This line in the macro controls which dates it will filter :

Please Login or Register  to view this content.

More specifically, you can edit this portion to change the date range :

Please Login or Register  to view this content.

Originally Posted by Logit

.
On sheet "Jobs 7 Days" you need to highlight the Col A - Right Click - Format Cells - Date - Type - 3/14/2001 .


It doesn't filter out any dates older than 7 because you specified "equal to or less than one week" .


This line in the macro controls which dates it will filter :

Please Login or Register  to view this content.

More specifically, you can edit this portion to change the date range :

Please Login or Register  to view this content.

Thankyou again, formatted cells. I have read the If statement and i believe it should hide any that are older than 7 days. So why is it not doing that when I run the macro? From my understanding of reading your code it should hide anything over 8 days old but I have every bit of data copied instead.

.
I've been reviewing your data in the cells. The dates as written in some of the cells were combined with Cols B, C & D data as well.
Some of the Dates in Col A were only combined with a few other columns.

I've gone through all of the entries in Col A and made edits where required so only a DATE shows in Col A - Only a location shows in Col B - and only the complaint shows in Col C.
In the future make certain the data is entered separately into each column as designed.

Also, continue to use the same date format for entry of dates : 3/14/2001 . You can format Col A on both sheets so the date displays in that manner.

See the attached ... it should work as desired.

.
It's fairly late in London. Can't sleep ?

Originally Posted by Logit

.
It's fairly late in London. Can't sleep ?

Putting your insomnia too good use, Thankyou so much for your help. It is now working but not only that I have learned a lot and the errors in my ways.

Originally Posted by Logit

.
I've been reviewing your data in the cells. The dates as written in some of the cells were combined with Cols B, C & D data as well.
Some of the Dates in Col A were only combined with a few other columns.

I've gone through all of the entries in Col A and made edits where required so only a DATE shows in Col A - Only a location shows in Col B - and only the complaint shows in Col C.
In the future make certain the data is entered separately into each column as designed.

Also, continue to use the same date format for entry of dates : 3/14/2001 . You can format Col A on both sheets so the date displays in that manner.

See the attached ... it should work as desired.

I noticed this when editing it too, I did change it in the copy I was playing with, the joys of having multiple people enter data.

I am going to have a go at making the button delete current data on sheet 2 (Jobs 7 Days) first then populate the data. Wish me luck.

.
Great. Glad it works as you needed. Cheers !