I have tried some vba code with no result.
I have a xls file with severla worksheets.
Manually I create a new worksheet and then manually I select the cells from one worksheet and copy paste in the new one.
The next below and just the same. copy the cells from other worksheet and paste in target.
So I combine all the worksheets in only one without problem.
I need a functional free utility for this.
Do you know anyone ?
Best Regards
Note : i am using excel 2010
Hi Exgrimidor,
You can do an Advanced Filter to get rows of data from one sheet to another if there is a common term in one of the columns.
If you had a newer version of Excel you might also be able to use Power Query to filter one sheets information to a subset of it to another sheet.
I'm not sure what you mean when you ask for a "functional free" utility. Look at the two above and keep asking to get a better answer than this.
Last edited by MarvinP; 02-09-2020 at 05:46 PM.
One test is worth a thousand opinions.
Click the * Add Reputation below to say thanks.
Thanks I will try.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks