Izanamphetamine
New Member
- Joined
- Feb 25, 2011
- Messages
- 1
My problem goes like this,
http://img121.imageshack.us/i/67286679.png/
The sheet above is a section of a maintenance schedule for a machinery. tasks based on the schedule are assigned to the mechanics as cards (based on card Reference Column C). the first set of characters before the hyphen is the card number. these card numbers goes from 01 to 47 and also certain other such as RA, FUN cards are there. one task may belong to 2 or more cards. e.g row 7 task must be in cards 32 , 30 and FUN and these card references are entered in a single cell as multiline text.
I would like my workbook to have separate sheets for each card, and all the tasks that belong to that card to be returned onto that sheet dynamically. for example the sheet for card 22 must show rows 4, 5, 6. sheet for card 30 must show row 7, and sheet for card 32 must also show row 7 in the case of the image above.
Please help.
http://img121.imageshack.us/i/67286679.png/
The sheet above is a section of a maintenance schedule for a machinery. tasks based on the schedule are assigned to the mechanics as cards (based on card Reference Column C). the first set of characters before the hyphen is the card number. these card numbers goes from 01 to 47 and also certain other such as RA, FUN cards are there. one task may belong to 2 or more cards. e.g row 7 task must be in cards 32 , 30 and FUN and these card references are entered in a single cell as multiline text.
I would like my workbook to have separate sheets for each card, and all the tasks that belong to that card to be returned onto that sheet dynamically. for example the sheet for card 22 must show rows 4, 5, 6. sheet for card 30 must show row 7, and sheet for card 32 must also show row 7 in the case of the image above.
Please help.
Last edited:
