New Excel Forum

This forum has been moved to TeachExcel.com

Ask all future questions in the New Excel Forum.

ExcelKey

Checkbox Help

Formulas, Functions, Formatting, Charts, Data Analysis, etc.

Checkbox Help

Postby binkie » Sun May 22, 2016 10:23 pm

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!! :D
  • 0

binkie
Rookie
 
Posts: 1
Joined: May 22, 2016
Reputation: 0
Excel Version: 2013

Re: Checkbox Help

Postby candybg » Wed May 25, 2016 12:47 pm

This video explains exactly that!
http://www.pcworld.com/video/63066/how- ... readsheets
Instead of extra points, tho, your check box could "pull" text from a specific cell if TRUE.

Hope this helps!
  • 0

candybg
Rookie
 
Posts: 2
Joined: May 18, 2016
Reputation: 0
Excel Version: 2010; 2013


Return to General Excel Questions

Who is online

Users browsing this forum: Google [Bot] and 38 guests