Hi All, I don't know what keywords to search online for, so I figured I'd ask here. A co-worker of mine is old school and she takes data from excel, then has to manually hand-write customer information on separate sheets of paper to submit rebates to vendors. I only listed 4 examples below but there are hundreds a month.
<tbody>
</tbody>
My goal would be to stick the vendor form in the printer and then adjust where this customer information shows up in a cell range so when its printed, the name will show up in the correct spot on the vendor form.
So, Is there a way to transpose this so that it shows up looking like:
Alan Baker
123 Main St
New York, NY, 10001
212-555-2000
But then have this info be placed in a different cell (say the first customer information gets placed into cell i45 for the customer name, i46 for the address, etc) so that when I print all pages, the customer information prints in the correct spot). The second set of customer info would be placed in i97, so on and so on.
I am not sure if I explained this properly but any help would be appreciated.
A | B | C | D | E | F | |||||
1 | NAME | ADDRESS | CITY | STATE | ZIP | PHONE | ||||
2 | ALAN BAKER | 123 MAIN ST | New York | NY | 10001 | 212-555-2000 | ||||
3 | JOHN STONE | 45 W 3RD AVE | Queens | NY | 12006 | 646-555-1010 | ||||
4 | CHRIS BLACK | 19 4TH AVE APT 5 | BROOKLYN | NY | 13000 | 646-555-5000 |
<tbody>
</tbody>
My goal would be to stick the vendor form in the printer and then adjust where this customer information shows up in a cell range so when its printed, the name will show up in the correct spot on the vendor form.
So, Is there a way to transpose this so that it shows up looking like:
Alan Baker
123 Main St
New York, NY, 10001
212-555-2000
But then have this info be placed in a different cell (say the first customer information gets placed into cell i45 for the customer name, i46 for the address, etc) so that when I print all pages, the customer information prints in the correct spot). The second set of customer info would be placed in i97, so on and so on.
I am not sure if I explained this properly but any help would be appreciated.