Search results

vletm, Thank you so much, currently am using the version you made in my work, am not gonna lie, it took hours to modify and use same VBA data that you did, for my actual file... The auto refreshing+filter thing was fantastic idea , it works like a charm, this is what i exactly want. Thanks...

OMG , this is absolutely great , this auto refresh thing is awesome! Thank you! For the total budget I can not modify it since you made it function, but I will explain how it works, I have one rule which is: I can give to each launched Business Idea alone (600€). So If you check my original...

Do you mean like vletm did it for me? the filter option ? Your first suggestion was absolutely great for me, what I did was I just hid the extra columns except "How much" that you added in "Names" Sheet, and that's it! now each department can work separately and with no problem. Though am...

Hello vletm, Thank you for your excellent suggestion, I think its great and easy... though I have one problem, you changed the total budget with AGGREGATE function, which should be a fixed number, I can't modify this number since i want it to calculate how much is left , and leftover from it as...

Could you please show me how to do it , or if possible, you do it in VBA for me? I would love to see that if its possible. As for your suggestion, I think it would make it more complex & non organized sheet since we will have names on 2 columns in same sheet plus i tried to copy name and paste...

Hello bosco_yip, Thank you for your reply, correct If am wrong , you added the "Adjusted Status List" to prevent "Lee Wikerson" to appear in "Accounting" sheet ? If so , i think you misunderstood my question , and am sorry If i wasn't clear. I will try to explain what i exactly want. I...

Thank you for your help, I think your suggestion is great, i haven't thought about it honestly... but the problem is that we have two different department working on this workbook , so i can't mix accounting department with the Information Dep. plus i have removed a lot of columns in "Names"...

Hello Hui, Please accept my apologies, i didn't read site rules, I completely understand what you mean, but cross posting doesn't always mean I will leave my thread on other forums when i find the answer, actually am planning to post the solution to every single forum that i have posted and...

Hello GraH - Guido , thank you for your reply. I made a sample of what am exactly working on, its actual workbook that am using in my work, but i modified it and removed the confidential data. The workbook is attached with this reply.. now the problem occurs in "Accounting" sheet when a...

Hello guys, So I have an Excel file containing two sheets: - `Teams` (which contains details of teams and time schedule of their matches) - `Results` (contains calculation and number of matches and results, etc). What`Results`does is that each game that has launched status on `Teams` it...