Trying to copy/paste rows matching a date value

[dubcap01]

Hi all,

I have a sheet ("Uplifts") with daily entries.

CallDate UpliftNumber CallNumber CPC Size Category Reason
17-Aug-15 51002247 4645778 5P1204 Pallet Picking Error Operator Error
18-Aug-15 51002293 4674543 5P1300 Case Picking Error Operator Error

I am trying to pick out any entries with today's date in column A and paste them into another sheet ("Temp"). I can't work out where this code is wrong, as it picks up the source sheet headers in Row 1 and pastes that, but not the corresponding entry from Row 3 which matches today's date. So my resulting code pastes just this in ("Temp"):

CallDate UpliftNumber CallNumber CPC Size Category Reason

Here's the code:

Please Login or Register  to view this content.

Any help or direction appreciated!

Pete

[JOHN H. DAVIS]

Does this help?

Please Login or Register  to view this content.

[dubcap01]

Hi John

Error 1004 - Select method or Range class failed
is all I got, after it pasted in the first 4 columns only of the header row, almost the same but less columns as my previous code!!

Pete

[dubcap01]

can anyone else assist please? No disrespect to John who answered above, it's just that I need to get this fixed

[JOHN H. DAVIS]

Can you attach a sample file which produces the error?

[dubcap01]

sure can John, here goes

[dubcap01]

but of course, the dates in the 'Uplifts' sheet don't now correspond to today, so you may want to play with the dates in the worksheet first

[JOHN H. DAVIS]

Try:

Please Login or Register  to view this content.

[dubcap01]

Hi John,

That did the trick!
Thanks for your help
Pete

[JOHN H. DAVIS]

You're welcome Pete. Glad to help out and thanks for the feedback.

[dubcap01]

Hey John,

Sorry to re-open this thread, but I now have a need to change the code to incorporate a StartDate and End date - is this possible?
Here's the code as is:

Please Login or Register  to view this content.

The new parameters would be Me.StartDate and Me.EndDate
Really appreciate your help mate, if I was closer I'd shout you a beer!

Pete

[JOHN H. DAVIS]

Not sure I understand. What exactly do you want to happen with the Start Date and End Date?

[dubcap01]

Sorry John, perhaps I was lax with my explanation.

The code your provided before identified rows matching today's date. It works perfectly.
What I need to do now is select a more expansive range of rows where the Date falls between between the StartDate and EndDate parameters.
It's for a weekly/monthly report scenario, and will work on historical rows that occur >=StartDate and <=EndDate.

Late Edit: This will work off another form, for reporting purposes only

Does that make more sense?

cheers
Pete

[dubcap01]

in direct terms, copy all rows with value of Column A between StartDate and EndDate and paste them to the Temp sheet, as the previous code does where value of Column A is today

Pete

[JOHN H. DAVIS]

Maybe:

Please Login or Register  to view this content.

[dubcap01]

Hi John,

Works perfectly mate, many thanks and another beer on your tab!

Pete