Recent content by RPAPJ

  1. R

    collection

    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.
  2. R

    Copy Data from Sheet1 to Sheet2 on condition

    I found the answer on Web. It will be "Address='India AND Gender = 'Male'". I was giving "" in wrong place. thanks again.
  3. R

    Copy Data from Sheet1 to Sheet2 on condition

    Another small doubt - can we have multiple conditions in VBO 'Utility - Collection Manipulation' - 'Filter Collection' like "Address='INDIA"AND"Gender='Male'"?
  4. R

    Copy Data from Sheet1 to Sheet2 on condition

    Thank you so much VJR. It is working now. your help is much appreciated.
  5. R

    Copy Data from Sheet1 to Sheet2 on condition

    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...
Top