Hello Kings of excel
i have 4 sheets each sheet has a Filters with data i want to combine this sheets in one Worksheet so i can control & modified them easy without getting to them
Exemple like in the picture
M2DFSVV.png
Hello Kings of excel
i have 4 sheets each sheet has a Filters with data i want to combine this sheets in one Worksheet so i can control & modified them easy without getting to them
Exemple like in the picture
M2DFSVV.png
OK so what is your question...how to get all data onto 1 sheet?
1. Use code tags for VBA. [code] Your Code [/code] (or use the # button)
2. If your question is resolved, mark it SOLVED using the thread tools
3. Click on the star if you think someone helped you
Regards
Ford
yes plz
As you have the 2016 version of Excel, perhaps you could use Power Query (Get & Transform) to do what you want. If not it may help if you could upload a sample of a couple of the spreadsheets that you want to combine.
To upload a sample workbook (not a picture or pasted copy) click on the GO ADVANCED button below the Quick Reply window and then scroll down to Manage Attachments to open the upload window.
Let us know if you have any questions.
Consider taking the time to add to the reputation of everybody that has taken the time to respond to your query.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks