Hello,
I have no idea how to continue and need your help yet again. Was given the following task: The user enters data in a confusing table. The desired output is a table were the data for the current week is shown. An example is attached. I managed to implement three functions with VBA: GetCellColor(cell), wich returns a unique number per cell color, SumCellsByColor, and CountCellsByColor, which each get a range and a cell reference and sum or count the cells. I am sorry that I can't upload a .xlsm file, but that is forbidden in the environment I'm in - I will copy the code below. If somebody would be willing to help, he or she would have to copy the code into a module.
Until now, you would do the task like this: Check if date in current week is in confusing table -> if yes: check the row in which the date is-> check the column where Day 1 is written -> sum up all entrys of the respective colors.
Could you tell me if there is an easy way to do the task with excel formulas, or do I have to look into a more complicated VBA-Function? I would be extremely thankful!
The functions are:
Bookmarks