retain

  1. D

    Can I update a cell from date to general format and retain the date instead of being converted to a number?

    I want to update a column format to general instead of a date. Can I retain the date instead of the date being converted into a number?
  2. C

    Replace Value with Next if Zero

    I have an Excel question that I am afraid is out of my range of expertise. I have a list of items with inventory values. What I need is either a formula or script that will say if the value is zero, then grab the value from the next line for the same item number if it is not zero, and continue...
  3. T

    Retain Cell Value

    A1 = 2 B2 = 5 C3 = 7 C3 is the sum of A1:B2. If I were to delete the values in A1 and/or B2 what formula is needed to "keep" or retain C3 as 7. Last calculated value to remain active. Thanks
  4. sharky12345

    Extract number from string but retain leading zeros

    I want to extract the numbers from a cell containing a mixed string but I need to retain the leading zeros. My data consists of the following format: SD001, SD002 through to SD1790 There will always be the text 'SD' followed by 3 or 4 numerical digits and it's the numerics I need, but...
  5. Trevor3007

    retain date

    Hi, I use the the code below:- =IF(G2="y",TEXT(TODAY(),"dd/mm/yyyy"),"") which work great until the next day, when yesterdays day is now the present day. Is there a way to retain the original date ? Many thanks in advance. KR Trevor3007
  6. V

    Stop Counting

    Hi All. I need help with formula or vba to stop counting and retain last count (E5 or column E) E5=Today()-C1 C1=Today() D5=Blank or not Blank If D5=Blank then E5 counts If D5 is not blank or populated then counting stop and retain the number Thanks in advance for the help.
  7. R

    Require macro

    Hello, PN's in each row are alternate to each other but they are repeated in other rows in different order / sequence Example - PN's in 1st row are also in row 3,5 & 7. Output requirement - I need to retain only 1 row which has the maximum alternate parts and delete the remaining rows. In...
  8. I

    Retain final figure as month changes.

    Hi, I have a formula that reads from a cell based on the month we are in. the cell it reads from is a constantly changing figure throughout the course of the month. =IF(C3=MONTH(TODAY()), $C$16) The formula works perfectly fine, however, the problem lies when we move to the next month, the...
  9. S

    Split Excel File based on a column while retaining all other sheets

    Urgent help required: I have a excel file with 3 sheets, one sheet has the employee data dump. 2 other sheets have some analysis based on the data in employee data dump. My analysis makes use of formulae such as 'Countifs', 'Sumifs' etc. Now i want to split this file into several files...
  10. B

    VBA AdvancedFilter CopyToRange Missing Formats

    Hello All, I have successfully copied filtered data from one table to another with the code below. What is missing is the formatting from the source table "Data". The VBA code will only copy and paste the values. I want both data and formatting. How do I retain the formatting from the...
  11. B

    Retain selection in ActiveX list box

    Hi, I am using ActiveX list box with multiple selection. Now Whenever I close the workbook and then reopen, all the previous selections are gone. Is there a way to retain selections made in listbox?
  12. C

    Is it possible to refresh External Data and retain old data?

    I am importing data from a Microsoft query into excel. The query only holds the current days information, then the next day it disappears and the new data is there. I would like to be able to create a database/table that retains the old information and just inserts new rows for new information...
  13. I

    Cell to Hold Value

    Hi, I have searched the forums and net, but cannot get an answer. I am looking for a formula that will make a cell keep the last formula result unless it is changed. I am currently using: =IF(A6<>'Daily Input'!$B$4,M6,IF(A6='Daily Input'!$B$4,'Daily Input'!$C$8,M6)), but it is not working as...
  14. S

    Remove hyperlinks while retaining formatting

    Hi, I have some legacy workbooks with embedded hyperlinks that I need to get rid of. I know how to remove the links, but when doing so Excel resets the number formatting to general, removes colors, bold, italics, etc, etc. I need to retain this formatting. I tried copying the cell to then use...
  15. L

    Preserve rows in pivot table when refreshing data

    <meta http-equiv="Content-Type" content="text/html; charset=utf-8"><meta name="ProgId" content="Word.Document"><meta name="Generator" content="Microsoft Word 9"><meta name="Originator" content="Microsoft Word 9"><link rel="File-List"...
  16. M

    Bring Only Filtered Data to Pivot Table

    How do you retain the data that is filtered in the main worksheet (we filter on 5 or more columns) when creating a Pivot Table? Are we having trouble because we are using a Shared Workbook? Doesn't the administrator (first person in) have rights to make all changes? If Shared Workbook...

Some videos you may like

This Week's Hot Topics

Top