+ Reply to Thread
Results 1 to 3 of 3

Copy and Paste data in column A number of times displayed in column B

  1. 10-15-2013, 04:23 PM #1
    anthony232
    anthony232 is offline
    Registered User
    Join Date
    10-15-2013
    Location
    Texas
    MS-Off Ver
    Excel 2007
    Posts
    2

    Exclamation Copy and Paste data in column A number of times displayed in column B

    Ok, I hope this is a macro question, and I know this is an easy one for most. I have some Excel experience, but by your standards, probably little to none...

    I have a workbook that has a part number in column A, and a number next to it in column B. I need whatever value is in column A copied and pasted in another worksheet the number of times listed in column B. So, it may look like this...

    Mark 5
    Brian 3
    Jess 2

    So, I want a new worksheet that looks like this....
    Mark
    Mark
    Mark
    Mark
    Mark
    Brian
    Brian
    Brian
    Jess
    Jess

    Please help...>Thanks a million! I know how to record macro's, but not write them
    Reply With QuoteRegister To Reply
  2. 10-15-2013, 04:27 PM #2
    mrice
    mrice is offline
    Forum Expert mrice's Avatar
    Join Date
    06-22-2004
    Location
    Surrey, England
    MS-Off Ver
    Excel 2013
    Posts
    4,967

    Re: Copy and Paste data in column A number of times displayed in column B

    Try this

    Please Login or Register  to view this content.
    I've assumed that you data is on Sheet1 and its going onto Sheet2.
    Martin
    Reply With QuoteRegister To Reply
  3. 10-15-2013, 05:13 PM #3
    anthony232
    anthony232 is offline
    Registered User
    Join Date
    10-15-2013
    Location
    Texas
    MS-Off Ver
    Excel 2007
    Posts
    2

    Solved! Re: Copy and Paste data in column A number of times displayed in column B

    Solved! Thanks a million!
    Reply With QuoteRegister To Reply
+ Reply to Thread
« Previous Thread | Next Thread »

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. Copy & Paste Column with Data in the next available column in the same worksheet
    By BruceBane73 in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 01-16-2013, 12:07 AM
  2. [SOLVED] Facing issue in copy/paste of excel data from o column to filtered cells of another column
    By meetvivek72 in forum Excel General
    Replies: 3
    Last Post: 08-28-2012, 10:09 AM
  3. VBA Code to copy data from last filled column and paste to the next available column.
    By Pavman2473 in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 04-09-2012, 09:07 PM
  4. Macro to copy and paste special values for column data and filter column data
    By ascottbag in forum Excel Programming / VBA / Macros
    Replies: 9
    Last Post: 03-10-2012, 02:15 PM
  5. Copy Data from Column and Paste to Next Blank Column on 2nd Sheet
    By adammark in forum Excel Programming / VBA / Macros
    Replies: 5
    Last Post: 04-19-2010, 11:15 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

Forum Rules


Search Engine Friendly URLs by vBSEO 3.6.0 RC 1