Spreadsheet: 821235d1678528419-require-formulae-to-copy-data-from-one-tab-to-another-in-same-workbook-1-800-times-coaching_tickets
Sheet: ReadMe_1st

 |  | Hoping for a formula which can apply across this entire Feedback_Tickets [NAME]
 |  | Scenario
 |  | Working on a variation of  a Sport Workbook for Football
 |  | Designed to assist Referees in their performance on games by supplying brief written notes from coaches.
 | Process: | 3 x Referees allocated to each game
 |  | 3 x Referee Coaches watch the same game,  and by end of the game have completed Tickets with comments in the coloured cells
 |  | So 9 x tickets  will have been completed on each game.
 |  | Just before end of game, Coaches meet, check their notes are similar.
 |  | End of game,Coaches meet with Referee/s & provide one completed ticket to each Referee to assist for future game.
 |  | In April next, we have a large 4 x Day event, where 10 x Referee Coaches will be filling out Tickets as per Feedback_Ticket [NAME] template.
 |  | Approx 1,500 Teams competing in various aged divisions
 |  | Whilst  Comments areas (Coloured gold) in tickets would be filled in during each game,  pre-event data should to be completed first.
 |  | Each Coach will complete 45 x Tickets comments each day = 180 tickets over 4 days
 |  | There are several data fields on each ticket which can be completed Pre-Event from the P_List data.
 |  | with each  Coach needing to  complete 45 x Tickets each day = 180 tickets pover 4 days, there is considerable time required to complete the the pre-event data in Rows  5, 6, & 7.
 |  | Hoping for formulae which can populate the data from each of the fields in The P_List to the appropriate fileds in the Feedback_Ticket Tab fields
 |  | If any data in the P_List is changed then the Feedback_Ticket Data would also  update via the formulae.
P_List [NAME] |  | contains data supplied by Administration source and is used to appoint Referees and Coaches to each game.
Feedback_Tickets [NAME] |  | Template - Data from P_List is 'posted' to this tab - A4 Landscape  - after printing, guillotined into 6 x tickets per page
Manually entered data |  | Referring to the example data manually completd in  C5: V11 and  C35: V41
 |  | For this example Each cell in Feedback_Ticket [NAME] is manually copied from the P_List tab
 |  | In total, 1,800 tickets will need to be generated for the 4 day event.
 |  | This is very time sonsuming, and prone to errors
 |  | Hence the hope for a consistent formulae can be used.
Supporting information
P_List [NAME] |  | Columns and data is consistent for all.
[NAME] |  | Template layout is same for all tickets
 |  | Explanation of cells
 |  | P_List [NAME] 3, contains
 |  | [NAME] | Referee Count (copied from B50
 |  | D3 | Referee Coach Name
 |  | E3 | Date of this list - Day 01
 |  | F3 | Day of Event
 |  | P_List [NAME] 4, contains
 |  | [NAME] | Assessment Number
 |  | D3 | Referee Coach ID Code
 |  | E3 | Time of Game
 |  | F3 | Field Number
 |  | G3 | Division (M = Male 20 = Age Div; X = Mixed (Male/Female)
 |  | P_List [NAME] thru to 49 , contains
 |  | [NAME] | Assessment Number |  |  | Unique for each game
 |  | D3 | Referee Name (examples) |  |  | All Names are as per example |  |  | Referee 09 - O4 - XXX
 |  |  |  |  |  | Spaces and dashes in name etc are necessary as that is the way the data is supplied from a master sheet
 |  | E3 | Time of Game
 |  | F3 | Field Location Number
 |  | G3 | Division
 |  | 4 x sets of Data per Coach (4 x Days)
 |  | Coach A1 | Columns C : Y
 |  | Coach A2 | Columns AA : AW
 |  | Coach A3 | ColumnS AY : BU
 |  | Coach A4 | Columns BW : CS
 |  | Coach A5 | Columns CU : DQ
 |  | Coach A6 | Columns  DS : EP
 |  | Coach A7 | Co:imns [NAME] : FM
 |  | Coach A8 | Columns FO : GK
 |  | Coach A9 | Columns GM : HI
 |  | Coach A10 | Columns HK : IG