Jet Fusion
Member
Hi
I have a work book that will have
Thanks
I have a work book that will have
- Contacts as per sheet 1,
- Sheet 2
- column B & C will be drop down boxes, column D should get the info from sheet 1 matching the info in column C on sheet 2.
- column B row 37& 38 and for how long the list will be should get info from sheet 4 and that will be a growing list.
- Sheet 3, column D row 6,7&8 I have a Vlookup to get the info from sheet 2.
- column H row 6 i'm not sure if you can do this by having a automated no generated each time you create a issue by referencing column D row 4 and concat with colum H, I & J? This will however have to match column I row 5 when selected and for all other entries.
- also all formulas to not show 0 when no entry is filled it, it should be blank up until infomation is filled into the relevent referenced cells.
Thanks