Hi, I currently have a userform which when completed a user clicks submit, which then copies the information to the open worksheet
Is it possible to send this information instead to a different workbook?
rather than saying
With Worksheets("Data").Range("A1")
.Offset(RowCount, 0).Value = "Change"
Can i say for example With worksheet{insert filename here}?
Is it that simple?
Thanks