+ Reply to Thread
Results 1 to 13 of 13

Checking Columns and Adding For Non Existing Data

  1. 09-17-2011, 07:43 AM #1
    pterodactyl
    pterodactyl is offline
    Registered User
    Join Date
    09-17-2011
    Location
    Melbourne
    MS-Off Ver
    Excel 2003
    Posts
    13
    This post has been deleted.

    Thank you for your understanding.
    Last edited by pterodactyl; 09-25-2011 at 01:57 AM.
    Reply With QuoteRegister To Reply
  2. 09-17-2011, 11:31 AM #2
    mrice
    mrice is offline
    Forum Expert mrice's Avatar
    Join Date
    06-22-2004
    Location
    Surrey, England
    MS-Off Ver
    Excel 2013
    Posts
    4,967

    Re: Checking Columns and Adding For Non Existing Data

    Try this

    Please Login or Register  to view this content.
    Martin
    Reply With QuoteRegister To Reply
  3. 09-17-2011, 06:24 PM #3
    pterodactyl
    pterodactyl is offline
    Registered User
    Join Date
    09-17-2011
    Location
    Melbourne
    MS-Off Ver
    Excel 2003
    Posts
    13

    Re: Checking Columns and Adding For Non Existing Data

    This post has been deleted

    Thank you for your understanding.
    Last edited by pterodactyl; 09-25-2011 at 01:58 AM.
    Reply With QuoteRegister To Reply
  4. 09-18-2011, 03:08 PM #4
    mrice
    mrice is offline
    Forum Expert mrice's Avatar
    Join Date
    06-22-2004
    Location
    Surrey, England
    MS-Off Ver
    Excel 2013
    Posts
    4,967

    Re: Checking Columns and Adding For Non Existing Data

    Try

    Please Login or Register  to view this content.
    I've removed the blank row 16 on the Customer sheet which makes things easier.
    Reply With QuoteRegister To Reply
  5. 09-18-2011, 05:51 PM #5
    pterodactyl
    pterodactyl is offline
    Registered User
    Join Date
    09-17-2011
    Location
    Melbourne
    MS-Off Ver
    Excel 2003
    Posts
    13

    Re: Checking Columns and Adding For Non Existing Data

    This post has been deleted.

    Thank you for your understanding.
    Last edited by pterodactyl; 09-25-2011 at 01:59 AM.
    Reply With QuoteRegister To Reply
  6. 09-19-2011, 02:33 AM #6
    mrice
    mrice is offline
    Forum Expert mrice's Avatar
    Join Date
    06-22-2004
    Location
    Surrey, England
    MS-Off Ver
    Excel 2013
    Posts
    4,967

    Re: Checking Columns and Adding For Non Existing Data

    Your attachment appears to have disappeared from the thread - can you reattach?
    Reply With QuoteRegister To Reply
  7. 09-19-2011, 05:18 AM #7
    pterodactyl
    pterodactyl is offline
    Registered User
    Join Date
    09-17-2011
    Location
    Melbourne
    MS-Off Ver
    Excel 2003
    Posts
    13

    Re: Checking Columns and Adding For Non Existing Data

    Deleted.

    Thank you for your understanding.
    Last edited by pterodactyl; 09-25-2011 at 02:00 AM.
    Reply With QuoteRegister To Reply
  8. 09-20-2011, 09:59 PM #8
    pterodactyl
    pterodactyl is offline
    Registered User
    Join Date
    09-17-2011
    Location
    Melbourne
    MS-Off Ver
    Excel 2003
    Posts
    13

    Re: Checking Columns and Adding For Non Existing Data

    This post has been deleted.

    Thank you for your understanding.
    Last edited by pterodactyl; 09-25-2011 at 02:04 AM.
    Reply With QuoteRegister To Reply
  9. 09-21-2011, 01:27 AM #9
    pterodactyl
    pterodactyl is offline
    Registered User
    Join Date
    09-17-2011
    Location
    Melbourne
    MS-Off Ver
    Excel 2003
    Posts
    13

    Re: Checking Columns and Adding For Non Existing Data

    This post has been deleted.

    Thank you for your understanding.
    Last edited by pterodactyl; 09-25-2011 at 02:04 AM.
    Reply With QuoteRegister To Reply
  10. 09-24-2011, 02:43 PM #10
    mrice
    mrice is offline
    Forum Expert mrice's Avatar
    Join Date
    06-22-2004
    Location
    Surrey, England
    MS-Off Ver
    Excel 2013
    Posts
    4,967

    Re: Checking Columns and Adding For Non Existing Data

    I'm not sure how close I am to what you are after but please have a look at the attached.

    A new row is created in the companies table when a novel value is added. I've also added a bit of functionality to pull in details for existing customers.

    Please have a play with it and see what else needs doing.
    Reply With QuoteRegister To Reply
  11. 09-24-2011, 06:38 PM #11
    pterodactyl
    pterodactyl is offline
    Registered User
    Join Date
    09-17-2011
    Location
    Melbourne
    MS-Off Ver
    Excel 2003
    Posts
    13

    Re: Checking Columns and Adding For Non Existing Data

    This post has been deleted.

    Thank you for your understanding.
    Last edited by pterodactyl; 09-25-2011 at 02:05 AM.
    Reply With QuoteRegister To Reply
  12. 09-25-2011, 06:08 AM #12
    mrice
    mrice is offline
    Forum Expert mrice's Avatar
    Join Date
    06-22-2004
    Location
    Surrey, England
    MS-Off Ver
    Excel 2013
    Posts
    4,967

    Re: Checking Columns and Adding For Non Existing Data

    Here it is. Sorry about that.
    Attached Files Attached Files
    Reply With QuoteRegister To Reply
  13. 09-25-2011, 07:16 AM #13
    arlu1201
    arlu1201 is offline
    Forum Contributor arlu1201's Avatar
    Join Date
    09-09-2011
    Location
    Bangalore, India
    MS-Off Ver
    Excel 2003 & 2007
    Posts
    19,166

    Re: Checking Columns and Adding For Non Existing Data

    Why have you deleted all your posts? Its tough to find out what is the problem.
    Reply With QuoteRegister To Reply
+ Reply to Thread
« Previous Thread | Next Thread »

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

Forum Rules


Search Engine Friendly URLs by vBSEO 3.6.0 RC 1