+ Reply to Thread
Results 1 to 6 of 6

Add unique data to 2 separate name.range using vba

  1. #1
    Forum Contributor HaroonSid's Avatar
    Join Date
    02-28-2014
    Location
    india
    MS-Off Ver
    Excel 2013
    Posts
    2,078

    Add unique data to 2 separate name.range using vba

    hi, everyone

    i have a workbook with three sheets with the names ("TO."), ("ENTRY"),("TOTAL."),



    I Will start from here, I will enter data here. Sheet("ENTRY").Range("c10:c300"), and i want to add data to sheets("TO.") and ("TOTAL.") at a time

    now

    I want, IF I add A DATA IN SHEET("ENTRY").RANGE("C10:C300) Then the unique data add TO both Name Range."Names" and Names2.

    for example

    if I add data 'sid' in c10 then
    it look first in range("names"), if 'sid' avalable then do nothing, then look in second range("names2") if 'sid' available then do nothing,
    if not available in range("names") then add 'sid'
    if not available in range("names2") then add 'sid'


    if available in range("names2") and not available not in range("names") then
    only add to range("names").
    Attached Files Attached Files
    Use Code-Tags for showing your code :
    Please mark your question Solved if there has been offered a solution that works fine for you
    If You like solutions provided by anyone, feel free to add reputation using STAR *

  2. #2
    Forum Expert nilem's Avatar
    Join Date
    10-22-2011
    Location
    Ufa, Russia
    MS-Off Ver
    2013
    Posts
    3,377

    Re: Add unique data to 2 separate name.range using vba

    Hi HaroonSid,
    maybe so (in 'ENTRY' worksheet module)
    Please Login or Register  to view this content.

  3. #3
    Forum Contributor HaroonSid's Avatar
    Join Date
    02-28-2014
    Location
    india
    MS-Off Ver
    Excel 2013
    Posts
    2,078

    Re: Add unique data to 2 separate name.range using vba

    Thanx for reply nilem

    if i use range instead of names range

    like
    NAMES= c10:c500

    NAMES2 = b10:b500

  4. #4
    Forum Expert
    Join Date
    02-14-2009
    Location
    .
    MS-Off Ver
    ................
    Posts
    2,840

    Re: Add unique data to 2 separate name.range using vba


  5. #5
    Forum Expert nilem's Avatar
    Join Date
    10-22-2011
    Location
    Ufa, Russia
    MS-Off Ver
    2013
    Posts
    3,377

    Re: Add unique data to 2 separate name.range using vba

    Quote Originally Posted by HaroonSid View Post
    ...if i use range instead of names range
    try so
    Please Login or Register  to view this content.

  6. #6
    Forum Contributor HaroonSid's Avatar
    Join Date
    02-28-2014
    Location
    india
    MS-Off Ver
    Excel 2013
    Posts
    2,078

    Re: Add unique data to 2 separate name.range using vba

    Thanx nilem

+ 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: 0
    Last Post: 08-11-2014, 12:52 PM
  2. [SOLVED] Want to separate unique and duplicate data from large data base
    By sambha in forum Excel Programming / VBA / Macros
    Replies: 39
    Last Post: 08-02-2014, 12:30 AM
  3. Replies: 0
    Last Post: 09-06-2013, 12:18 AM
  4. Dynamic Range Graph with data in separate file?
    By gapollo in forum Excel Charting & Pivots
    Replies: 5
    Last Post: 07-29-2013, 09:44 AM
  5. [SOLVED] Counting unique values from data on TWO separate excel tabs
    By rshukla in forum Excel General
    Replies: 2
    Last Post: 05-06-2013, 02:08 AM
  6. [SOLVED] Counting unique values from data on TWO separate excel tabs
    By rshukla in forum Excel Formulas & Functions
    Replies: 4
    Last Post: 05-05-2013, 05:22 PM
  7. [SOLVED] Separate Variable Range of Data into Different Worksheets
    By equity7252 in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 11-23-2005, 02:10 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