Link to home
Start Free TrialLog in
Avatar of satmisha
satmishaFlag for India

asked on

Copy Table from worksheet1 to worksheeet2 using Autofilters

Hi experts,
I want to copy table 'Table1'  from sheet1 to sheet2 when user clicks on button , with one condition i.e. only those rows where cell value is not blank.

Enclosing sample file fyr.
ASKER CERTIFIED SOLUTION
Avatar of Joe Howard
Joe Howard
Flag of United States of America image

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
Avatar of satmisha

ASKER

Thanks for your reply, Apologies for my late reply...

Would it be possible to copy autofiltered range to array ? As after filtering data I need to copy filtered rows to destination table at alternative rows... for example

if we have 5 filetered rows then I need to copy to destination table at row1, row3, row5, row7 and row9.

Looking forward to hearing from you.
That doesn't look like part of the original question. Please ask a new question.
THnks.. It does work