LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
Posts: 3
Default Opening sheets

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
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
question about many sheets in one warkbook tzveti Excel Worksheet Functions 1 May 30th 06 05:42 PM
Microsoft Visual Basic: Compile error: Sum or Function not defined Dmitry Excel Worksheet Functions 12 April 3rd 06 07:28 AM
In 3 active sheets in wkbk, determine& display the # of sheets that have data wrpalmer Excel Discussion (Misc queries) 1 November 4th 05 02:01 PM
Opening multiple Excel files that contain varied selected sheets MLBrownewell Excel Worksheet Functions 0 September 14th 05 05:48 PM
calculating excel spreadsheet files for pensions and life insurance (including age calculation sheets) RICHARD Excel Worksheet Functions 1 March 15th 05 05:49 PM


All times are GMT +1. The time now is 03:10 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"