there are 3 sheets in an excel spreadsheet say the names are 1,2 AND3
layouts ar ethere for all 3 sheets.
the first sheet (which is maually updated every friday. so teh sheet keeps growing in rows)is used as input and based on certain fields , columns in the first sheet i need to populate entries in the second and 3 rd sheet.
teh main purpose is taht based on the first sheet the 2 and 3 sheet should be automatically filled. wat kind of formula / macro should i be using . for eg.,
say my table looks like this for eg.
Pn Task status stdate enddate
Meta Anal started 5-Nov-0 7-Feb-08
Meta imp planned
Meta dev
Meta test
…
…
From the above i need to first check for teh status ..(teh status here is a drop sown list box out which theer are 3 options planned , started and completed)
when status = planned or completed , the corresponding prj name should be copied to another sheet 2. here only one instance of “meta” should be present when compared to 4 instances in the first sheet
im new to this and jsut know to create macro. CAn anybody help