PDA

View Full Version : look for value then put them to the SampleSheet



Yjmmay34
05-19-2010, 07:47 AM
Hi. Please help. I want to write a macro inside the "CustomerSummary"sheet to go through every sheets which named "Fab2","Fab3","Fab3E","Fab5","Fab6","Fab7","Fab1", and only extract 4 customer's data among many data. these four customer's name are "Broadcom,Quacom,Mstar,STM". Every data sheet format are the same. I have already put the according columns in the CustomerSummary sheet(the columns are refer to the rest of the Fab sheet). the blank column no need to put data.
Thank you!