Results 1 to 11 of 11

Add unique value automatically to sheets("to.") and sheets("total")

Threaded View

HaroonSid Add unique value... 02-04-2017, 05:51 AM
bakerman2 Re: Add unique value... 02-04-2017, 07:01 AM
HaroonSid Re: Add unique value... 02-04-2017, 11:06 AM
daboho Re: Add unique value... 02-04-2017, 12:06 PM
Winon Re: Add unique value... 02-04-2017, 12:14 PM
bakerman2 Re: Add unique value... 02-04-2017, 08:27 PM
HaroonSid Re: Add unique value... 02-05-2017, 03:01 AM
bakerman2 Re: Add unique value... 02-05-2017, 03:22 AM
HaroonSid Re: Add unique value... 02-05-2017, 05:02 AM
HaroonSid Re: Add unique value... 02-05-2017, 05:01 AM
bakerman2 Re: Add unique value... 02-05-2017, 07:53 AM
  1. #1
    Forum Contributor HaroonSid's Avatar
    Join Date
    02-28-2014
    Location
    india
    MS-Off Ver
    Excel 2013
    Posts
    2,095

    Add unique value automatically to sheets("to.") and sheets("total")

    hi, everyone

    i have three worksheets on my workbook
    1 = "TO."
    2 = "ENTRY"
    3 = "TOTAL"

    I add data sheets("entry").range("c10:c300"). so when i add data here then automatically add same but unique to sheets("to.").range("b4:b100") and sheets("total").range("c4"c100")

    for example
    i add "haroon" in range sheets("entry").range("c10:c300")

    then "haroon" auto add to sheets("to.") and sheets("total") in range

    if "haroon" already added in sheets("to.") and sheets("total") then ignore it


    I Think this will done with worksheet_change event
    Private Sub Worksheet_Change(ByVal Target As Range)
    If Target.Cells.count > 1 Then Exit Sub
    If Target = "" Then Exit Sub
    If Not Intersect(Target, Range("C10:C500")) Is Nothing Then
    and code here....
    End Sub

    thanx a lot
    Attached Files Attached Files
    Last edited by HaroonSid; 02-04-2017 at 05:55 AM.
    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: 1
    Last Post: 03-09-2016, 12:17 PM
  2. Replies: 1
    Last Post: 06-06-2013, 06:28 PM
  3. Replies: 2
    Last Post: 06-06-2013, 12:45 PM
  4. [SOLVED] Need Macro to compile data from "Weekly" sheets and sum up into "Monthly" summary sheet
    By mo4391 in forum Excel Programming / VBA / Macros
    Replies: 5
    Last Post: 01-21-2013, 07:25 PM
  5. [SOLVED] Sheets("Sheet2").Range("AA1") = "Note"
    By dcburkejr in forum Excel Programming / VBA / Macros
    Replies: 5
    Last Post: 08-03-2012, 04:10 PM
  6. "The "sheets" method from the "_Global" object have failed."
    By mankit87 in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 10-08-2011, 08:53 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