Good Morning,
I am hoping someone can help me. I am trying to extract information from a sheet containing various statistics. within the sheet there are tables for each team member in the same format. I am trying to build a formula to extract the cell data I need.
I was looking to use a vlookup to set the data relating to each person. The team members name is allways in column A
first team members name is Jeff
Once I have selected the starting cell for example cell A35.
I then wish to start selecting data. (I can do it in VBA, but it is not feasible for this project).
field one
A35 offset (columns down (27) columns to right (20)
field two
A35 offset (columns down (15) columns to right (7)
etc etc
could anyone offer any guidance on the best function to use to achieve my end goal or a pratical example to work with
thanks in advance
I am hoping someone can help me. I am trying to extract information from a sheet containing various statistics. within the sheet there are tables for each team member in the same format. I am trying to build a formula to extract the cell data I need.
I was looking to use a vlookup to set the data relating to each person. The team members name is allways in column A
first team members name is Jeff
Once I have selected the starting cell for example cell A35.
I then wish to start selecting data. (I can do it in VBA, but it is not feasible for this project).
field one
A35 offset (columns down (27) columns to right (20)
field two
A35 offset (columns down (15) columns to right (7)
etc etc
could anyone offer any guidance on the best function to use to achieve my end goal or a pratical example to work with
thanks in advance
