Avatar of satmisha
satmisha
Flag 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.
Microsoft Excel

Avatar of undefined
Last Comment
satmisha

8/22/2022 - Mon
ASKER CERTIFIED SOLUTION
Joe Howard

Log in or sign up to see answer
Become an EE member today7-DAY FREE TRIAL
Members can start a 7-Day Free trial then enjoy unlimited access to the platform
Sign up - Free for 7 days
or
Learn why we charge membership fees
We get it - no one likes a content blocker. Take one extra minute and find out why we block content.
Not exactly the question you had in mind?
Sign up for an EE membership and get your own personalized solution. With an EE membership, you can ask unlimited troubleshooting, research, or opinion questions.
ask a question
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.
Joe Howard

That doesn't look like part of the original question. Please ask a new question.
satmisha

ASKER
THnks.. It does work
Your help has saved me hundreds of hours of internet surfing.
fblack61