Hello So I know you can use a VLOOKUP to do something similar but I am trying to use this to add on to another piece of code. I want to have a VBA code that will look for text in column "A$" on "sheet1" and if it finds text I want that cell to be move to column "B5" and below on sheet2. Here is the hardest part........ (for me) I want the information to be place one every 3rd row instead of every row because there is other information that will need to be entered on sheet 2. Where would I even start?
I have this code that will move info from sheet to sheet, but it will not do the "every 3rd row" portion that I need...... I have attached a spreadsheet to show what I am looking for.