Hello all,
My first post on here so please let me know if i need to do anything more in this post.
I have a workbook that holds some data and a dropdown box. What i would like to do is get some VBA code that would copy and past particular active cells to another workbook on a shared drive. However i would like to alter which workbook it copies the cells to depending on which text is selected in the drop down box. I have attached an example of the workbook to help.
The cells i would want to copy are A7:A27, C7:C27 but only if they have text in them.
The drop down box is in cell B2 on the attached example and the two options are "Book 1" or "Book 2"
I would also be running this VBA multiple times a day for different data (as the sending book is a template that will be clean of data each time it is opened) so would need the code to paste below any rows that are already in use on the book where the data will be posted.
I hope this makes sense.
I have searched this forum and others and although there is a lot of posts about this subject across the net they do not refer to one cell with multiple options and tend to copy entire rows which is not what i would like to happen if possible.
Many thanks for any help in advance.
My first post on here so please let me know if i need to do anything more in this post.
I have a workbook that holds some data and a dropdown box. What i would like to do is get some VBA code that would copy and past particular active cells to another workbook on a shared drive. However i would like to alter which workbook it copies the cells to depending on which text is selected in the drop down box. I have attached an example of the workbook to help.
The cells i would want to copy are A7:A27, C7:C27 but only if they have text in them.
The drop down box is in cell B2 on the attached example and the two options are "Book 1" or "Book 2"
I would also be running this VBA multiple times a day for different data (as the sending book is a template that will be clean of data each time it is opened) so would need the code to paste below any rows that are already in use on the book where the data will be posted.
I hope this makes sense.
I have searched this forum and others and although there is a lot of posts about this subject across the net they do not refer to one cell with multiple options and tend to copy entire rows which is not what i would like to happen if possible.
Many thanks for any help in advance.