Find end of column and paste formula in adjacent colmn
 

If I have 3 rows of date in columns A and B, but then add two more
rows (and in future will be regularly adding rows), like this...

A B C
1 1 2 Formula
2 1 2 Formula
3 2 1 Formula
4 1 2
5 2 1

....Can I write a macro that finds the end of column A and B, and then
copies the formula in column C down to the end of data in A and B?

Thanks in advance!

Find end of column and paste formula in adjacent colmn
 

How does this differ from the question you posted earlier today???
--
HTH...

Jim Thomlinson


" wrote:

If I have 3 rows of date in columns A and B, but then add two more
rows (and in future will be regularly adding rows), like this...

A B C
1 1 2 Formula
2 1 2 Formula
3 2 1 Formula
4 1 2
5 2 1

....Can I write a macro that finds the end of column A and B, and then
copies the formula in column C down to the end of data in A and B?

Thanks in advance!

Find end of column and paste formula in adjacent colmn
 

It doesn't. I thought that earlier post had been removed.

On Aug 9, 5:34 pm, Jim Thomlinson <James_Thomlin...@owfg-Re-Move-
This-.com wrote:
How does this differ from the question you posted earlier today???
--
HTH...

Jim Thomlinson



" wrote:
If I have 3 rows of date in columns A and B, but then add two more
rows (and in future will be regularly adding rows), like this...

A B C
1 1 2 Formula
2 1 2 Formula
3 2 1 Formula
4 1 2
5 2 1

....Can I write a macro that finds the end of column A and B, and then
copies the formula in column C down to the end of data in A and B?

Thanks in advance!- Hide quoted text -

- Show quoted text -