Keep reference to a cell when column is deleted

Thanks

I'm starting to understand a bit more now but,

It appears to be selecting data from my sheet as opposed to the worksheet I am trying to extract the data from!

I've figured it out!

Thanks so much!

I've done lots of browsing to get help on this spreadsheet but thats the 1st time i've posted.

Thanks for your quick responce to help me out!

Maido!

More Trouble

Having more trouble now

As I am selecting from cells that jump 5 rows each time I cant seem to get it to paste and give me the results!!

Aaaargh

Hi,

can you post the sheet (ZIP it first) - then it's easier for everyone to see what the problem is.

Ed