In my earlier query I was not able to explain properly in haste. Select accountname(memory variable) from output sheet A column search in inputsheet column A copy row C to G and paste in output sheet E to I. If accountname is not in input sheet Output sheet row E to I will be blank. Accountname in outputsheet has more rows than inputsheet , extra rows will be blank. Accountname in outputsheet has less rows than inputsheet , than less rows will be copied in outputsheet. Attach spreadsheet , worksheet named correct shows the result I want. If code is written in different way no problem. Thanks in advance for solving the issue.
Bookmarks