Group:  Microsoft Excel ยป microsoft.public.excel
Thread: populating sheets

DotNetBag
.NET Development Newsgroups

HTVi
TV Discussion Newsgroups

Our Hot Pick: Rising Antivirus 2006 - Certified by TUV & Checkmark! Get 10% discount by entering this coupon code: ONDISCOUNT10
Rising Antivirus 2006

populating sheets
"blackberrylive" <blackberrylive[ at ]gmail.com> 22.08.2006 20:01:57
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.

Home | Search | Terms | Imprint | Contact
Newsgroups Reader - provided by WiredBox.Net