Home | Contact Us | FAQ | Search & Site Map | Link to Us
Sign In | Join | Other 45 Sites in Network
Home
DiscussionsAccessExcelInfoPathOutlookPowerPointPublisherWord
DirectoryUser Groups
Related Topics
Outlook ExpressInternet ExplorerWindowsMS Server ProductsMore Topics ...

MS Office Forum / Excel / New Users / January 2008

Tip: Looking for answers? Try searching our database.

Printing data using a standardized template

Thread view: 
Enable EMail Alerts  Start New Thread
Thread rating: 
Mike - 30 Jan 2008 14:14 GMT
If this is an idiotic question, please forgive...
I have spreadsheet with 2 tabs (worksheets).  The first tab has 15
columns and 350 rows of data.  The second tab is basically a printing
template.  It has 8 columns and 46 rows but it is mostly formatted to
print and allow users to handwrite data on each page.  However, I
would like to pre-populate the report with data from 5 of the columns
of the first tab and create a separate printed page for each row.
(Think mail merge kinda function).  I am pretty sure that I can figure
out how to do this with MS Access, but since I already have everything
set up in MS Excel, I thought that I would first check to see if there
was an easy way to do this in Excel.
Thanks for your help.
Dave Peterson - 30 Jan 2008 15:05 GMT
Maybe...
http://contextures.com/xlForm03.html
and
http://contextures.com/xlForm02.html
Both from Debra Dalgleish's site.

Or visit John Walkenbach's site:
http://www.j-walk.com/ss/excel/tips/tip92.htm

If you're new to macros, you may want to read David McRitchie's intro at:
http://www.mvps.org/dmcritchie/excel/getstarted.htm

But I would seriously consider using excel as the source and merge via MSWord.

> If this is an idiotic question, please forgive...
> I have spreadsheet with 2 tabs (worksheets).  The first tab has 15
[quoted text clipped - 8 lines]
> was an easy way to do this in Excel.
> Thanks for your help.

Signature

Dave Peterson

 
Sign In
Join
My Latest Posts
My Monitored Threads
My Blog
My Photo Gallery
My Profile
My Homepage

Start New Thread
Enable EMail Alerts
Rate this Thread



©2008 Advenet LLC   Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.