Copying specific rows

E

Eric Montelongo

I have one worksheet with two tabs. One tab has all the master data which
it auto populates. The 2nd tab is what the user is going to view. Both
worksheets have a date column. What I am trying to do if there is any
information on the Data worksheet to copy it into the 2nd tab but it has to
match the date.
Thanks
Eric Montelongo
 
J

JonR

How does your master data table populate? If you are extracting external
data, you're probably doing it through MSQuery or something similar. My
first thought is that it would be easiest to set up a similar query on Sheet
2 using the date as a parameter. This would be much easier (and run faster)
than writing VBA to copy and paste specific rows.

The other question is what are the users going to do with this sheet? Do
they have to manipulate the data, or is just for viewing? Do they need to be
able to specify the date they want to view, or is it static?
 
Top