|
|
Our Hot Pick: Rising Antivirus 2006 - Certified by TUV & Checkmark! Get 10% discount by entering this coupon code: ONDISCOUNT10
i've got a ton of data on sheet 1 that is my "running" database (periodically updated). i want to keep that as my master sheet but have second and third sheets pull certain lines out.
for example. sheet 1 has 8 colums of data. if cell b2 has a date (non-specific) in it i want all of row 2 to populate a row in sheet two. if cell b3 does not have a date i want that row to populate a row in sheet 3.
can anyone help me with this? i've tried IFs and VLookups and a few others but can't seem to get it to work just right.
|
|
|