Hi all,
I have searched everywhere for the answer to this but can not seem to find the right answer so hopefully someone can help.
I have a master sheet that I am keeping a whole bunch of peoples information like name, address etc as well as some special areas of expertise like guitar, drums, vocals etc.
Basically I want to be able to identify those areas with a "yes" or even a tick box (or any kind of identifier). If there is a yes in the "guitar" column, I want all of their personal information to be copied and pasted to another sheet (names guitars). I need each person to be able to have more then 1 identifier i.e. guitar and drums etc, and I need for their information to be copied and pasted to each sheet.
I really need to be able to collate the information of people with the same expertise on different sheets in the same workbook whilst maintaining the master sheet.
Hope that is clear and someone can help.
BTW - I know there is no VBA for 08 Office for mac and I have applescript but have no idea how this integrates with excel.
I have searched everywhere for the answer to this but can not seem to find the right answer so hopefully someone can help.
I have a master sheet that I am keeping a whole bunch of peoples information like name, address etc as well as some special areas of expertise like guitar, drums, vocals etc.
Basically I want to be able to identify those areas with a "yes" or even a tick box (or any kind of identifier). If there is a yes in the "guitar" column, I want all of their personal information to be copied and pasted to another sheet (names guitars). I need each person to be able to have more then 1 identifier i.e. guitar and drums etc, and I need for their information to be copied and pasted to each sheet.
I really need to be able to collate the information of people with the same expertise on different sheets in the same workbook whilst maintaining the master sheet.
Hope that is clear and someone can help.
BTW - I know there is no VBA for 08 Office for mac and I have applescript but have no idea how this integrates with excel.