Results 1 to 13 of 13

Add auto number and total when i change numbers

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 auto number and total when i change numbers

    hi,
    i am using worksheet change event to add data auto when i input data in range F10:F300

    I need here some changes

    i want when i enter data (only numbers ) in range f10:f300
    then
    in range d10:d300 genrate number auto 1 to ....99999
    in range h10:h300 genrate page number according to range f10:f300 1 to ....
    in range i10:i300 genrate sum of range of range F10 to.....


    sample added here for example

    Capture.JPG
    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: 4
    Last Post: 11-23-2016, 01:16 PM
  2. [SOLVED] Auto Find Numbers & Auto Replacing Another number
    By TLRam1 in forum Excel General
    Replies: 17
    Last Post: 08-12-2015, 03:38 PM
  3. [SOLVED] Auto Populate Serial Number From Total number
    By sanju2323 in forum Excel Formulas & Functions
    Replies: 10
    Last Post: 08-04-2015, 04:33 PM
  4. [SOLVED] Formula to Change Colors If Total Numbers Gain or Lose
    By NocSparta in forum Excel Formulas & Functions
    Replies: 14
    Last Post: 07-26-2015, 03:51 PM
  5. Replies: 4
    Last Post: 03-10-2015, 07:28 AM
  6. [SOLVED] Find missing numbers when total number known
    By JDI in forum Excel General
    Replies: 15
    Last Post: 11-04-2014, 05:12 PM
  7. [SOLVED] Count the total number of times several numbers appear on each row
    By dwontheweb in forum Excel Formulas & Functions
    Replies: 9
    Last Post: 11-28-2012, 12:11 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