+ Reply to Thread
Results 1 to 7 of 7

sequence to copy from cell based on column A

  1. #1
    Forum Contributor
    Join Date
    09-19-2007
    Posts
    190

    sequence to copy from cell based on column A

    Dear All,

    I got a big data file contains Vehicle number (colmn A) , Start Destination (colmn B blank) and End destination (colmn c)

    i need to create a formula in B just to copy value which is in C, i know it is b3=c2 but

    i want same sequence to go down along unless when value in A changes and a new vehicle number starts
    then the formula should repeat again and so on, as in file b13=c12
    please see attached file and i hope it is made clear

    thank you for your usual help
    Attached Files Attached Files
    Evil is the root of all Mon$y

  2. #2
    Forum Moderator Richard Buttrey's Avatar
    Join Date
    01-14-2008
    Location
    Stockton Heath, Cheshire, UK
    MS-Off Ver
    Office 365, Excel for Windows 2010 & Excel for Mac
    Posts
    27,951

    Re: sequence to copy from cell based on column A

    Hi,

    Are there always 10 rows in each 'block' of cars?
    Richard Buttrey

    If any of the responses have helped then please consider rating them by clicking the small star icon below the post.

  3. #3
    Forum Guru sktneer's Avatar
    Join Date
    04-30-2011
    Location
    Kanpur, India
    MS-Off Ver
    Office 365 ProPlus
    Posts
    9,581

    Re: sequence to copy from cell based on column A

    May be this......

    In B3
    Please Login or Register  to view this content.
    and copy down.
    Regards
    sktneer


    Treat people the way you want to be treated. Talk to people the way you want to be talked to.
    Respect is earned NOT given.

  4. #4
    Forum Moderator Richard Buttrey's Avatar
    Join Date
    01-14-2008
    Location
    Stockton Heath, Cheshire, UK
    MS-Off Ver
    Office 365, Excel for Windows 2010 & Excel for Mac
    Posts
    27,951

    Re: sequence to copy from cell based on column A

    In C2 copied down (assumes 10 entries per block)

    Formula: copy to clipboard
    Please Login or Register  to view this content.

  5. #5
    Forum Contributor
    Join Date
    09-19-2007
    Posts
    190

    Re: sequence to copy from cell based on column A

    gents,
    thanks for the info however it is not ten blocks it may be more or less

    cheers

  6. #6
    Forum Guru sktneer's Avatar
    Join Date
    04-30-2011
    Location
    Kanpur, India
    MS-Off Ver
    Office 365 ProPlus
    Posts
    9,581

    Re: sequence to copy from cell based on column A

    Thanks for the rep.
    Should I assume now that your issue has been resolved?
    If so please mark your thread as Solved by selecting Thread Tools (just above your first post) --> Mark thread as solved.

  7. #7
    Forum Contributor
    Join Date
    09-19-2007
    Posts
    190

    Re: sequence to copy from cell based on column A

    works great


    thanks all

+ 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. auto- sequence number based on another column?
    By maynard in forum Excel General
    Replies: 6
    Last Post: 07-29-2016, 10:31 PM
  2. [SOLVED] Copy active cells from one column as a sequence in another cell
    By adihad in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 05-21-2013, 03:59 AM
  3. Replies: 2
    Last Post: 05-19-2013, 03:59 AM
  4. Sorting based on a particular column to determine a logical sequence
    By vijaye in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 03-20-2013, 06:50 AM
  5. [SOLVED] Creating a sequence based on numbers in one column and adding "01,02..." to a new sequence
    By JCR1968 in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 01-05-2013, 08:06 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