Hi,
I'm not sure if this is possible, but I will try to explain what I am looking to do.
I have a sales spreadsheet where the start of each order's address information is 10 rows apart and spans up to 7 rows.
To print the postage labels, I currently have to manually select the range, copy the selection and paste into a Word document which contains a table which represents the layout of the labels on the page. This can be time consuming when I have a lot of orders to send and what I would really like to do is to be able to highlight a range and have Excel extract the relevant address information and automatically paste them sequentially into the appropriate cells in my table in Word.
One of the difficulties I can see is telling Word which cells to paste into i.e. not into the intermediate cells spacing the labels.
Here are some pictures which should hopefully help to explain a bit better:
Address info in Excel.PNGLabel template in Word.PNG
So in the pictures, let's say I wanted to select the range A880:A897, which contains two orders' addresses, and have them pasted them into cell 1 and cell 3 of my table in Word. Of course for 2 addresses it's quick, but for 20 it's a bit more monotonous.
Is this possible? If so, is it more work than it's worth?
Thanks in advance for any help.
Bookmarks