+ Reply to Thread
Results 1 to 1 of 1

Inserting data from one sheet to another without copy pasting an inserting extra rows

  1. #1
    Registered User
    Join Date
    05-13-2014
    MS-Off Ver
    Excel 2003
    Posts
    1

    Inserting data from one sheet to another without copy pasting an inserting extra rows

    Hi I don't know if this could be done but it doesn't hurt to ask.

    I have 2 sheets of data. One sheet has a list of products. The other sheet has the correlating pictures for the products. Some have 2 pictures some have 5 pictures and so on. I want to move the pictures beside the product name in a new column. The pictures have part of the product name in it making it easy to know which product it goes to. It is just time consuming to count how many images there are an then insert the rows.

    Is there anyway this can be done? I am familiar with vba I just don't know how to write codes.

    Example:

    Sheet 1

    Shoes
    Dress
    Bottom
    Shirt

    Sheet 2

    Shoeimage1
    Shoeimage2
    Dressimage1
    Dressimage2
    Dressimage3

    I want it to look like:

    Column A
    Column B
    Shoes
    Shoesimage1
    Shoesimage2
    Dress
    Dressimage1
    Dressimage2
    Dressimage3

    Thank you in advance.
    Last edited by SeasonedRookie; 05-22-2014 at 10:51 PM.

+ 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. filter data and copy to another sheet by inserting rows
    By prabhuduraraj09 in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 04-08-2014, 02:24 AM
  2. Inserting rows between existing related data on another sheet
    By GDC in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 06-21-2013, 10:45 PM
  3. [SOLVED] Inserting multiple rows below an exisitng row and copying and pasting that data
    By S.R. in forum Excel Programming / VBA / Macros
    Replies: 6
    Last Post: 06-22-2012, 11:07 PM
  4. Inserting, Cutting, and Pasting Rows Based on What's in a Cell
    By 4EverLearning in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 08-05-2010, 04:42 PM
  5. Inserting extra code...
    By 5000XD in forum Excel General
    Replies: 4
    Last Post: 04-07-2009, 11:14 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