Hi there,
Tried for days to self-solve this one myself so am turning to anyone out there for help if possible.
I have a Workbook for use by a customer service team, it's for tracking service desk tickets.
One of the fields is a drop down for if they have referred the matter on to a support team.
The support team has a similar Workbook for their team, which uses many of the same fields / format.
What I am trying to achieve is that when the user in the first team selects from the drop down in one field, it automatically populates onto a new line in the second teams Workbook / sheet.
Is this possible?
I have attached the two sheets.
In the Ticket Tracker (Main Team) column AA, if the selection is "CS Support Team" from the drop down I want to be able to have that line added to a new line in the Ticket Tracker (Support Team) sheet - or selected fields to transfer? Is this too big an ask of functionality?
I would entertain doing this on say a custom button press, so once all fields complete and a button is pressed it then transfers the data?
Thanks for any help in advance.
Ricardo Lacombe
Bookmarks