Hello all,
I just took a few intro classes for Excel and am seeing if I can build better spreadsheets than what we are currently using at work. I have lots of great ideas but am getting frustrated that I cannot get the functions to work, or I am not sure exactly how to use the formula.
Question #1:
How do you get the SUM of a specific range of cells that could change? By that I mean I will start adding at cell C8, and could need to add to cell C10, or C21. It changes daily.
Question #2:
This goes along with question 1, but how can I add cells with specific text? I created a drop down menu with two options. I want to create a function that searches a dynamic range of cells for the words "Standard" or "Urgent" from the cell with the drop down menu.
I am working on creating a workbook with worksheets that represent each month. Within each worksheet I am working on creating daily sections. We never know how many events we will handle each day.
This leads me to Question #3:
Is there any way to add a new row with only a selected amount of cells? Either with a macro or any other trick. My idea is once we need to update the daily section with a new event, I can just run a macro do drop in a new row below the previous event we recorded. I do not want to create daily sections with a given amount of rows, because we may need way more, or way less than any amount I would pre-populate the worksheet with. I would like to add only what we need at that time for organizational and appearance purposes.
Any input would be greatly appreciated!!
Thanks a lot!
I also used the "=Count" function, to find how many emails we dealt with on that specific day, based on the time we received the email. Can that be used for a dynamic amount of cells as well?
I just took a few intro classes for Excel and am seeing if I can build better spreadsheets than what we are currently using at work. I have lots of great ideas but am getting frustrated that I cannot get the functions to work, or I am not sure exactly how to use the formula.
Question #1:
How do you get the SUM of a specific range of cells that could change? By that I mean I will start adding at cell C8, and could need to add to cell C10, or C21. It changes daily.
Question #2:
This goes along with question 1, but how can I add cells with specific text? I created a drop down menu with two options. I want to create a function that searches a dynamic range of cells for the words "Standard" or "Urgent" from the cell with the drop down menu.
I am working on creating a workbook with worksheets that represent each month. Within each worksheet I am working on creating daily sections. We never know how many events we will handle each day.
This leads me to Question #3:
Is there any way to add a new row with only a selected amount of cells? Either with a macro or any other trick. My idea is once we need to update the daily section with a new event, I can just run a macro do drop in a new row below the previous event we recorded. I do not want to create daily sections with a given amount of rows, because we may need way more, or way less than any amount I would pre-populate the worksheet with. I would like to add only what we need at that time for organizational and appearance purposes.
Any input would be greatly appreciated!!
Thanks a lot!
I also used the "=Count" function, to find how many emails we dealt with on that specific day, based on the time we received the email. Can that be used for a dynamic amount of cells as well?
