Formatting my sheet

I initially just started out wanting to have paper work we use in a digital format but you know how it goes..you realise what a program can do and you start getting ideas. I have recieved some extremely good help on here and i have only made a few posts.

Let me give you some background on my needs. I work in a Fruit and veg industry and every day we go into market to buy goods, the way things are currently done is by taking a wad of A4 paper which is printed out with a bog standard office table with blanks fields to fill out, at the end of the day all this information has to be totted up and written in the sheet..i hate it, so this sheet i have had help in making does it as i go along (just waitng to find out how to implement the final colum G). At the office they are still going to want a hardcopy of this so i want it to look exactly the same as the originals paper we work with, which it does..but, if i try to print it out for some reason there is information missing at the end, i can see line breaks on the sheet, what i need it to do is to print out everything and where it needs to run into another A4 page i would want the header printed at the top of the next page also with the days date but more importantly to information i have entered to print out as well..can you see any problems with this ?

Originally Posted by FDibbins

Go into Print Preview, select Page Setup, click the Sheet tab, under "Rows to repeat at top" highlight the rows you require in teh heading

It wont let do anything in that box..is that because the page is already spilling over into another ?.ie do i need to set this before the sheet starts getting filled out ?

Ah yes..that done the trick, thanks.

I have attached my sheet again, for some reason it is printing half a page of empty sheet, no fields filled in..why is that ?..if you have a look at in print preview what i have there i only want that to print out but it is printing a third page that has no values.

Hmm. .. Not sure what to do with that. Maybe I will just select to print only 2 pages.

Correct..i have no idea how to use VBA, im not actually sure what job it is going to do, i was going to ask if it is some sort of code telling it what to do directly..for me i think the window and button approach is more user friendly, unless of course that VBA was going to do it automatically everytime

Thanks, it doesnt seem to want to print out anything i add to it now, if i put more info on there to make it go over one page it is only showing what is currently there