Hello, I have a workbook with a few sheets: All Forms, Form A, Form B, Form C, and Form D.
I want a macro that will search column C on the All Forms Sheet, and depending on the Value listed there, Copy the entire row to the relative Sheet.
So, if Row 1 on the All Forms Sheet has “Form B” in Column C, it will copy that entire row to the Form B sheet…if Row 2 says “Form A” in Column C, it will copy that entire Row to the Form A sheet.
I would like to create a button that runs the macro, so that when I click it, it will overwrite the existing rows on the various sheets-effectively updating those sheets with the most current info from the All Forms sheet (the “master sheet”) without creating duplicate entries every time I run the macro…
I want a macro that will search column C on the All Forms Sheet, and depending on the Value listed there, Copy the entire row to the relative Sheet.
So, if Row 1 on the All Forms Sheet has “Form B” in Column C, it will copy that entire row to the Form B sheet…if Row 2 says “Form A” in Column C, it will copy that entire Row to the Form A sheet.
I would like to create a button that runs the macro, so that when I click it, it will overwrite the existing rows on the various sheets-effectively updating those sheets with the most current info from the All Forms sheet (the “master sheet”) without creating duplicate entries every time I run the macro…