Hi
I know it is possible to create dropdown lists in 1 sheet with data from another sheet, but what I want to try and do is to have calculations performed and results shown based on what is selected in those columns.
Here is an example, X3: X122908 of the original workbook is a column of profit and loss for a year; that column can also be used as a count of how many selections there were for the year, 122906 when unfiltered, due to the top 2 rows being used by headers.
What I'd like to do is to add data from some of the columns in this workbook to another sheet so that when something is selected in the new location, the profit and count cells both change to reflect it. This works natively in the current workbook when I filter for certain criteria, but would dearly love to be able to link the dropdown lists to the original data.
So if an option is selected in a dropdown list, it would act as if that column had been filtered in the original document. Does that make sense at all?
There would be 10 dropdown lists, each representing a column from the original worksheet and 2 cells where the results would appear; 1 cell to display profit and the other the count.
I don't think it is such an issue to create the dropdown lists, but how to have the results change in the Profit and Count cells? Basically it is exactly what you see when you are filtering in Excel and you select a column; you get Average, Count & Sum. I want the results for Count & Sum to work just as it does in the status bar when filtering.
Is this possible at all and if so, how would it be done?
Thanks for any help you might be able to give
I know it is possible to create dropdown lists in 1 sheet with data from another sheet, but what I want to try and do is to have calculations performed and results shown based on what is selected in those columns.
Here is an example, X3: X122908 of the original workbook is a column of profit and loss for a year; that column can also be used as a count of how many selections there were for the year, 122906 when unfiltered, due to the top 2 rows being used by headers.
What I'd like to do is to add data from some of the columns in this workbook to another sheet so that when something is selected in the new location, the profit and count cells both change to reflect it. This works natively in the current workbook when I filter for certain criteria, but would dearly love to be able to link the dropdown lists to the original data.
So if an option is selected in a dropdown list, it would act as if that column had been filtered in the original document. Does that make sense at all?
There would be 10 dropdown lists, each representing a column from the original worksheet and 2 cells where the results would appear; 1 cell to display profit and the other the count.
I don't think it is such an issue to create the dropdown lists, but how to have the results change in the Profit and Count cells? Basically it is exactly what you see when you are filtering in Excel and you select a column; you get Average, Count & Sum. I want the results for Count & Sum to work just as it does in the status bar when filtering.
Is this possible at all and if so, how would it be done?
Thanks for any help you might be able to give