LinkBack URL
About LinkBacks
hi all
I have data in all sheets except summary so I put the result in sheet summary how the data should be based on selected cell in d1
I put more explanation inside the file if it's not clear please let me know
hi all
I have data in all sheets except summary so I put the result in sheet summary how the data should be based on selected cell in d1
I put more explanation inside the file if it's not clear please let me know
Last edited by ABDELFATTA; 02-24-2021 at 09:47 AM.
You can use a custom UDF.
The formula in B5 would be
Formula:
Please Login or Register to view this content.
notice the relevant and absolute references in the formula.
2021-02-24_8-13-51.jpg
Please Login or Register to view this content.
Vlookup would work just fine as well, but you would have to hardcode each sheet range or find a way to use indirect for the sheet names
thanks daves but I prefer by code I know this is not easy i hope somebody see my post
any helps, experts?
Hi ABDELFATTA,
Try below code ...
Please Login or Register to view this content.
If I was able to help, you can thank me by clicking the * Add Reputation under my user name
@nankw83 the code is perfect but there still thing missed so when clear d1 should bring all the data and if i select another item should copy to the bottom not replace the old data have already searched
If cell D1 is cleared you want to bring all data ? And if you filter D1 again it will add the filtered data at the bottom ? (which is already there) I don't see how that is beneficial for youLogically, it is either used as filter like my previous code or all at once but can't understand how merging both options do any good for you
please check my file I put the expected result in sheet "result1" when d1 is empty what can happen and in sheet "result2" when I select every time
If cell D1 is cleared, should the macro delete all rows then bring everything back again or bring all data from the sheets & append under existing data in summary sheet ?
If cell D1 is cleared, should the macro delete all rows then bring everything back again
as for if select item in D1 every time then bring all data from the sheets & append under existing data in summary sheet
another way guys, please?
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Register To Reply
,
Bookmarks