Results 1 to 9 of 9

Clear values, save formulas; Recalculate

Threaded View

  1. #1
    Registered User
    Join Date
    08-07-2004
    Location
    Colorado
    MS-Off Ver
    365
    Posts
    62

    Clear values, save formulas; Recalculate

    The attached sheet is used to inventory lottery tickets. The ticket number is scanned with a barcode reader and the info placed on an input line. Several other details are added then the line is "Added to inventory" with the macro button. The macro clears the input line so the next item can be entered. I can't clear the values without dumping the formulas in the calculating cells, which wouldn't be an issue but the cells won't recalculate the new input.

    I need to be able to clear the cell values (but leave the formulas) and need to kick the sheet to recalc the input row. Ideas?
    Attached Files Attached Files
    Last edited by itsunclebill; 03-21-2010 at 06:23 PM.

Thread Information

Users Browsing this Thread

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

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