Very limited VBA knowledge and stuck..
I need help moving information from one workbook to another.
What I have is a userform that gathers information and places it in a worksheet named "Information" in the same workbook .
.
What I need is for the data in this 1st workbook on worksheet "Information" to be copied to another workbook and then cleared.
If it would be easier to copy directly to 2nd workbook and bypass the 1st worksheet alltogether that would be ok with me but I don't know how to do that either.
.
I will need to add additional data to the 2nd workbook as the userform is used... so the information should be copied to the first blank row below existing information in that 2nd workbook.
The Workbooks and code below is what I have so far.
.
Workbook to copy data from name = ErrorsCaught.xlsm...worksheet name = Information
Workbook to copy data to = ErrorDefinationWorkbook.xlsx....worksheet name = Information
.
Any and all help would be appreciated!
Thanks in advance!
SLIDE1
Bookmarks