UPDATE REQUIREMENT WITH A SPECIFIC FORM
I made some linked sheets (1st sheet = dispatch sheet; others 1 sheets = 1 workflow). Then we can open a ticket (requirement) in sheet 1 and follow the ticket trough each workflow (department)
- sheet 1 : we open a ticket with COMPANY NAME/CONTACT/DEPARTMENT WHICH LEAD THE ACTION (Ex: AFTERSALES). It gives a ticket number and transfer the line to the right department.
- sheet 2 : AFTER SALES DEPT Sheet: the line is transfer automatically from Sheet 1 to 2 for treatment. When line is added, SAV team receive 'update requirement' to specify WHO will handle the request/LEADTIME/OTHER AFTER SALES INFORMATION. Then the ticket is handle as a step by step project into after sales dept.
If after sales needs support from other department he can select the department in a dropdownlist cell and the line is copy to the support department workflow (ex technical)
- Sheet 3: TECHNICAL DEPT Sheet: Line is copied and they received 'automatic update requirement' to take this requirement in their duties.
On sheet 3, I don't need to copy all information from sheet 2. How can I manage to copy only selected columns? I can not manage it with formula like VLOOKUP as the source can come from many sheet.
Thank for your help.