VBA - Loop until cell in another worksheet is empty

[annegrey]

Hi all

Example data attached.
I need VBA that will run from Sheet2!A2 and simply bring the contents of cell K2 in Sheet1
I want it to loop until the last cell in column K of Sheet1 is reached.
Each time the data is brought in that needs the macro there is a different amount of data.

Thank you AG

[humdingaling]

i think you mean column I in your example?

also do you need the link or just the value?
in your example you have

Please Login or Register  to view this content.

instead of 8,348.16

[annegrey]

Hi

Apologies - yes I just want to return the values in column I on sheet 2 and I only need the values not the link. I am preparing data for upload to an Oracle database.

AG

[humdingaling]

Please Login or Register  to view this content.

[annegrey]

Thank you very much - that worked well. AG