IgnBan
02-21-2008, 10:26 AM
Need some help generating some named ranges with the OFFSET function. I have a data table that needs to define names. I need to define the OFFSET ranges A4:A500, B4:B500, C4:C500, D, and E. What I need is to make a dynamic chart and use these defined ranges names to make the chart dynamic.
I attached a sample work book.
Any input is in advance appreciated
I attached a sample work book.
Any input is in advance appreciated