LordDragon
10-02-2015, 08:23 PM
Greetings,
This one is a little involved. I have a document that I created in Excel for our customers to fill out. This document cannot have VBA, so everything is done with formulas and Data Validation.
I have another Workbook where we will be using the data from the document to prepare and track the project for the customer.
Now, what I've done is put a copy of the document in the project workbook (which uses a lot of VBA). I have added code that will use the data from this document to populate a lot of the project information.
What I need is a way to take the data from the document and put it in the form in the project workbook.
I'm currently considering the approach of putting a hidden sheet in the document that will simply collect all the data entered into it in a table style layout. Then putting a similar hidden page in the project workbook to import the data to.
I'm pretty sure I can make the hidden pages and get the data to and from them within their respective workbooks without an issue. What I do need help with is getting the data from one workbook to the other.
Since the names and locations of both the customer document and the project workbook could change, I'm looking for a way to click the button (already added ot the project workbook) and have that provide a way to pick the customer document to use for the data import.
If there is an easier way, I'm open to it.
This one is a little involved. I have a document that I created in Excel for our customers to fill out. This document cannot have VBA, so everything is done with formulas and Data Validation.
I have another Workbook where we will be using the data from the document to prepare and track the project for the customer.
Now, what I've done is put a copy of the document in the project workbook (which uses a lot of VBA). I have added code that will use the data from this document to populate a lot of the project information.
What I need is a way to take the data from the document and put it in the form in the project workbook.
I'm currently considering the approach of putting a hidden sheet in the document that will simply collect all the data entered into it in a table style layout. Then putting a similar hidden page in the project workbook to import the data to.
I'm pretty sure I can make the hidden pages and get the data to and from them within their respective workbooks without an issue. What I do need help with is getting the data from one workbook to the other.
Since the names and locations of both the customer document and the project workbook could change, I'm looking for a way to click the button (already added ot the project workbook) and have that provide a way to pick the customer document to use for the data import.
If there is an easier way, I'm open to it.