Multiple lookup values and adding multiple rates across togeth
Okay, I think I figured out what you want to do. To do this the easy way
would be to create an array. The first element would be the concatenation of
Employee & Dept. so that you create a unique "Employee" based on each
combination. Then you would read all that the forecast data into an array,
then add the actual data to the array, and then write out the report. In my
opinion, this would be way easier in the long run to set up and maintain.
When I have a bit more time, I'll work on designing this and send to you.
|