Hi - I tried to find if this was already asked & answered, but I couldn't find it anywhere -
would any of you happen to know if it's possible to create a workbook as follows (my example is for a document that contains all information related to an Issues list, combined wiht a Project list, Upgrade List and so on..)
I would like to be able to enter all items on the first page of a workbook so the numbering system can be consistent as well as ease of maintaining since often something may be identified as an issue at first but ultimately be determined to be an upgrade... so what I want to do is
Worksheet 1 - enter all my information here (Site name, issue number, system name, status, etc.etc.)
Worksheet 2 - somehow have all the rows that match a certain criteria copy over to this sheet - ie: all rows where the site name is "ABC" and the status is "open"
Worksheet 3 - have all the rows that have been identified as being upgrades copy to this worksheet
Worksheet 4 - have all the items that have their status changed to closed appear on this worksheet (and also be removed from the other sheet it may appear on as an open item)
Is this possible to do? Any information would be greatly appreciated!
Thanks
Denise
would any of you happen to know if it's possible to create a workbook as follows (my example is for a document that contains all information related to an Issues list, combined wiht a Project list, Upgrade List and so on..)
I would like to be able to enter all items on the first page of a workbook so the numbering system can be consistent as well as ease of maintaining since often something may be identified as an issue at first but ultimately be determined to be an upgrade... so what I want to do is
Worksheet 1 - enter all my information here (Site name, issue number, system name, status, etc.etc.)
Worksheet 2 - somehow have all the rows that match a certain criteria copy over to this sheet - ie: all rows where the site name is "ABC" and the status is "open"
Worksheet 3 - have all the rows that have been identified as being upgrades copy to this worksheet
Worksheet 4 - have all the items that have their status changed to closed appear on this worksheet (and also be removed from the other sheet it may appear on as an open item)
Is this possible to do? Any information would be greatly appreciated!
Thanks
Denise