cell linking to another last cell of another column

**Vegita** · 02-04-2010, 03:58 PM

Hi guys
Again i'm blocked, and again i look for rescue

I would like to link a cell to another last blank cell (on another sheet)

for example
Sheet1 column A1, A2 has data and A3 is empty
Link(copy) sheet2 A1 to a free (available cell) in sheet1 column A (in this case it will be A3

thanks in advance, and you guys are great help

**JeanRage** · 02-05-2010, 05:47 AM

Hi,

What is preventing you from using a simple If() function ...?

**Vegita** · 02-05-2010, 03:18 PM

it gives me errors when i try to use if function, i tried many possibilities, but still cannot find the right function

**ChemistB** · 02-05-2010, 03:25 PM

If I understand you correctly, you want whatever you enter into Sheet2!A1 to be automatically transferred to the first available cell in Sheet1 column A? And you would want that value to be permanent so that when you enter a new value in A1 (Sheet2) that would be transferred to the next available cell. Is that what you are asking for?

You'll need to use VBA for that. Formulas won't work.