Data entry form

[keranali]

Good Day all,

I want to create a form to input data on a spread sheet the form should contain fields such as ( Date , Customer, Location, Model, Service Type, Problem, Assignee and Notes. The form should come up when you select New Ticket Button. The filled out entries then go into the spread sheet as an entry.

Daily Task Reports.xlsx
	A	B	C	D	E	F	G	H	I	J	K	L	M	N	O	P
16	Date	Customer	Location	Model Device	Serial Number	Counter B/W	Counter Color	Type	Problem	Solution	Contact	Assigned	Open	Closed	Parts Required	Notes
17	2/1/2024	ment Caterers	Spain					Delivery		Delivered		Ricardo
Data

 

[ExcelToDAX]

how about creating a microsoft form that directly connects to an Excel file? Go to excel online, and go to insert > forms > new form

 

[keranali]

Ok will have a look see

 

[keranali]

Do you know if there is a way to create a button on the spreadsheet that activates the ribbon form feature?

 

[mumps]

You could use a userform directly in your workbook to do what you want with a button on the sheet to activate it.

 

[keranali]

Thanks Guys will attempt