Hi all
I have data in a spreadsheet similar to the below.
What I need to do is created a named dynamic range based on the current month which will contain all rows/columns within that range. Ideally I need it to create the range for the current month so I can then use this as the data source for a pivot table.Please Login or Register to view this content.
I believe it is something to do with index and match functions?
Any help appreciated.
Bookmarks