Issue with pasting filtered data from excel

[poojagupta83]

I need to paste some filtered data from one sheet into another excel sheet. Sometimes, only the filtered data gets pasted. But at times, all the data gets pasted. I am getting inconsistent results. Also is there a limit on pasting filtered data. BOT is able to paste until 2399 rows only. If there is an object to paste filtered data only. Then it will be helpful.

[SouravSaha]

Hi @poojagupta83,

Which blue prism object and action are you using to paste the filtered data?

[poojagupta83]

I am using MS Excel VBO - Extended(Digital Exchange). 

Action - Copy & Paste worksheet range

[Nandhakumar]

Hi @poojagupta83 

Can youtell me on how you are trying to get the range for Copy and Paste action?

Thanks,

Nandha

[SouravSaha]

@poojagupta83, Your requirement is to get the filtered data only in a new sheet, right?