Software

Ask something
Discussion Locked

excel automation

0 helpful
2 replies

by deepika.nowley

Closed to new repliesThis discussion is closed. It stays readable, but it takes no new replies.

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

2 replies

by stangg

You could use a vlookup for the first columns and an IF statement for the status, or a nested IF depending on the complexity. You should be able to find more detailed help on these commands in the office help guide, without looking at the spreadsheet I dont know how much more help i could be

by blueyonder

hi. it's difficult to give a concrete answer without more detail.

I willbe wi9lling to take a look at the xls if you can post it somewhere or email it.

gmw@inbox.com

This discussion is closed to new replies.