There are about 20 columns of data with the rows sorted by values as the macro progresses. The button in the top left corner starts the macro and is in A1 next row is column headers and there are several blank rows inserted into the sheet to place the items in various groups. Here's my problem
I have painted myself into a corner. When the macro was first created there were several Catalog# 6 in the source data (comes from different tabs). Because of the critera I have to use to sort the data into different catagories the last sort leaves the "6" at the top. My code below used to cut those 6's and insert them into the "Widget" section below. However there are now instances with customer data that contains no 6's so the code cuts rows 3 & 4 and places them into the "Widget" section of the sheet.
I need to change this to either ignore if there are no 6's under Catalog# or loop the cut and past the "6" and loop it? I'm going to defer to the experts please.
2019-07-24_9-47-40.jpg
Please Login or Register to view this content.
Bookmarks