Trying to tie checkboxes in one sheet of an excel doc to a table of specific customers in another

NoSparks · #1 08-06-2019, 08:35 AM

Quote:

Can this be done?

Are you able to record a macro of yourself manually doing what you want to happen when a check box is checked ?

Chances of assistance is greater attaching a workbook rather than pictures of sheet(s) in the workbook.

jaffa20 · #2 08-06-2019, 08:48 AM

Quote:

Originally Posted by NoSparks

Are you able to record a macro of yourself manually doing what you want to happen when a check box is checked ?

Chances of assistance is greater attaching a workbook rather than pictures of sheet(s) in the workbook.

As in record a macro for each individual checkbox? I could try that. Would I be able to have a search for the customer name as part of that?

I've attached the file now. So my aim is a customer would be selected from the dropdown list, and then whoever is using this would work through the checklist of tasks ticking a checkbox if there was an issue.

The second sheet would serve as a log where each row is a customer, and the columns are the tasks, so the number of issues and where they occurred can be recorded per customer

jaffa20 · #3 08-07-2019, 03:31 AM

I tried recording a macro and getting it to copy the contents of a cell (the dropdown of the customer name) and then do a ctrl + F to find the row of that customer to fill in the cell. However, when I run the macro it just reverts back to the customer which I recorded the macro on. When I view the code to edit it, it specifies the customer. How should I write it so it copies the cell contents and doesn't revert to the original dropdown selection?
Here is the code if it helps:

Code:

Sub AM_Missing_tick()
'
' AM_Missing_tick Macro
'

'
Range("A1:E1").Select
ActiveCell.FormulaR1C1 = "2gether NHS Foundation Trust"
Range("G1").Select
Sheets("Recorded Errors").Select
Cells.Find(What:="2gether NHS Foundation Trust", After:=ActiveCell, LookIn _
:=xlFormulas, LookAt:=xlPart, SearchOrder:=xlByRows, SearchDirection:= _
xlNext, MatchCase:=False, SearchFormat:=False).Activate
Range("B4").Select
ActiveCell.FormulaR1C1 = "x"
Sheets("Quality Check").Select
End Sub

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Linking Specific text fields in PP to specific cells in an Excel table	GWRW1964	PowerPoint	0	02-26-2018 07:37 AM
Export Word Drop-Down Content Control to Excel Specific Sheet	nolanthomas32	Word VBA	4	09-19-2017 06:25 AM
extract specific pivot table data to a new sheet	theexpat	Excel Programming	0	02-18-2016 10:08 AM
Excel copy two numbers between specific column and paste in next sheet	visha_1984	Excel	1	12-26-2014 07:59 PM
Browse to a specific sheet in an excel workbook	Sinister	Excel	4	04-08-2014 05:53 PM