Hi guys,
Wondering what the best solution would be to use checkbox selection to populate another spreadsheet in a neat table
So there are 30 or so items but the user only needs to select 5 of them and those 5 go into another table:
e.g. Items to choose from in Spreadsheet 2:
Workplace Learning and Development (checkboxed True)
Managing the Global Workforce(checkboxed True)
Introduction to Human Resource Management
Australian Industrial Relations(checkboxed True)
Strategic Management of Human Resources
Recruitment and Selection(checkboxed True)
Negotiation
Employment Law F(checkboxed True)
Workplace Health and Safety Management
Managing Employee Performance and Rewards
Items that have been selected and moved to Spreadsheet1 - Cells A1,A2,A3,A4,A5
A1 = Workplace Learning and Development
A2 = Managing the Global Workforce
A3 = Australian Industrial Relations
A4 = Recruitment and Selection
A5 = Employment Law F
So at any time I want the checkbox to populate into only Cells A1-A5
Thanks!!