HI ,
I have a a file with a Source SG sheet , Target SG Base and the Header names in source and Target sheet for same .
Now i need a code that can do the same as above , but From my source sheet , after running header change module it will have to filter on status col , If Piepline is the status then paste teh required cols into Target_Oppty Sheet and if status is unqualified paste it inot Target UQP sheet.
I already have some code for doing this header change and copying the specific headers to paste (on my Source SG and Target SG base Sheet )
Modules for header change are Copyopptypipe, CopyUQP , Copypipe and matchingSGBAse is for running the Specifi cols copied intot the Target sheet.
Kindly help to loop the same with a filter into Oppty Target sheet and UQP Target sheet.
Attached my file here .
I am not very good with looping codes , hence any help is much appreciated .
Thank you