Using form buttons to change source data for a chart

[richanor]

Hi guys

I would be really grateful if anyone could help / point me in the right direction with this query:

I have a radar (spider) chart for which the source data is in A2:J2, and the column headings are in B1:J1. The data is filled into these cells using a series of VLOOKUPS using the contents of A1 as the lookup value e.g. =VLOOKUP($A$1, Database!$A$3:$AY$100, 4, FALSE).

In the Database sheet, the first column A3:A100 (currently) consists of the record number 1-97

What I would like to do is to add two buttons to the sheet (previous & next), so that when they are clicked, the record number in Front!$A$1, increases or decreases by one but staying within the range of values (i.e. if there are only 50 records, I don't want it to keep advancing beyond 50). The record number in cell Front!$A$1 will then drive the VLOOKUPS, which in turn will feed the Radar Chart.

I know I could achieve something like this using a pivot chart, but I also want to use the values that the VLOOKUPS are pulling through for other things too.

If anyone can help me out with this code, or point me to any resources, I would be really thankful

Cheers

Rich

 

[richanor]

I have just used a simple bit of code to +1 / -1 from the value of Cell $A$1 for now, but if anyone can help me work out how to do this only within the range that exists in Database!A:A that would be great!

Rich