retain

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?

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...

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

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...

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

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.

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...

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...

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...

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...

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?

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...

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...

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...

<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"...

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...