id="info"

General discussion

Locked

excel automation

By deepika.nowley ·
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 **** 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

This conversation is currently closed to new comments.

2 total posts (Page 1 of 1)  
| Thread display: Collapse - | Expand +

All Comments

Collapse -

Suggestion

by Stangg In reply to excel automation

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

Collapse -

possible help

by blueyonder In reply to excel automation

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

Back to Software Forum
2 total posts (Page 1 of 1)  

Software Forums