Search results

Hi Narayan, Just added that, thanks! I sent this file to my coworkers to test out, and the data validation lists on the H.O. Entry and Branch Review tabs disappear. Did you have this issue when you opened the file? I'm not sure what would be causing it to occur. I can write a macro to...

I got everything to work, but there is one other item I would like to add. When the template is blank, before anyone enters anything, you see #REF errors in all fields on the Service Model Deliverable. Is there a way to modify my formula to show blank cells instead? Here is my updated file...

I don't understand how the formula structure should change when I fill it to the upper service levels. I got it work, and pasted formulas from the bottom left B39:B45, and it worked properly. I then pasted the formulas in rows D,F,H, and J, and they were all working properly. Then I save the...

I looked at this more, and I think that the named range for Service_Branch_Review needs to be modified. I want to refer to column A, not column B for the Service Name. Service_Branch_Review referring to =OFFSET('Branch Review'!$B$2,0,0,COUNTA('Branch Review'!$C:$C)-1) I modified the cell...

Hello Narayan and SirJB, Thanks so much for your help. This is very close to what I need for the Service Model Deliverable. I used named ranges and the shorter array formula...

Just got started working on this again. Am going to try the formula now and will post an update shortly. THANKS!

I'm sorry, it's a bit hard to explain. The Service Model Deliverable is populated at the top with Service Levels from that tab. The other portion of the sheet should be populated with the services selected by the branch on the branch review tab. The branch reviews the services we entered...

I am working on an automated worksheet that I have to complete by Monday. I don’t have enough time to figure this out on my own, so I am looking for some help. I am working with a multi-sheet workbook in Excel 2010. The file is posted here...