Results 1 to 5 of 5

Thread: Create a new sheet / workbook for all Unique values (Including Pictures / Images)

Threaded View

Previous Post Previous Post   Next Post Next Post
  1. #1

    Create a new sheet / workbook for all Unique values (Including Pictures / Images)

    Hi, there
    Would you please help to write VBA for copying all rows (Including Pictures / Images) with the same value in the column F (The Header - Vdr) of the range to a new workbooks. Hope that the macro can do for every unique value in this column. Also, hope that the sheet & file can be named after the Unique value. As a result, there will be 5 worksheets and/or workbooks with the name (AMG,LT,MY,RWT & XH)

    If possible, kindly use shapes.addpicture method for those pictures/images. Enclosed the attachment for your reviewing.
    Attached Files Attached Files
    Last edited by JOEYSCLEE; 01-27-2017 at 08:20 AM.

Tags for this Thread

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •