Find end of column and paste formula in adjacent colmn

  • Thread starter Thread starter briandhowells
  • Start date Start date
B

briandhowells

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!
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Copy columns and paste with blank column between 5
Help needed to writing a macro to put the year in column B of a tableusing Table nomenclature & the 7
Paste in column B using Last row of either column B, C or D. 10
Column number of last column that returns value ignore formulas 8
Excel VBA 1
Transfer array element offset value to a matched value 3
A data validation question 1
Supressing a #VALUE! error returned? 3

Back
Top