Populating another tab.

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

Guest

I'm trying to come up with a way have data from one tab populate on another
tab if it meets certain criteria.
On tab 1, I have about 40 rows of data in about 6 columns. I'd like to have
the data from tab 1 automatically populated on tab two if the information in
the rows meets certain criteria.
Any suggestions?
 
Not quite automatic, but I'd try to apply data|filter|autofilter
Filter by the required criteria and then copy the visible cells to the other
sheet.
 
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

List data 3
Lookup Formula - I think? 5
Add a new row in Named Table (Table1) and add data from txtboxes into last empty cells based on header named of the Table1 0
Summing cells based on mulitiple criteria over mulitple columns 1
Lookup or If, then Question 1
Add/Subtract columns from tab to tab in same file 3
Using SUMIF and AND functions simultaneously 3
Weighted Average 7

Back
Top