Last seen: Mar 5, 2025
Hi Tom! I believe what you are asking is answered by tying your VBA in a worksheet change event. This post should help. Hope that's what your looki...
Or, to keep the format that obviously works with the one minor hiccup, do the loop until it comes across an empty string? Sub Draw() Dim i As Inte...
I am just learning, but my theory, and mind you it is only a theory, is this: You are using a DO Loop until the number is nothing, well, you've hid...
A simple 'If' statement will work perfectly here for your purposes. Insert the following formula in your 'Total % pistol exercises' column: =IF(OR(...
Such an easy solution, it was staring me in the face! Thank you so much!
I believe it is this part in red: Workbooks.Open ("ThisWorkbook.Path & " "abc.xlsx"). You would need to change it to Workbooks.Open (Thi...
Hi Andy! I have your formulas in cells I5:J13, please note that these are array formulas so you will need to enter them with ctrl+shift+enter in or...
If is one of the most useful functions in excel, you can learn more about it here.
I'm confused as to what you are looking for, then? You don't want the average of the positives and the average of the negatives? What are you looking ...
I used the Sumproduct function to get the answer you are looking for. See the attached file, hope it helps! 🙂
Hi David, welcome! It took me a minute but I have an idea for you! In my idea you will need 2 helper cells, but if you use the choose function y...
Hi Priyanka, You can basically copy cells using a formula, this is a new one I found a couple of months ago for a project of mine. You may want to ...
Hi Charles! So I took your data and in the "Completed" tab I added a new column for Month Completed, using helper data on the same sheet with your ...
Hi Charles, We have similar cut off dates at work, I have a spreadsheet where I set the months and their cut-off in a table and used an array formu...