I am trying to create a command button that will send rows of data to Word
from Excel. Let me give you what the spreadsheet looks like:
1) This is a fixed row (Row 6) and below are the captions in those rows
Name Quantity In Out Total Date Vendor
2) The data starts on Row 7
3) So it looks like this (this data can go on for 30 rows):
Name Quantity In Out Total Date Vendor
Bandsaws 10 7 2 $700 3/20/2005 NBS
Pumice 20 1 3 $900 1/01/2005 OXS
4) The vendor IDs are located in a different worksheet. So if it would be
possible to reference it when going to word. As shown below in step 5:
5) What I want to try to get it to look like in Word:
Name: Bandsaws
Quantity: 10 units, In: 7, Out: 2, Total: $700, Date: 03/20/2005, Vendor:
National Bandsaw Company
Name: Pumice
Quantity: 20 units, In: 1, Out: 3, Total: $900, Date: 01/01/2005, Vendor:
Oxford Building Supplies
Can any of this be possible in Excel?? Thanks!!
Bookmarks