My friend at work reminded me that I got the original instructions off the internet .. then within 5 minutes, I had recalled how .. the secret is that under Edit is Go To and at bottom of Go To is Special .. and on Special is Visible Cells Only .. of the reason why I seemed to be overlooking it is that Go To has Special in a different location in Excel 2003 ..in Office 97, it is prominent off to the side and in 2003 it is down at the bottom.
Roger H ----- Original Message ----- From: "roger helbig" <[EMAIL PROTECTED]> To: <[email protected]> Sent: Friday, October 14, 2005 5:00 PM Subject: Excel 2003 Help - Sorting Sub-totals Related to Rob's Question, using Excel 2003, I am trying to sort on sub-totals. I have created the sub-totals and set up the collapsed worksheet, but I need to copy only the visible values into a new worksheet and then I will be able to sort on the sub-totals, but I can not seem to find how to copy the visible values. I am going to send the worksheet home and try on Office 97 (where I know I did this about a year ago), but I would like to be able to do this in Office 2003 as well since that is the tool at work. Thanks Roger Helbig On Fri, 14 Oct 2005 16:32:20 +0100 Rob Sharp <[EMAIL PROTECTED]> wrote: Evening all, I'm hoping someone here is fluent enough in Excel to help with with a document. I have a worksheet with around 10,000 rows. One of the columns is a Date. What I'd like to do is to product a chart that highlights how often each date appears. Ideally I'd first like to group the dates into Weeks, sum the number of records per week and then create a records per week chart, but a records-per-day chart would be fine also. It sounded fairly simple to me, but Excel 2003 has me beaten. Does anyone have any pointers? -- ---------------------------------------- To unsubscribe, mailto: [EMAIL PROTECTED] Is your picture included in the Official Win-Home List Members Profiles Page? http://www.besteffort.com/winhome/Profiles.html If not, write to: [EMAIL PROTECTED]
