Hi, I have some probblems to generate a working formula like sum(sumif....)
I need to read all the resources codes of a dept form sheet department an put a formula in sheet Totals by type via VBA code
This because resources in department may change (add or delete resources)
If i have one resource only in a despt i create a sumif formula and work
If there are more than one resource i need to put a formula like sum(sumifs...) and put array into the criteria
I have created a static version and it work but when i try to automate the formula creation with VBA don't work!
Can anyone help me?
Thanks in advance
P.S. Sorry for my very bad english
Bookmarks