Quick find in a sheet and table population

**mmf** · 06-10-2008, 11:19 AM

Hi,
I am triying to get this sorted out, but I couldn't
I have two sheets, one is a main sheet where a table has to be populated with values according to a date changed by the user.
in the second sheet I have the database from where I would like the date to be retrieved

I made a peace of code, but is too slow

and also would be nice that when a value is not found set the cell in blank.
and the table get updated without click the commnadbutton when the date is changed.

Any help with this will be welcomed
I attached the file so you can see my mess
cheers

**Leith Ross** · 06-10-2008, 03:47 PM

Hello mmf,

I added the macro below to your workbook, which is attached to this post. It will run automatically when the value in cell "B1" on Main is changed. The command button will also call the same macro. As you can see, this macro is quite a bit more complex than yours. It takes advantage of the Auto-Filter function to sort the data by date.

Please Login or Register  to view this content.

**mmf** · 06-12-2008, 12:41 PM

Many thanks for the code I really appreciate the time.
here in my computer is not working, I was trying to figure out why it is.
the autofilter is activate, but do not show any values, so the code can not retrieve any data.
any clue why that is happening
cheers

**Leith Ross** · 06-12-2008, 12:51 PM

Hello mmf,

Can you post your workbook? I have a look at what's going on. The code should prevent that condition from happening.

**mmf** · 06-20-2008, 05:17 AM

Sorry leith, to do not answer early, but god last weeks have been very hetic.
Please find the workbook that is not working
Best Regards
MM

**Leith Ross** · 06-20-2008, 10:57 AM

Hello mmf,

The data may not be visible if the auto filter has failed to find a match. On the menu bar, click b]Data, Filter, Show All[/b]. This will restore the list. The macro does this automatically each time it runs, but leaves the filtered results.

Sincerely,
Leith Ross