Results 1 to 4 of 4

post entries but keep formulas

Threaded View

  1. #1
    Forum Contributor
    Join Date
    10-01-2012
    Location
    england
    MS-Off Ver
    Excel 2016 pro
    Posts
    772

    post entries but keep formulas

    hi
    i need to be able to keep formuas in t2:t50 (sheet3) when items are posted from sheet3 by sheet(frmissued),i enter a date in sheet3 h2:h50 which gives me a due date (7 days later ) in t2:t50, but when i save sheet and delete entries it also deletes the formula in t2:t50,how can i make t2:t50 reset to =h2:h50+7
    any help would be good please
    cheers colin
    Attached Files Attached Files
    Last edited by cfinch100; 04-06-2015 at 01:51 AM.

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. [SOLVED] How to prevent duplicate entries in two columns with formulas?
    By cody4334 in forum Excel Formulas & Functions
    Replies: 11
    Last Post: 07-02-2014, 07:48 AM
  2. VBA copy down formulas to next blank row only works with manual entries ?
    By Trubster in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 08-05-2013, 11:18 AM
  3. Counting Post Code Entries Across Sheets
    By j4ke101 in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 06-19-2013, 08:31 AM
  4. Replies: 4
    Last Post: 03-13-2012, 02:20 PM
  5. [SOLVED] Excel: Clear all cell entries EXCEPT formulas?
    By newsgal in forum Excel General
    Replies: 6
    Last Post: 03-17-2006, 08:50 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