Results 1 to 6 of 6

Add unique data to 2 separate name.range using vba

Threaded View

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

    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 *

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. 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