Saving Input of Userform as a new line of data on another file?

  • Thread starter Thread starter pepper
  • Start date Start date
P

pepper

Hi,
Wonder if anyone can help me? I have create a form, and want to b
able to save the info to another file(A) after I have click on
button. Upon my next click, the new info from my form will be save as
new entry (the next line) in file A.

Thank you
 
hi,
it might be better to 1 button the whole thing.
put the new record on the next line then copy the whole
line to the other file. 1 click. to do it the way you
described, it would require 2 button and 2 seperate
actions.
if you have a lot of input at one time, it might be better
to add the new line and add the line to a seperate sheet.
then when all input is done, copy all new entries to the
other file and delete the new entries form the other sheet.
if you need help with coding - repost.
 
Back
Top