Hi Experts,
I need your help on this. I just wanted the data in my sheet "result" to be dynamic in a way that the task list should change depending on the data validation in cell A1. please see attached file.
Hi Experts,
I need your help on this. I just wanted the data in my sheet "result" to be dynamic in a way that the task list should change depending on the data validation in cell A1. please see attached file.
In A6, etc:
NotePlease Login or Register to view this content.
1. the changed layout of the index sheet
2. I removed the word "team" from both sheets. Each cell which previously had team ... is custom formatted with "team " @ to make single word range names.
Last edited by protonLeah; 03-09-2017 at 02:49 AM.
Ben Van Johnson
hi protonleah,
Thank you so much! Can I ask one more thing? What if column B should also change together with column a?
I'm sorry I forgot to modify the addresses of the named ranges for the teams. For team Andrew it should be
and similar for the rest.Please Login or Register to view this content.
(If you mean column B on the results tab, I don't know what should be there)
Last edited by protonLeah; 03-09-2017 at 03:23 AM.
On the same file you attached, column B should also be changing together with column A. Please check on Index-UOM sheet.
You can't have two different ranges with the same name. For instance, on sheet INDEX, there is a column titled "Andrew". I named that column ANDREW for use in the formulas in column A on the results sheet. But you also have a column titled ANDREW in column B on the index-UOM sheet. So I created new named ranges such as AndrewUOM ...UOM, etc. on the index-uom sheet. Then in column B of results sheet the formula:
takes the team from the dropdown in A1, appends "UOM" to it for the corresponding named range. The problem is that the row counts for the ranges on index don't match those on index-uom.Please Login or Register to view this content.
hi protonleah,
That was perfect. I am trying to replicate what you did for the accounts as well, but I am not getting the result I wanted which is under "Index-Accounts. I've also created named ranges smilar with what you did with UOMs. The reason I am doing this is that each team has a different Task List, UOM and Accounts.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks