Results 1 to 10 of 10

create a range from two value macro

Threaded View

  1. #1
    Registered User
    Join Date
    06-09-2009
    Location
    CAlifornia
    MS-Off Ver
    Excel 2003
    Posts
    9

    create a range from two value macro

    Ok im trying to have excel create a rage of numbers from the given values in cells b1and b2. I would like to add 11 to b1 till the last digit is 6 then add 4 to only that number then continue to add 11 till the last digit is a 6 then add 4 again then back to adding 11 and so on till the value in b2 is reached I have attached my file for an example in addition to the below.

    When given the values of 60862620 and 60862922 once 60862686 is reached then 4 would need to be added then after that 11 would need to be added till another number ends with 6 then 4 is added. EXAMPLE:

    60862620 +11
    60862631 +11
    60862642 +11
    60862653 +11
    60862664 +11
    60862675 +11
    60862686 +4
    60862690 +11
    60862701 +11
    60862712 +11
    60862723 +11
    60862734 +11
    60862745 +11
    60862756 +4
    Attached Files Attached Files
    Last edited by skimura; 12-02-2010 at 12:15 PM.

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

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1