I am trying to create a form for listing customers equipment.
That bit is easy, but I want it to increase in size as it is completed.
The page is just a simple list, with say 30 rows and 3 headings (No. Description, Comment)
As it stands, it is one portrait page. I want to develop it so that it adds a second page below with headings and cell borders when the final cell is completed or when the user moves out of the last cell.
Can anyone help?
Using your Page Set up options, set the "header row" to repeat on all sheets.I want to develop it so that it adds a second page below with headings and cell borders when the final cell is completed or when the user moves out of the last cell.
As for the cell borders, you should consider using Conditional Formatting to apply the borders when the cells have actual entries made in them.
See this link for help: Excel Conditional Formatting -- Introduction
Palmetto
Do you know . . . ?
You can leave feedback and add to the reputation of all who contributed a helpful response to your solution by clicking the star icon located at the left in one of their post in this thread.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Reply With Quote
Bookmarks