Hi
I have excel sheets with data as shown in the below example

sheet1 sheet2 sheet3 sheet4 sheet5
c5 10 c5 15 c5 12 c5 20 c5 empty
c6 9 c6 19 c6 11 c6 20 c6 empty
c7 10 c7 15 c7 12 c7 20 c7 empty
c8 9 c8 19 c8 11 c8 empty c8 empty
c9 10 c9 15 c9 12 c9 empty c 9 empty
c10 9 c10 7 c10 3 c10 empty c10 empty
c11 10 c11 5 c11 4 c11 empty c11 empty

I need a function which go through these sheets and return the value of last
cell before the empty cells, in this case the value of c7 in sheet4. The
empty cells will have data in future. Can I create a chart for the above data
and how it will be Axis label range.
Thank you for help