Hi
I have a sheet that is extracted from an application. Column 1 of the extracted sheet has "F numbers". I need code that can copy all the same "F numbers" and the entire row of said "F numbers" to certain blocks in my master sheet.
For instance, there is 6 instances of F4I in the extracted sheet, so I need all those rows to be copied to the first block in my master sheet and there is 3 F4D's which then needs to copy to the second block in my master sheet and so on....
I need this to work as a add - in where when the user has extracted the data sheet from the application and then press a add-in button it populates the master sheet.
The "F numbers" will differ each time that I extract the data to excel sheet from my application. The extracted sheet will have a different name each time as the application where it is extracted automatically names it with the area prefix and the current date.
The blocks that I refer to above in the master sheet is : block1 = A2:O21 block2 = A23:O42 and so on...
Bookmarks