View Single Post
  #4   Report Post  
Posted to microsoft.public.excel.worksheet.functions
ssolomon via OfficeKB.com ssolomon via OfficeKB.com is offline
external usenet poster
 
Posts: 6
Default Multiple lookup values and adding multiple rates across togeth

Looking back at the message, your probably correct..way too long.

I'm going to have to start studying about array's as I'm new to this. I
appreciate the help!

Thanks,

Steve

Mike H. wrote:
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.


--
Message posted via OfficeKB.com
http://www.officekb.com/Uwe/Forums.a...tions/200711/1