Hello,
First post so please be gentle.
I have looked through the various other posts on this topic and can't find something that will work for what I am looking to achieve in copying data from Excel to Word.
Within a Excel file a number of UserForms allow the individual to make various selections of standard wording by selecting a CheckBox. Ultimately, following a sort a removal of entries not selected I have a worksheet called "Menu" which contains all the components that the user has selected to be copied into a new Word document.
Also contained within the Excel file is a worksheet called "Text" which contains the standard wording to be copied over. For now I'm ignoring some other elements where the user can also type into the UserForm and this data would also be copied over.
In Summary:
1) Excel macro that will start at the top of a column on the worksheet "Menu" and go through it until it hits END at the bottom. This list can change from user to user so I presume I would need to build the macro for all possible selections albeit they are ignored if not present in the final list.
2) From the first selection in "Menu" a Word Document is to be opened and the text that relates to that selection is copied into the Word document. After being pasted the cursor is moved down one line.
3) Excel goes back to the "Menu" and shifts down one line to the next selection and depending upon what it is goes and copies the text relating to that selection and pastes it into Word on the next line. Again, cursor moves down one line.
4) Having gone through the "Menu" list and reached END in the column the Excel document closes leaving just the Word document open.
I would really appreciate any assistance with this question. The examples I've seen only really relate to one specific range and don't make any attempt at a second element to be copied from Excel and certainly nothing seen where the range selected is based upon criteria.
Here's hoping there is someone out there who can help me crack this.
Regards
Chubski
First post so please be gentle.
I have looked through the various other posts on this topic and can't find something that will work for what I am looking to achieve in copying data from Excel to Word.
Within a Excel file a number of UserForms allow the individual to make various selections of standard wording by selecting a CheckBox. Ultimately, following a sort a removal of entries not selected I have a worksheet called "Menu" which contains all the components that the user has selected to be copied into a new Word document.
Also contained within the Excel file is a worksheet called "Text" which contains the standard wording to be copied over. For now I'm ignoring some other elements where the user can also type into the UserForm and this data would also be copied over.
In Summary:
1) Excel macro that will start at the top of a column on the worksheet "Menu" and go through it until it hits END at the bottom. This list can change from user to user so I presume I would need to build the macro for all possible selections albeit they are ignored if not present in the final list.
2) From the first selection in "Menu" a Word Document is to be opened and the text that relates to that selection is copied into the Word document. After being pasted the cursor is moved down one line.
3) Excel goes back to the "Menu" and shifts down one line to the next selection and depending upon what it is goes and copies the text relating to that selection and pastes it into Word on the next line. Again, cursor moves down one line.
4) Having gone through the "Menu" list and reached END in the column the Excel document closes leaving just the Word document open.
I would really appreciate any assistance with this question. The examples I've seen only really relate to one specific range and don't make any attempt at a second element to be copied from Excel and certainly nothing seen where the range selected is based upon criteria.
Here's hoping there is someone out there who can help me crack this.
Regards
Chubski
