if you want to paste only from A1:A8 when you have data from A1:A20, why don't you just give range in source as A1:A8 so only those values will be pasted. Not sure if this is helpful to you but putting my thought here.
Another small doubt - can we have multiple conditions in VBO 'Utility - Collection Manipulation' - 'Filter Collection' like "Address='INDIA"AND"Gender='Male'"?
Hi,
I want to build a process where data of sheet1 will be copied to sheet2 on certain condition (where address is "India") using MS EXCEL VBO. Currently it is coping entire data. Please find attached the process and properties of stages i have used. Kindly advise what I am doing wrong. Your...
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.