LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #4   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 3,514
Default Generating Fresh Copies Of an Excel Document

After serious thinking Diane Van wrote :
We will see what the orginal poster says, but at my flying club, they print
out the log book sheets each day (and many days they need more than one
sheet). As planes are rented, the renter fills in the details him/herself,
signs out the plane, the sheet is authorized/signed by the club, and the
sheet is left at the desk on a clipboard. That way everyone can see when a
plane is due to be returned and who has it. Perhaps someone enters all this
info into an ongoing Excel sheet, but I doubt it.

So all he needs is a date and page code in the template, really. If this is
what his club does.


Good point!
I interpret your meaning of 'print out the log book sheets' each day as
meaning this info is constantly being updated during any given day with
new info entered during the course of that day, from that manual
sign-in/sign-out sheet.

My suggestion implies a consolidated record that's being kept of each
day's activities, which gets updated with entries from some manually
written source. In this case a sign-in/sign-out template that
duplicates the log worksheet's input portion that's needed for adding
entries would have to be used. This template would obviously provide
only enough lines to fit a printed page, and would (optionally) not
need to be stored after its data was entered into the record log
worksheet.

--
Garry

Free usenet access at http://www.eternal-september.org
ClassicVB Users Regroup!
comp.lang.basic.visual.misc
microsoft.public.vb.general.discussion


 
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
Excel opens 2 copies of every document - one in compatibility mode pb787878 Excel Discussion (Misc queries) 4 September 19th 09 07:47 PM
Generating an Excel document with a Macro [email protected] Excel Programming 1 May 22nd 07 08:47 AM
Generating a numbered document Alan M Excel Programming 1 April 20th 06 12:13 PM
Generating a numbered document Alan M Excel Programming 1 April 20th 06 09:42 AM
Two copies of same document appear when opening a document Kathy at the Fort Excel Discussion (Misc queries) 1 December 15th 04 05:46 PM


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

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"