Saving Select Sheets in Excel 2002 Workbook

[bobnplano]

I am using Excel 2002 on a laptop using Windows XP Pro SP 2.

In my business I am required to fill in a 6 page document in Excel. On each page there are multiple cells that need to be filled in. It is somewhat cumbersome to skip around to all these cells, even using a wireless mouse. I added a 7th sheet to the workbook & created a template that is simply entering the data & hitting return. I have setup the template to link to the corresponding page & cell. I find it easier to type information & hit return easier than tabbing several times to get the next required field. An example of the document requires some of the following followed by a cell to enter the information. There are also cells intermittantly that are to be filled in by my office. Therefore there are numerous cells to be filled in of which some are to be left blank:

Date



Address Case Number
City
State
Zip
Occupancy Status Date Assigned
Date Entered/Start Time/Duration





Access Method Water Supply
Size
Temperature
Wall Structure
Weather Conditions Inside Unit Brand
Inside Unit Model #
Inside Unit Type
Outside Unit Brand
Outside Unit Model #
Outside Unit Type

This is only a sampling of page 1 & each description is followed by a cell to enter the data. I have spaced this out similar to the form itself. All the remaining 5 pages are similar but with many more cells to place an X in; i.e., Yes No NA. As you can see this can be a very tedious form to fill out. I was originally doing this by hand & then scanning & then uploading to my office software causing many late evening hours. I'd like to be able to do this from the field so that I'm not working up to dark thirty. The day is long enough now.

Once again I added a page 7 with a template so that I can just fill in the cells in a vertical manner & linking those cells to the corresponding page of the form. I want to be able to add a page 7 to the document & paste my template for the purpose of using the vertical method. However, once I am done with the document, I want to be able to save only (& only) the 6 pages without the template so that I can upload those 6 pages only. Does this make sense? I have been successful in creating the template for the first couple of pages just to see if it works but then I don't know how to save only those 6 pages. Secondly, after saving those 6 pages will the office be able to read the 6 page document without the template?

Any help would be appreciated

Bob

 

[SkipVought]

Hi,

"I find it easier to type information & hit return easier than tabbing several times to get the next required field."

If you UNLOCK the cells that you enter data in and PROTECT the sheet, all you need do is enter data and TAB ONCE, to the next cell. THEN save this workbook with the PROTECTED sheet seven, as a TEMPLATE. File > New and select from your TEMPLATES when you want to USE.

You have six SHEETS and have added a seventh SHEET (not pages - pages happen when you print). You want to save the six sheets.

Try this process. Once you understand how it's done, turn on your macro recorder:
[tt]
1. SELECT the SHEETS you want to save.

2. Right-Click any of the SELECTED sheet tabs and select Move or copy... - CHECK the Create a copy box -- To book: (New book)

3. Save your 6-sheet workbook.

4. Close your 6-sheet workbook.
[/tt]
If you want to customize your new macro, please post you code and specific questions in Forum707.




Skip,

_{Have you heard that the roundest knight at King Arthur's round table was...
Sir Cumference!}

 

[bobnplano]

Skip, please forgive me for my ignorance about macros & unlocking cells. All that sounds like it will be just what I'm looking for. However, I have no experience with macros & how do I know the cells are locked to begin with since I am able to enter data. I thought locked cells meant I could not enter data, but only read. I apologize for saying pages when it should have been pages, but in my company's spreadsheet the sheets are renamed as pages 1 through 6. Can you walk me through this a little slower?

Thanks in advance.

Bob

 

[SkipVought]

"I know the cells are locked to begin with since I am able to enter data. "

LOCKED is the default state. However, locked and unlocked ONLY means anything, when the sheet is protected. Hence, my paragraph, beginning, "If you UNLOCK the cells that you enter data..."

"I have no experience with macros..."

The only reason I suggested recording a macro is so that you could perform the series of steps as I outlined above, with the click of a button, rather than having to do this labor intensive task, over and over. Knock yourself out if you care not to use the recorder. Otherwise, just search Excel HELP for macro recorder

Skip,

_{Have you heard that the roundest knight at King Arthur's round table was...
Sir Cumference!}