Posts by DianeSloan

Thank you sir.

Adding the match function to the named ranges

Thanks for the speedy reply. For future reference, how would you add the match formula to the defined ranges? This where I ran into trouble previously. I am amazed you did this so quickly...if you only knew how long I have been working on it without successful results. Again, thank you so much.

I am at a loss as to how I can automate my spreadsheet to update the chart each time I enter new data. I've attached a portion of my workbook as an example. Ideally I would like to specify a start and end date.

I have tried offset and match functions but never have accurate results. I am at my wits end and deleted all the dynamic ranges I started. I need a fresh start with this project. Can anyone help me get on the right track? Thanks in advance for any advice or support you can offer.
Cheers!