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
|