Userform to get data from database

Hi all,

I need to make one userform that can take data from a specific range
of date from a specific range of data.
Attached is the sample worksheet i'm working on.
In Sheet1 is the userform & Sheet2 is the database.

(Note : Database information is a daily update basis)

Thank you in advance

Dear davesexcel,

I'm still new with this vba stuff. I need to put this code in a module
then assigned it to a button, right?
Can I directly copy this code to my sample file?
or do I need to edit something..

FYI, I received error dialog box that "Runtime error 1004: Unable to get average property
of the worksheet function class"

Thank you

Check the davesexcel's attached file.
And you can copy the code directly to your worksheet.

Dear davesexcel,

I have tried the file on my PC, but received Runtime error 1004 again,
with "No cells were found" dialog box.
Is there any setting that I need to change on my PC?

Thank you

Dear davesexcel,

I have tried the file on my MS Office 2007 & 2010, but same error appeared.
Is it because of the AutoFilter?
Please guide me.

Thank you

Dear davesexcel,

I'm really appreciate your reply. However I still can't make
the file running smooth.
FYI, I have changed the macro code accordingly (with the if statement).
But it does not copy any data, and it copy the range header only (refer below image)

Capture.PNG

Then, I tried to change the source data from list menu, but received "No Data to copy" error
(refer below image)
Capture2.PNG

Hope you can assist me on this..

Thank you in advance

Dear davesexcel,

Thank you for your quick reply and guidance.
I have tried the file & still received error :
Capture.PNG

Not sure why it's not working.
Would much appreciate if you can help & assist me

Thank you

I upload again my original file with some explaination about what is needed

Thank you

Hi davesexcel,
What you've done does meet my request.
If its XL 07 issue, can it be resolved?
Or do i need to change any setting ?

Thank you


Sent from my iPhone using Tapatalk

Hi romperstomper,

The code works great !
A very much thank you to you & davesexcel.
You guys are really helpful..
Thank you again