Power Query Course in Spanish
Thanks Thanks:  0
Likes Likes:  0
Results 1 to 2 of 2

Thread: Removing all data for a new month and save

  1. #1
    New Member
    Join Date
    Feb 2002
    Location
    Benjamin
    Posts
    8
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    I have a worksheet that summarizes data by weeks. All data for one week is on one row. At the end of the month I want to press a button or run a macro that saves the sheet as mm/yy/sheetname then deletes all data except my formulas so that I can start over for the next month.

    _________________
    I love to learn

    [ This Message was edited by: benkong2 on 2002-02-20 17:05 ]

  2. #2
    Board Regular
    Join Date
    Feb 2002
    Posts
    202
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    you might instead try creating an excel template (see the help topic) in which you insert your formulas. it just means you'll name the workbook at the beginning of the month (when you first save it) rather than at the end of the month, but you'll always have the template to create a workbook for a new month.

    [ This Message was edited by: anno on 2002-02-20 17:29 ]

    [ This Message was edited by: anno on 2002-02-20 17:30 ]

Some videos you may like

User Tag List

Like this thread? Share it with others

Like this thread? Share it with others

Posting Permissions

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