+ Reply to Thread
Results 1 to 3 of 3

Clear the Contents of sheet without clearing previous data

Hybrid View

  1. #1
    Registered User
    Join Date
    05-15-2021
    Location
    india
    MS-Off Ver
    2019
    Posts
    1

    Question Clear the Contents of sheet without clearing previous data

    Hi..
    So I am trying to make a tracker where if I click on next month macro button, data entered for the previous month gets saved and clears the sheet for next month without formatting any formula. For Eg. If i have entered some data for jan month and i click macro buttom for next month, then the sheets automatically resets for feb month but if i go to jan month i can get jan month data also.

    Also each country have different months to work on. Pls Help. Its Urgent.
    Last edited by manshagupta1995; 05-17-2021 at 07:21 AM.

  2. #2
    Forum Expert
    Join Date
    11-24-2013
    Location
    Paris, France
    MS-Off Ver
    Excel 2003 / 2010
    Posts
    9,831

    Arrow Re: Clear the Contents of sheet without clearing previous data


    Hi,

    for 'Urgent' stuff just go to the Commercial Services in the top of this page …

  3. #3
    Forum Expert
    Join Date
    12-24-2007
    Location
    Alsace - France
    MS-Off Ver
    MS 365 Office Suite
    Posts
    5,097

    Re: Clear the Contents of sheet without clearing previous data

    A file as sample is urgently needed, can you attach one ?
    - Battle without fear gives no glory - Just try

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. clear contents of entire sheet except the contents of the table
    By wayneg in forum Excel Programming / VBA / Macros
    Replies: 5
    Last Post: 08-06-2015, 08:41 AM
  2. VBA Clearing Sheet Contents
    By bkeat in forum Excel Programming / VBA / Macros
    Replies: 10
    Last Post: 12-18-2013, 12:35 PM
  3. Clear cell contents on closing/opening without clearing formulas
    By CFT Brian in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 10-28-2013, 03:47 PM
  4. VBA code to clear the contents (or value) of a cell without clearing the formula
    By BazzaBit in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 03-10-2013, 08:16 PM
  5. [SOLVED] Clear contents of last used cell in a range and those previous to it (excel 2003)
    By chris_norton in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 08-17-2012, 02:06 PM
  6. How to clear formula without clearing cell contents
    By prayami in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 01-03-2008, 04:33 AM
  7. [SOLVED] [SOLVED] Excel should let me clear cell contents without clearing formulas
    By BJM in forum Excel Programming / VBA / Macros
    Replies: 5
    Last Post: 11-19-2005, 01:00 PM

Bookmarks

Posting Permissions

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

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1