Copy formula down up to last row
 

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

Copy formula down up to last row
 

LastRow = sheets("master").range("A" & rows.Count).end(xlup).row
sheets("sheet1").range("B1").copy _
destination:=sheets("sheet1").range("B2:B" & LastRow)

"Eva" wrote:

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

Copy formula down up to last row
 

it works great! Thank you very much
Eva

"Joel" wrote:

LastRow = sheets("master").range("A" & rows.Count).end(xlup).row
sheets("sheet1").range("B1").copy _
destination:=sheets("sheet1").range("B2:B" & LastRow)

"Eva" wrote:

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