+ Reply to Thread
Results 1 to 3 of 3

Move values from multiple rows in one row in different cells

  1. #1
    Registered User
    Join Date
    01-18-2018
    Location
    Sofia, Bulgaria
    MS-Off Ver
    2010
    Posts
    1

    Move values from multiple rows in one row in different cells

    Hi all,
    I hope you can help me solve a case.
    I need vba that can automatically move values from multiple rows in one row and different cells.
    What i have is column A1,A2,A3 - Same company name (can be different number of rows) and in column B different info for that company on each row.
    At the end I need only one row with Column A2 = Company, Column B2,C2,D2 ... filled in with the data originally in column B (each value from column B in separate cell on the same row)

    I hope I explained it well enough If not I attached an example of the file

    Thank you
    Attached Files Attached Files

  2. #2
    Forum Expert nilem's Avatar
    Join Date
    10-22-2011
    Location
    Ufa, Russia
    MS-Off Ver
    2013
    Posts
    3,376

    Re: Move values from multiple rows in one row in different cells

    Hi Litha,
    try this
    Please Login or Register  to view this content.

  3. #3
    Forum Expert leelnich's Avatar
    Join Date
    03-20-2017
    Location
    Delaware, USA
    MS-Off Ver
    '97, 2016
    Posts
    2,523

    Re: Move values from multiple rows in one row in different cells

    Perhaps:
    Please Login or Register  to view this content.
    Last edited by leelnich; 02-27-2018 at 01:18 PM.
    Clicking the Add Reputation star below any helpful posts is a great way to show your appreciation.
    Please mark your threads as SOLVED upon conclusion. (Thread Tools above Post # 1) Thanks!-Lee

+ 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. [SOLVED] VBA Change Event, Move multiple rows based on drop down selection for multiple criteria
    By Webbers in forum Excel Programming / VBA / Macros
    Replies: 7
    Last Post: 02-02-2017, 11:51 AM
  2. Replies: 0
    Last Post: 05-26-2016, 05:54 AM
  3. Splitting Cells with multiple values into separate rows
    By dracon6 in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 06-19-2014, 12:53 AM
  4. [SOLVED] Macros To Move Multiple Rows To Another Sheet And Macro To Move Single Rows To DAX Table
    By jcaynes in forum Excel Programming / VBA / Macros
    Replies: 6
    Last Post: 10-22-2013, 05:08 PM
  5. [SOLVED] Sort / change multiple non-contiguous rows (cells values)
    By jaff84 in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 05-04-2012, 10:53 AM
  6. Comparing values in two rows, and move identical rows
    By newyorknix in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 08-01-2011, 12:14 AM
  7. have reference cells move in rows while I move in columns
    By gryffin13 in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 07-13-2011, 09:33 AM

Tags for this Thread

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