Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
![]()
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. I don't have any real training in Excel, have just kind of looked up in a book or figure out what I need to do and have been ok. If anyone could help me figure out how to open and work with the other sheets in the workbook I would greatly appreciate it. Thanks in advance. Rick -- Rick M |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
question about many sheets in one warkbook | Excel Worksheet Functions | |||
Microsoft Visual Basic: Compile error: Sum or Function not defined | Excel Worksheet Functions | |||
In 3 active sheets in wkbk, determine& display the # of sheets that have data | Excel Discussion (Misc queries) | |||
Opening multiple Excel files that contain varied selected sheets | Excel Worksheet Functions | |||
calculating excel spreadsheet files for pensions and life insurance (including age calculation sheets) | Excel Worksheet Functions |