teach

I have 4 categories Group, Mental, FC, FM. If I select Group or Mental I need in the first cell to put "90" and if it is FC or FM I need it to enter 180. I will then have that hidden as my calculation for the number of days until the next meeting. For example my first meeting was 01/01/2019...

Dear all, I would like to fix the operation range from A1 to K20, prevent operator to disturb other range setting & data, please help to teach how to fix it & back to normal status. Thanks for help. Cannny

I have asked on another thread here if something like this was possible... it was proven possible with a Macro but it was written for me. I would like to learn how to do this for myself, but haven't found any online tutorials that would teach me the in's and out's of Macro; just a general "type...

thank you for looking at this post! i am very new to excel, i didnt even know some things were possible that i have read here. i am looking for guidance i get data in a spread sheet and make it easy to understand for others. this how i receive the data...

Pls teach me how this formula works.. DateValue and TimeValue

Hi everyone Im almost a newbie On Sheet1, I have a list of names in column A1 : A100. I would like to put these names into an array and on Sheet2, populate a grid at A1. I also need a message box to pop up to query the dimensions before populating the grid (5x5, 8x10, 8x12, etc) Im trying...

Hi I am not a new user to Excel and would say that my knowledge of formulas is pretty advanced. I want to move onto macros and some VBA stuff and feel that a book or guide would be the best way for me to learn. Biggest problem with that is that there are so many to chose from on so many...

Hello Advanced Excel and VBA community, Separate from the typical questions seeking help on this form, I am seeking input. I'm starting up a volunteer program (3 trial sessions) to teach Advanced Excel and VBA. These session will be around 90 minutes and with private high school students apt to...