+ Reply to Thread
Results 1 to 11 of 11

Remove certain values ​​from excel cells

  1. #1
    Forum Contributor
    Join Date
    11-10-2011
    Location
    Bucharest, RO
    MS-Off Ver
    Excel 2016
    Posts
    118

    Remove certain values ​​from excel cells

    Does anyone know if Excel 2003 can implement a button that once pressed to bring the value "0" certain values ​​of several excel sheet's.
    For example, if I have an excel file with 10 sheets and each sheet there is a table with various data. At one point values ​​in all tables must bring default "0" but it's a huge job to do this work manually. For this reason I was thinking to create a button or whatever, in another excel file which once clicked, to do this thing. Can this be done? And if so, how?
    Last edited by public; 12-12-2013 at 07:39 AM.

  2. #2
    Forum Expert
    Join Date
    06-12-2012
    Location
    Ridgefield Park, New Jersey
    MS-Off Ver
    Excel 2003,2007,2010
    Posts
    10,241

    Re: Remove certain values ​​from excel cells

    Please attach a sample workbook showing how one sheet would look, and where the default "0" should go. To attach a file, push the button with the paperclip (or scroll down to the Manage Attachments button), browse to the required file, and then push the Upload button.

  3. #3
    Forum Contributor
    Join Date
    11-10-2011
    Location
    Bucharest, RO
    MS-Off Ver
    Excel 2016
    Posts
    118

    Re: Remove certain values ​​from excel cells

    I would take a day of work to attach a sample workbook. In fact I have two files, one has over 10 excel sheets and the other has 7 excel sheet. Files are quite complex, with private data that can not attach to a forum.

    But tell me what options are to do and then I will analyze solutions.

  4. #4
    Forum Expert
    Join Date
    06-12-2012
    Location
    Ridgefield Park, New Jersey
    MS-Off Ver
    Excel 2003,2007,2010
    Posts
    10,241

    Re: Remove certain values ​​from excel cells

    I meant one sheet to show how a sheet looks before running the macro, and a result sheet showing how it would look after.

  5. #5
    Forum Moderator - RIP Richard Buttrey's Avatar
    Join Date
    01-14-2008
    Location
    Stockton Heath, Cheshire, UK
    MS-Off Ver
    Office 365, Excel for Windows 2010 & Excel for Mac
    Posts
    29,464

    Re: Remove certain values ​​from excel cells

    ....
    and we don't need to see zillions or rows or columns, as long as you show us a representative sample of all your permutations. Take a copy, delete superfluous rows/columns and anonymise any sensitive data. Then upload that.
    Richard Buttrey

    RIP - d. 06/10/2022

    If any of the responses have helped then please consider rating them by clicking the small star icon below the post.

  6. #6
    Forum Contributor
    Join Date
    11-10-2011
    Location
    Bucharest, RO
    MS-Off Ver
    Excel 2016
    Posts
    118

    Re: Remove certain values ​​from excel cells

    I quickly made a model with just one sheet.
    Enter data in white cells. After entering data, this data will be back to 0.
    I was thinking to use a separate excel file where to find a button to bring those values ​​to 0.

    I have attached file on a website because internet network that I am not let me upload files to this forum and I don't know why!
    http://www.4shared.com/office/xcjA2CXo/model.html

  7. #7
    Forum Moderator - RIP Richard Buttrey's Avatar
    Join Date
    01-14-2008
    Location
    Stockton Heath, Cheshire, UK
    MS-Off Ver
    Office 365, Excel for Windows 2010 & Excel for Mac
    Posts
    29,464

    Re: Remove certain values ​​from excel cells

    Hi,

    Many of us won't upload from a third party site about which we know little.

    You may be lucky and find someone here who will but your audience of helpers is reduced.

  8. #8
    Forum Contributor
    Join Date
    11-10-2011
    Location
    Bucharest, RO
    MS-Off Ver
    Excel 2016
    Posts
    118

    Re: Remove certain values ​​from excel cells

    I'll upload the file on this website when I get home in a few hours.

  9. #9
    Forum Contributor
    Join Date
    11-10-2011
    Location
    Bucharest, RO
    MS-Off Ver
    Excel 2016
    Posts
    118

    Re: Remove certain values ​​from excel cells

    And file again:
    Attached Files Attached Files

  10. #10
    Forum Moderator - RIP Richard Buttrey's Avatar
    Join Date
    01-14-2008
    Location
    Stockton Heath, Cheshire, UK
    MS-Off Ver
    Office 365, Excel for Windows 2010 & Excel for Mac
    Posts
    29,464

    Re: Remove certain values ​​from excel cells

    OK,

    So with specific references to cell on the sheet you have attached would you clearly describe what you want to happen.

  11. #11
    Forum Contributor
    Join Date
    11-10-2011
    Location
    Bucharest, RO
    MS-Off Ver
    Excel 2016
    Posts
    118

    Re: Remove certain values ​​from excel cells

    In white cells from Center 1, 2 and 3 fields entering or intput data (quantity and duration). After it completes a full year, the entries must be brought to 0. So, the same input must be reset to 0.

+ 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. Replies: 0
    Last Post: 11-27-2013, 09:11 PM
  2. How to Send values ​​to another sheet by skipping column
    By herukuncahyono in forum Excel Programming / VBA / Macros
    Replies: 10
    Last Post: 07-19-2013, 02:41 PM
  3. Replies: 7
    Last Post: 11-23-2012, 08:40 AM
  4. [SOLVED] Function does not extract values ​​correctly
    By marreco in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 11-06-2012, 05:31 AM
  5. [SOLVED] VBA to sum values ​​based on the values ​​in column
    By young_86 in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 10-31-2012, 11:49 AM

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