Just Click on logo to return to full home page

 

Your Ad Here

Excel help

sithkhan
10-18-06, 12:15 AM
Hey - I need some help. I am creating a log book at work that will be printed out and bound. It is to enter data into as the techs create the samples. I have a column that will be sequential numbers that will be printed out in one column. I want to have a recurring row that has specific fieldss like date, time, mass ect that will be on each page as it's printed. I thought about a simple copy and paste, but that would break the sequential number formula. Any ideas? Thanks, n00bsters - you make beating my head against the wall worthwhile!

lol

Peterp
10-18-06, 12:17 AM
Hey - I need some help. I am creating a log book at work that will be printed out and bound. It is to enter data into as the techs create the samples. I have a column that will be sequential numbers that will be printed out in one column. I want to have a recurring row that has specific fieldss like date, time, mass ect that will be on each page as it's printed. I thought about a simple copy and paste, but that would break the sequential number formula. Any ideas? Thanks, n00bsters - you make beating my head against the wall worthwhile!

lol

er....File...page setup...sheet...rows to repeat at top

that should do it for you mate

moonman
10-18-06, 12:18 AM
I am almost sure that you can put a header and footer on the page and then have an auto-update entry that will do page numbers and date and time. Ill check right now. What version are you using.

Peterp
10-18-06, 12:31 AM
You can, in all recent versions it's under the customised header/footer function :D

EZ Archive Ads Plugin for vBulletin Copyright 2006 Computer Help Forum