Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
I have a large workbook I use to record purchase orders in, for what its
worth the workbook was started on a Windows 95 Office 97 computer, as the years have gone by different computers,users have been adding info and making changes. There are 4 sheets. I am trying to divide this year into quarters by making another sheet. When I try to do this, the "copy sheet" or "move sheet" info is shown in gray, rather than bold type so I am unable to use these drop downs and click on what I am trying to do. From what I can tell , the workbook is not password protected, I am baffled a bit. I don't have a network, I work in the day on a desktop, then copy this file to a "memory stick" and some nights take home to work on my laptop. I then resave the whole notebook. I am trying to get where I just can use the current year instead of every time I save or add to it, I copy all 4 sheets. Ideally, I would like to just have one sheet per year, and be able to break that down to semi-annual or quarters, just so when I take the work home I don't have to copy the whole database just to work with a few rows. -- Rick M |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Command to count number of worksheets in a workbook? | Excel Worksheet Functions | |||
Data referencing and auto fill across worksheets in one workbook.. | Excel Worksheet Functions | |||
How do I open several worksheets from the same workbook on screen | Excel Worksheet Functions | |||
Protecting all worksheets of a workbook | Excel Discussion (Misc queries) | |||
How do I build a workbook from the worksheets another workbook? | Excel Discussion (Misc queries) |