PDA

View Full Version : Macro to copy specific data from sheet A to sheet B



prasant1990
04-12-2016, 07:01 PM
I have two worksheets. Worksheet A is the master sheet which has a lot of records (assume 900) I now need to change a few fields for about 20 records. Worksheet B will have those 20 records and the fields that are changing for them I am interested in a macro that will automatically change the fields for these 20 records in worksheet A. All the remaining 875 records in worksheet A should not be touched and should retain their values as is.
Column A in Worksheet B is the Record name. Column B, C, D, E and F include the fields that may or may not change for these records. So basically every record is a row entry.
Also after the macro is done with the changing the fields for the records I need it to put a filter on all the records it changed. That way I can do a quick review.