+ Reply to Thread
Results 1 to 1 of 1

Checkmarks overwritten by formula

  1. #1
    Registered User
    Join Date
    10-24-2020
    Location
    Budapest, Hungary
    MS-Off Ver
    Office 365 ProPlus
    Posts
    1

    Checkmarks overwritten by formula

    Hi there,

    I have arranged a table with a query, which pulls data from files in a certain folder. The folder is being updated regularly. Whenever I start the macro "Run Query", new file content is being added to the table.

    Columns H and I contain formulas, which will check, if the referenced task needs to be done or not (empty cell or "N/A"), and I also have set up data validation with a checkmark option (conditional formatting).

    Unfortunately, if I'm running a new query, which scans the folder again, the checkmarks, which have already been set, but now overwritten by the formulas, are gone.

    How to overcome this in some way (without changing the query source!), so that I can keep the checkmarks, and only new rows/file content will be added to the table?

    Attached you will find my example file.

    Thank you in advance.
    Best regards,
    Daniel
    Attached Files Attached Files

+ 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. [SOLVED] Create link to external file to determine if formula was overwritten
    By Webbers in forum Excel Formulas & Functions
    Replies: 9
    Last Post: 08-26-2019, 04:20 PM
  2. VBA Code Help - If file overwritten, continue. If file not overwritten, show warning.
    By spoliquin in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 07-22-2013, 05:03 PM
  3. [SOLVED] How to insert checkboxes, or checkmarks
    By IMacGill in forum Excel General
    Replies: 16
    Last Post: 04-17-2012, 01:50 PM
  4. [SOLVED] How to reverse overwritten formula
    By fcorp in forum Excel Programming / VBA / Macros
    Replies: 6
    Last Post: 04-10-2012, 07:15 AM
  5. checkmarks and dropdowns
    By marktug in forum Excel General
    Replies: 5
    Last Post: 08-19-2010, 03:20 AM
  6. Counting Symbol Checkmarks
    By scotfitz in forum Excel General
    Replies: 4
    Last Post: 10-19-2008, 01:51 PM
  7. [SOLVED] How do I protect a cell formula from being overwritten
    By wc in forum Excel General
    Replies: 1
    Last Post: 02-20-2006, 01:11 AM

Tags for this Thread

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