Appending data via USER FORM-Not solve..just abandoned

[SLIDE1]

Novice Excel user here trying to add data to existing workbooks via a user form.

I am trying to create a user form that allows measurements taken manually to be added

to workbooks generated by a machine that measures dimensions automatically.

The automatic measuring machine (CMM) creates 2 new workbooks for each job measured and stores them in a file called Job#.

After completing the user form, sadly haven't the VBA skills to continue .

If anyone would like to try and make this work that would be greatly appreciated!


The user form should work as follows:

1. User enters data on user form

2. When command button on user form (Send to Report) is selected the data from InsertConfig sheet should transfer

to the end of workbooks defined by job# (cells L5 and L15 on InsertConfig sheet).

Example- Cells A3:C8 of InsertConfig sheet added to end of data in workbook kQ034 and also cells A13:E18 from same sheet added to end of data in workbook KQ034-A.

The code I have come up with so far takes the data from the user form and arranges it in the configuration in which it needs to be inserted.

3. The workbook name changes according to the job# entered on the user form, and data will only be transfered once per workbook.

The filepath remains the same except for the workbook name.


Apologies in advance if I have broken any Forum Rules and if this has been covered in a previous thread please point me in the right direction!

[SLIDE1]

My 1 and only bump...

[SLIDE1]

Bump.....#2

[LeapingLizard]

So a new workbook is created each time corresponding to the Job # or do you just want to copy the data to that workbook?

LeapingLizard

[SLIDE1]

LeapingLizard,
Yes 2 workbooks are created for each new job that is measured (example KQ034 and KQ034-A) .
All I want to do is insert additional data onto the end of these reports.

Slide1

[SLIDE1]

Updated. I did some research and have now have a working user form but still need code to transfer data.