Copying specific rows

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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
 
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?
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Excel Copy cells from one worksheet to another workseet - increment row & do again 0
Excel Move or Copy Stopped Working? 0
Index Match on Columns and Rows 0
Copy entire row to different worksheet 5
How do I move multiple tabs in multiple workbooks to a master? 3
How do I create a formula that references a specific tab in Excel? 1
lookup data across worksheets, one with 56K rows 4
Copy rows between different sheets if condition met 5

Back
Top