+ Reply to Thread
Results 1 to 2 of 2

Check two Conditions and then SAVE Data - Excel VBA

  1. #1
    Registered User
    Join Date
    03-15-2013
    Location
    Chennai
    MS-Off Ver
    Excel 2007
    Posts
    4

    Check two Conditions and then SAVE Data - Excel VBA

    Hi,

    I need your expert advice. Im working on a project and struck in the middle.

    enclosed excel file will explain my requirement.

    In a nut shell - I need to meet two criteria - Month & Quarter and then save, only if the either of the data is not saved earlier.

    Appreciate your quick help.

    Regards,
    Badz
    Attached Files Attached Files

  2. #2
    Forum Expert mrice's Avatar
    Join Date
    06-22-2004
    Location
    Surrey, England
    MS-Off Ver
    Excel 2013
    Posts
    4,967

    Re: Check two Conditions and then SAVE Data - Excel VBA

    You could try adding an extra column to Sheet2 which is a concatenation of the values in the existing three columns.

    Your search button macro then just needs to search for the concatenation of the new values to see if this exists in the new column on Sheet2.
    Martin

+ 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. Replies: 2
    Last Post: 01-14-2016, 03:53 PM
  2. How to check if excel file is Checked Out in SharePoing Check Out, run code, Check In
    By jrtraylor in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 01-08-2016, 04:36 PM
  3. Check data and Highlight Differnce before Save
    By kannan1847 in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 04-06-2015, 12:31 AM
  4. Check Replace and Save data
    By shreeku in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 08-03-2014, 03:50 AM
  5. Save an Excel file to Sharepoint and Check in
    By Brontosaurus in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 11-18-2013, 08:14 AM
  6. [SOLVED] Check column value in another worksheet and compare cell, and if different save data
    By marreco in forum Excel Programming / VBA / Macros
    Replies: 5
    Last Post: 09-21-2012, 08:01 PM
  7. Auto-save file after check that cells have data
    By Glio in forum Excel Programming / VBA / Macros
    Replies: 10
    Last Post: 12-09-2007, 02:21 AM

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