• Hi All

    Please note that at the Chandoo.org Forums there is Zero Tolerance to Spam

    Post Spam and you Will Be Deleted as a User

    Hui...

  • When starting a new post, to receive a quicker and more targeted answer, Please include a sample file in the initial post.

Copy Userform data into another spreadsheet which has the same formatting as the userform

A

Ainsdale

New Member
Hi

Can anyone please help?

I have attached my userform file and I want to transfer the data from the completed userform (once populated) into the "Userform-PDF" worksheet, so I can then move that data into a PDF file and eventually email it to a specific email address.

Small steps, therefore this thread is specifically asking to only move the populated data from the userform to the "Userform-PDF" worksheet first and I will tackle the other 2 steps later.

I know how to move the data to a worksheet, via named columns and 1 row, but I want to keep the same format as the userform. Eventually this file needs to be sent to the Finance Team to input in the system, keeping the same format.

Many thanks
 

Attachments

To give you a start

Code: 
Private Sub SAVE_Click()
With Sheets("Userform-PDF")
.[B6].Value = ComboBox1.Value
.[B12].Value = TextBox1.Value
End With
End Sub
 
Brilliant, thank you. I thought it would be quite difficult, but it's fairly straightforward :).

I'm very grateful nonetheless.

I'll start a new thread for the next step
 
You must log in or register to reply here.
Back
Top