“My Excelchat expert helped me in less than 20 minutes, saving me what would have been 5 hours of work!”

How would I script VBA to make a msgbox pop up if a cell value is entered as negative after you hit "enter" on the keyboard?

Solved by C. D. in 27 mins

How would I script VBA to make a msgbox (vbYesNo) pop up if a cell value is entered as negative # after you hit "enter" on the keyboard?
If you choose "No", then nothing happens and it goes back to the worksheet.
If you choose "Yes", then another msgbox pops up with a statement. (vbOkOnly)

Solved by T. U. in 26 mins

I am having issues combining the "if" "and" "or" functions together in one formula. I need either or of two conditions to be true to result in the Tally field to yield the word "direct deposit". Clients can only direct deposit if the year is 2015... so that condition doesn't change...then either the use direct deposit field says "t" for true or the direct deposit field says "yes". people inputting the data used both fields. Any other should result in the words "no direct deposit" in the tally column. Please help.

Solved by T. Y. in 23 mins

excel formula to calculate if any in this column equal x then add the corresponding row value in column y together.

Solved by F. C. in 22 mins

excel formula to calculate if any values in column z equal x then add the values in corresponding row from column y together

Solved by E. E. in 19 mins

I am trying to create a formula that will take any date entered and subtract it from the current excel date to leave me with a number. Also to include if the date is past, i.e. If the date entered is 3 days past the current date it should show a negative 3.

Solved by C. H. in 16 mins

I am trying to automate a goalseek process but have no experience with VBA. I have tried a few potential approaches looking at online forums without success. Here is what I would like to do:
if CASHFLOW!B31 < 0, CHANGE FUNDING!B14 so that CASHFLOW!B31 = 0
if CHASFLOW!B31 > 0, do nothing.
Ideally this would run on its own. I would want to do the same thing for adjacent cells (i.e. CASHFLOW / FUNDING columns B to G).
Thanks!

Solved by M. A. in 18 mins

Cell F32 of your spreadsheet contains the formula =(B1*1.2-(AX25+B$6-$A$1)+99). If I copy that formula into cell Z60, what will the resulting formula in Z60 be?

Solved by K. D. in 16 mins

I used the excel frequency count to count column. No problem so far. However if I were to change A2 from 13 to 93, I would expect to count in d2 to go from 15 to 14 and the count in d4 to go from 2 to 3. But it doesn't.
Is this a bug or is the use of frequency completely static -- i.e. one you set it up you're stuck with the initial data? If so frequency is a pretty dumb feature.
By the way, I'm using excel 2000, as I've found the newer versions extremely slow.

Solved by T. L. in 14 mins

I have a macro enabled excel file I created for my company.
Essentially, it's a huge dump of all parts our company handles and
the plan for those parts (PFEP - Plan For Every Part).
I programmed 8 macro buttons that, when a part number cell is selected and
a button is pressed, it automatically parses all information for that part into a
hidden sheet containing a label template, then auto-prints that sheet and rehides it.
In our part list, there are multiples of part numbers
(for the purpose that we use that specific part at multiple locations - need different plans for them).
Right now it is set up so that when one of the duplicates is selected,
it only gives the location information for the first part it finds on the way down.
It would be really convenient (for those who didn't participate in creating this document)
if there was a way it could grab, word-wrap, and concatinate the locations for all duplicates listed into that one cell.
I have pictures of file and code for an example sub in vba, and a copy of file ready on hand
I could share for a reference for you. Thanks for your help! Basically where it says "1.2 CS" in the picture uploaded, it needs to list all locations. not just the one for in that row selected. I have more pictures. File size limit restricts uploading spreadsheet.

Solved by A. A. in 29 mins