VBA Code to Search, Copy, Paste select columns
Posted on 2011-10-19
I have a drop down list value (Column is in Sheet1) and based on the selected value in the drop down list it will search for the value in column in Sheet1 and it will copy and past the select columns (C, D, F, J) to a new sheet starting at row (B4). The drop down list value will go through all of the rows in Sheet1 to copy and past all that matchs the value from the drop down list and past all rows in the Sheet2.
Now another person comes along and selects a new drop down list value and that process will occure for that value, however, the previous rows that were pasted should be removed.
Any way to rememer the Number of rows that were pasted on Sheet2 in last search and clear them in the next search.
I need help on creating a vba code for all of the above. I have starting point but need expert help or if you have a code which does something similar.