Hello VBA Gurus,
I have this script that will grab the value of a selected cell in column 1 of sheet 2, find the value in a cell of column 1 of sheet 1, then copy that specific row from sheet 1 to sheet 2 in a row inserted beneath the selected cell in column 1 of sheet 2... it will do the same for all subsequent cells in column 1 of sheet 2 until it reaches an empty value.
The problem I have is that there are some rows with different values that have the same searched cell value... I have been trying to figure out how to modify the code so that it will copy subsequent rows with the same cell value (some cell values have a single row of values, while others may have more..). I have not been successful, and unfortunately only the first row of values is returned for all subsequent cells with the same value -- the same row is copied multiple times instead of all the various rows that have the same cell value in subsequent rows). I would like them to be copied maintaining the original order for a given cell value -- though overall cell values are ordered differently between the two sheets (which is the point of the script -- to order the rows from sheet 1's cell value order (with the original order of rows in a block of rows with the same cell value).
Did I explain that clearly? Here is what I have so far... any help to incorporate the described features would be greatly appreciated.
Thanks in advance.
Bookmarks