PaulaGon
02-01-2017, 07:12 AM
Hi, I am new to VBA and would appreciate some help with a problem I am trying to solve.
I would like to create a macro that is able to copy information from a row, base in a condition ,and then paste the entire row into the botton of the table (in the same worksheet).I have a table with 11 columns (A:K) with headings in two rows so will start checking data in row 3. I need the macro to check the column B, if in this column the value is “3100-01”, I'd like to copy the entire row and paste it into the last row of the table. (Duplicates the row in the table)Is that possible? Any suggestions would be greatly appreciated1
I would like to create a macro that is able to copy information from a row, base in a condition ,and then paste the entire row into the botton of the table (in the same worksheet).I have a table with 11 columns (A:K) with headings in two rows so will start checking data in row 3. I need the macro to check the column B, if in this column the value is “3100-01”, I'd like to copy the entire row and paste it into the last row of the table. (Duplicates the row in the table)Is that possible? Any suggestions would be greatly appreciated1