ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   Transfering a row of data to a template word or worksheet (https://www.excelbanter.com/excel-discussion-misc-queries/52440-transfering-row-data-template-word-worksheet.html)

Marc Williams

Transfering a row of data to a template word or worksheet
 
This may be a bit rudimentary but I'm a relative novice to Excel. I store
customer purchase data in a row of some 20 columns. Each purchase has a new
row and a corresponding order number (in the second column of that row) To
save me typing out an invoice by duplicatiing some of the information on the
row, is there a way that some of that data can be automatically copied to
either specific cells within another worksheet template or perhaps a word
document. The destination template would normally feature some standard
information/text which would be common to all invoices.

Anyone who can offer some advice would be very much appreciated.
Cheers
Marc Williams

Anne Troy

Transfering a row of data to a template word or worksheet
 
Marc, perhaps you could use our free invoicing application. You can download
it at www.officearticles.com/downloads
Or, you could create your own using our tutorial at:
http://www.officearticles.com/tutori...soft_excel.htm
************
Anne Troy
www.OfficeArticles.com

"Marc Williams" wrote in message
...
This may be a bit rudimentary but I'm a relative novice to Excel. I store
customer purchase data in a row of some 20 columns. Each purchase has a
new
row and a corresponding order number (in the second column of that row) To
save me typing out an invoice by duplicatiing some of the information on
the
row, is there a way that some of that data can be automatically copied to
either specific cells within another worksheet template or perhaps a word
document. The destination template would normally feature some standard
information/text which would be common to all invoices.

Anyone who can offer some advice would be very much appreciated.
Cheers
Marc Williams





All times are GMT +1. The time now is 08:01 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com