Forum Discussion
How to increment entry point into table
An image is only minimally helpful to those of us who would be interested in helping you. It's clear you have an actual spreadsheet...is it possible for you to post THAT, or, if the actual one contains confidential information of some sort, then a recreation without that confidential info.
Otherwise you're asking us to do that on our own, and that would involve making a lot of possibly false assumptions and thereby being unhelpful.
That said, I just want to make sure you know of the ROW function. Given your description, that might work to increment that row in H7...if that is the solution you've been looking for, fine. Otherwise, please help us help you by posting an actual workbook that incorporates your problem.
Thank you for your response. I have attached a Excel File that I tried to make several years ago. I finally gave up and wrote a small program in C# to do this. That is where I got the idea to do what I am trying to do now. There is nothing confidential or even particularly interesting about what I am trying to do with the new spread sheet. I am just manipulating a point in space but I am trying to use the exact same scenario to increment or iterate through the values used to enter the table. So if you can offer any help with the attached Income Tax file I can kill two birds with one solution. I'm actually not a hunter so I don't kill birds or any other animal but I really will and do appreciate your help. Thanks.
