Results 1 to 3 of 3
  1. #1
    Lounger
    Join Date
    Feb 2001
    Location
    Upstate, New York, USA
    Posts
    47
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Opening workbook to current month's sheet

    Excel 2000

    I'm sorry to be repetitive (since I've seen this solution here before), but I believe it's gone from the archive.

    I have a workbook for expense reports that has a separate sheet for each month. I'd like to have the workbook open to the current month each time, and go to the first available cell for entry (so if I open March and I've already filled in A10:A15, the active cell would be A16).

    Can someone repost this for me? I'd certainly appreciate it. [img]/S/dizzy.gif[/img]

  2. #2
    Uranium Lounger
    Join Date
    Jan 2001
    Location
    South Carolina, USA
    Posts
    7,295
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Opening workbook to current month's sheet

    I believe that the thread you are looking for is <A target="_blank" HREF=http://www.wopr.com/cgi-bin/w3t/showthreaded.pl?Cat=&Board=xl&Number=12518&page=&v iew=&sb=&vc=1#Post12518>Here</A>
    Legare Coleman

  3. #3
    Lounger
    Join Date
    Feb 2001
    Location
    Upstate, New York, USA
    Posts
    47
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Opening workbook to current month's sheet

    Thanks Legare - that was it.

    I'd had it working just fine in my workbook, then someone went and deleted the file and left me high and dry.

    I appreciate the quick response. [img]/S/thumbup.gif[/img]

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •