Copy formula down up to last row

's Computer Specifications

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

's Computer Specifications

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

's Computer Specifications

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

Thread Tools
Show Printable Version Email this Page
Rate This Thread
Rate This Thread:

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Excel formula to copy/paste formula needed please.	colwyn	Microsoft Excel Misc	4	22nd Oct 2008 11:27 PM
copy formula result (text) only - without copying formula	Mulberry	Microsoft Excel Misc	2	2nd Oct 2008 09:51 AM
I copy a formula and the results copy from the original cell	=?Utf-8?B?YnJvb2tseW5zZA==?=	Microsoft Excel Misc	1	23rd Jun 2007 01:35 AM
copy formula down a column and have cell references change within formula	brad	Microsoft Excel New Users	5	13th May 2007 04:38 PM
Copy/Paste how to avoid the copy of formula cells w/o calc values	=?Utf-8?B?RGVubmlz?=	Microsoft Excel Misc	10	2nd Mar 2006 10:47 PM