Discussions

excel automation

+
0 Votes
Locked

excel automation

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
  • +
    0 Votes
    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

    +
    0 Votes
    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

  • +
    0 Votes
    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

    +
    0 Votes
    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