Results 1 to 7 of 7

How to write a Loop within a Loop?

Threaded View

  1. #1
    Registered User
    Join Date
    10-05-2012
    Location
    Huntington Beach, CA
    MS-Off Ver
    Excel 2007
    Posts
    14

    How to write a Loop within a Loop?

    - Loop within a loop
    o The Loop is supposed to perform the following tasks here below:
    1.)Copy Product ID number from Column A in “Sheet 1”, and then loop through “.jpg” files in column A in “Sheet 2”.
    Basically, the jpg files for a product ID in sheet 1 will be found in Column A of Sheet 2.
    2.)There may be several images or jpg files per product. If there are lets say 2 images for product ID# 641, then the values would be copied and then pasted into columns C and D of the same row as Product ID 641.
    3.)If a product has 6 pictures e.g. Product ID 830, the images would be pasted into columns C, D, E, F, G, and H of the same row as Product ID 830 (in this case row 6 of Sheet 1).
    I hope this makes sense. I know how to create a basic Loop, but I have no idea how to create a Loop within a Loop. I wanted to practice this skill and have been trying for some time, but I can’t get my code to work. Any help would be greatly appreciated.
    Thanks
    Attached Files Attached Files
    Last edited by kitcargray; 10-30-2012 at 04:05 PM.

Thread Information

Users Browsing this Thread

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

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