Cell content move with VBA code [Closed]

Report
Posts
1
Registration date
Monday January 23, 2017
Status
Member
Last seen
January 23, 2017
-
Posts
2676
Registration date
Sunday September 12, 2010
Status
Moderator
Last seen
December 3, 2020
-
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.

Thank You in advance

1 reply

Posts
2676
Registration date
Sunday September 12, 2010
Status
Moderator
Last seen
December 3, 2020
448
Hi kd5jnx,

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.

Best regards,
Trowa

Subscribe To Our Newsletter!

The Best of CCM in Your Inbox

Subscribe To Our Newsletter!