Hi
I have a worksheet with a large amount of sales data based on delivery dates. I want to search the data based on the delivery month so it displays in another worksheet. I'm struggling to find the simplest/best solution. I want all the data in one row and is a mix of numbers and text so not Pivot. I thought Index/Match would work but my brain has now fried....
Any help or guidance would be much appreciated.
I've attached a small sample file to help show what I'm trying to do. Hope that's not too vague.
Many thanks in advance.
Mat
I have a worksheet with a large amount of sales data based on delivery dates. I want to search the data based on the delivery month so it displays in another worksheet. I'm struggling to find the simplest/best solution. I want all the data in one row and is a mix of numbers and text so not Pivot. I thought Index/Match would work but my brain has now fried....
Any help or guidance would be much appreciated.
I've attached a small sample file to help show what I'm trying to do. Hope that's not too vague.
Many thanks in advance.
Mat