I recommend that you create a spreadsheet that contains all of the headers and formulas that you use on a monthly sheet. Name this sheet Blank sheet and then create sheets for each month from this blank sheet. The name for each sheet that you create will reflect the name of the month it represents. Here is what you will need to do:
Since you already have one sheet started, you will first need to name that sheet if you have not already done so. Do this by: Use Insert+Shift+S to bring up a context menu. Arrow down to Rename. Type in the new name for the sheet and press Enter. Now make a copy of this original sheet by: Using Insert+Shift+s to bring up a context menu. Arrow down to Move/copy and press enter. A dialog box will open. You will land in a list box containing the names of all of the sheets in the workbook. Use your up and down arrow to select the sheet that you want to place the new sheet before. (I know I am not explaining this part well, but once you are there, it will make sense.) TAB once and press Space to put a check in the box for making a copy of the sheet. At the top of this dialog box, there is another which you are not going to use this time, but I wanted you to know that it was there. It is for copying or moving the sheet into a different workbook. Now TAB to OK and press enter. Rename this new sheet to include the word blank in the title. Use the Insert+Shift+S command as you did above. Now clear out the data that exists, but do not clear out the headers and formulas. Now each month you will make a copy of this blank sheet, rename it and enter in your data. As far as comparing your monthly sheets, this will depend on what data you are collecting, and what you want to learn when you compare them. HTH, Annette -----Original Message----- From: [email protected] [mailto:[email protected]] On Behalf Of leonard morris Sent: Monday, January 16, 2012 6:57 AM To: [email protected] Subject: [JAWS-Users] creating sheets in an 2007 xl work book I have a xlx 2007 workbook called groceries. I started this month keeping track of items and cost. When February comes around I want to create another sheet within the same xlx groceries workbook. Then I would like to be able to easily compare work sheet data for each month. Do I have the concept correct or do I need to make another workbook for each month? For answers to frequently asked questions about this list visit: http://www.jaws-users.com/help/ For answers to frequently asked questions about this list visit: http://www.jaws-users.com/help/
