VBA Clean up and Improvements Hi all,

Currently developing an excel document and one of the things requested was to make the document feel more like an "app"
I have managed to fumble my way around this concept by sourcing various bits of VBA code from around the internet after various searches and edited to suit my needs.
...
https://www.excelforum.com/sho....wthread.php?t=142458

Different rows sum up depending on a dropdown menu Hello, I have the following problem, I want to insert a formula in my Excel table that makes sure that the totals of different rows are added together if a special category has been selected in the column before the amounts via the dropdown menu. So in my example all values of the rows which have...
https://www.excelforum.com/sho....wthread.php?t=142458

Filtering Data from a Vlookup formula working on one spreadsheet, but not another I am working on a new spreadsheet which I have set up to extract data from certain cells on one tab and pull it into another to condense that data into a list that omits blanks. Once the data is condensed properly, I would like it to pull over into another section (currently via Vlookup) that can...
https://www.excelforum.com/sho....wthread.php?t=142458

What's causing the fault in a =LET formula?? Hello,

I am using a rather long formula to look up values from multiple columns (in the sheet named Working_Rota) and then return them, minus any blanks, into a separate sheet and in one single column. Everything seems to work fine until it gets to one particular column range and there is no...
https://www.excelforum.com/sho....wthread.php?t=142458

Hello and Glad to be here Hello all from Fort Worth, TX. A quick introduction, I am Rene' and I am the Controller at one of the museums in Fort Worth and i use excel on the daily. Been in accounting for over 25 years and have a pretty good grasp of a good amount of excel. But I want to learn more about some of the more...
https://www.excelforum.com/sho....wthread.php?t=142459