VBA copy and paste based on parameters
Budget: $30 – $250 USD
I am looking for a VBA macro to be created that is able to do the following:
Loop through the spreadsheet
for each account number in row G
If the value in column J = 2 copy and paste the entire row to the output spreadsheet to the next available row
For example, the first loop would copy row 2 from my spreadsheet to the output tab, then row 3, then row 56. would then repeat for rows 4, 5, 6 and 57.
Please let me know if you believe that you can solve this for me - this may be the beginning of several jobs similar to this.
Loop through the spreadsheet
for each account number in row G
If the value in column J = 2 copy and paste the entire row to the output spreadsheet to the next available row
For example, the first loop would copy row 2 from my spreadsheet to the output tab, then row 3, then row 56. would then repeat for rows 4, 5, 6 and 57.
Please let me know if you believe that you can solve this for me - this may be the beginning of several jobs similar to this.