Copy formula down up to last row

  • Thread starter Thread starter Eva
  • Start date Start date
E

Eva

I have two sheets - master and sheet1. There are a few columns in sheet1 that
are the same as columns in master tab. The formula in each column in sheet1
that is linked to master tab. I need to copy formula down in sheet1 up to
blank row in master tab. Can you help me?
Eva
 
LastRow = sheets("master").range("A" & rows.Count).end(xlup).row
sheets("sheet1").range("B1").copy _
destination:=sheets("sheet1").range("B2:B" & LastRow)
 
it works great! Thank you very much
Eva

Joel said:
LastRow = sheets("master").range("A" & rows.Count).end(xlup).row
sheets("sheet1").range("B1").copy _
destination:=sheets("sheet1").range("B2:B" & LastRow)
Click to expand...
 
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

EXCEL - IF(IFERROR(VLOOKUP question 0
loop to copy paste 5
Macro to Compile Data from Different Sheets 2
copy a formula down up to blank cells from other sheet 1
Want code to copy to ABOVE row 22 column A on sheet 1 10
Change file name when saved to C drive 2
Excel VBA 1
Macro to Combine Data from Multiple Sheets with Cell References 4

Back
Top