Hi
I made several worksheets in a workbook which retrieve data from network
database and each worksheet has its own query.
Now, because of so many data, how can I limit to recent date and it should
apply to all worksheets?
May be I have to move to Excess which has form, have not seen form in Excel
Thanks
Daniel

Daniel,

You can use Excel UserForm which you can add procedure and controls on it.

Try to open by pressing Alt+F11

Then add Userform to your project.

--
Regards,

Halim



"Daniel" wrote:

> Hi
> I made several worksheets in a workbook which retrieve data from network
> database and each worksheet has its own query.
> Now, because of so many data, how can I limit to recent date and it should
> apply to all worksheets?
> May be I have to move to Excess which has form, have not seen form in Excel
> Thanks
> Daniel