I have a workbook that we create service tickets from. The main sheet is used to enter information about the job. When complete I have a button that names and saves the workbook in a specific location. There is an additional sheet that is used as a service ticket log. What VB code can be used to take data from 4 specific cells and put them on the service ticket log sheet on the row that has the matching ticket number from the active sheet? I am already using the ticket number in my save aas "name" procedure so it is already defined in the code as TktNum.
So you want to add to something you already have. Then you need to show what you have first.
Consider sharing your workbook (careful with sensitive info) and make sure it is clear what you want to happen. Do this by using a filesharing site like www.speedyshare.com or ge.tt etc., to upload your file and then post back the provided download link.