Hello VikkiD,
Welcome to the Exceldemy Forum. Thank you for reaching out and posting your question. It appears that you want to capture a date from one column based on the highest numeric value in another column and place that date in a different worksheet. You mentioned that you attempted to...
Dear Drew7ster,
I created a sample dataset to illustrate your issue. I'll create a pie chart using this dataset to show the percentages of each product type produced by each producer. In order to do this, I've made a drop-down list in Cell F20 that will periodically get the value of each...