Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Marc Williams
 
Posts: n/a
Default 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
  #2   Report Post  
Anne Troy
 
Posts: n/a
Default 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



Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
advanced: synchronizing data value across two worksheet drop boxes mdhokie Excel Worksheet Functions 1 October 6th 05 08:46 PM
Transfering data from 1 worksheet to another Larry L Excel Discussion (Misc queries) 1 August 29th 05 01:30 PM
Excel data not transfering to Word. Colums are expanded. carolsue1313 New Users to Excel 2 June 24th 05 08:16 PM
How do I copy data (word) into respective cells when the data bei. awg9tech New Users to Excel 1 January 12th 05 11:26 AM
Reference Data in Moved Worksheet tommcbrny Setting up and Configuration of Excel 1 December 1st 04 06:49 PM


All times are GMT +1. The time now is 11:40 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"