Tommy
03-11-2014, 07:03 AM
Hi All,
I have a spreadsheet attached with what I am working with. What I would like to do is select the County and have it appear at the bottom with the rainfall intensity. This is a lot smaller than what I work with but it still works the same. I have over 3100 lines so I cut them down a little.
I have it set up to copy the bottom line with the rainfall intensity to another page and it helps design the gutter and downspouts to carry the water off. This is working just fine, I am using subtotals. The part I need the help with is when I select the county I would like to have it show up right beside the rainfall intensity, this way I can copy it to another sheet and finish the documentation. I would like a formula if at all possible. I can code the VBA no problem, I am thinking that I don't have to, this would be the only reason to have any VBA at all and seems such a waste. I just don't know the formulas I need to pick up only the visible cells.
This is to keep me from having to type so much. I have a real bad case of fat fingers. :)
I have a spreadsheet attached with what I am working with. What I would like to do is select the County and have it appear at the bottom with the rainfall intensity. This is a lot smaller than what I work with but it still works the same. I have over 3100 lines so I cut them down a little.
I have it set up to copy the bottom line with the rainfall intensity to another page and it helps design the gutter and downspouts to carry the water off. This is working just fine, I am using subtotals. The part I need the help with is when I select the county I would like to have it show up right beside the rainfall intensity, this way I can copy it to another sheet and finish the documentation. I would like a formula if at all possible. I can code the VBA no problem, I am thinking that I don't have to, this would be the only reason to have any VBA at all and seems such a waste. I just don't know the formulas I need to pick up only the visible cells.
This is to keep me from having to type so much. I have a real bad case of fat fingers. :)