Hi All,
I have imported data onto my workbook from the web I have two questions,
The first issue in regards to the first image, what is the most efficient way to take the information from the data sheet into my Base set sheet, here I believe I'm using a cell reference would this be a less consuming formula than say a Vlookup?
The second issue also in the first image is when highlighting the values in column H I am not get the value sum, at some point I would like to calculate these values with formula but it doesn't seem like I can do that any ideas? the values are taken from the table in the second image displaying the web data,
As always your help and time is valued and thanks for your continued support
I have imported data onto my workbook from the web I have two questions,
The first issue in regards to the first image, what is the most efficient way to take the information from the data sheet into my Base set sheet, here I believe I'm using a cell reference would this be a less consuming formula than say a Vlookup?
The second issue also in the first image is when highlighting the values in column H I am not get the value sum, at some point I would like to calculate these values with formula but it doesn't seem like I can do that any ideas? the values are taken from the table in the second image displaying the web data,
As always your help and time is valued and thanks for your continued support