Extract data from a different workbook

I suggest you plan out your project. What EXACTLY needs to happen and when? Make a diagram or a list of steps that need to happen from start to finish.
Then cut each piece up into as many small steps as possible, and THEN you can come ask us for help.

Otherwise we are either suggesting things WAY different or more difficult than you need and we all spend time sub-optimally, which is most likely the reason you are getting no responses.

Yeah, I hoped to keep it simple but I guess more info is needed.

Workbook “Lift Driver Feedback Form” = …form
Sheet = feedback
This is the form my userform is tied to. This xlsm has a sheet titled Feedback which will temporarily house the data collected from the form. Eventually this xlsm will not be visible, when the excel icon is selected I want only the userform to come up – but I still need a backdoor for updates and troubleshooting... but not quite to that stage of the build yet. The reason all the info will not be on one xlms is to avoid read only issues and easier accessibility to the users who will only need the data collected, not the form.

sp1.png

Workbook “Lift Driver Feedback Data” = …data
Sheet =data
Upon opening this form I hope to have it initialize the extraction process from “…form” workbook sheet1!feedback to “…data” workbook sheet1!data. So it would open the workbooks, find the cell range (using erow) in the “…form” workbook, cut it, then paste that info in “…form” workbook based on next available row. Both sheets are set-up and formatted exactly the same. The data is between rows F and K.

I started playing with the code at http://www.familycomputerclub.com/au...-workbook.html but had trouble figuring out which file names I needed to change and what isn’t needed for this build. So maybe I bit off a little more than I can chew, but so far it’s been fun learning.

If one of you can guide me along that would be awesome!!!

***short version***
Initialize extraction when Workbook “Lift Driver Feedback Data” is opened
Open workbook Workbook “Lift Driver Feedback Form” sheet!feedback
Select range based on endrow(?) F to K and up to row2
Cut range
Closed and save Workbook “Lift Driver Feedback Form”
Paste range at erow of Workbook “Lift Driver Feedback Data” sheet!data
Save file and remain open