Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
copy a formula down up to blank cells from other sheet
I have two sheets:Master with all data and sheet2 with some columns that are
the same as master. I set a formula simply links some data in Sheet2. I need to copy this formula in sheet2 down up to last row in master sheet. I started working on the macro, but I am stuck. Can you help? Sub Macro7() Sheets("Master").Select Dim LastRow As Long LastRow = Cells(Rows.Count, 1).End(xlUp).Row 'MsgBox OstatniWiersz Sheets("Sheet2").Select Range("a2:s2").Select Selection.Copy ....? |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
copy a formula down up to blank cells from other sheet
Eva,
Replace Range("a2:s2").Select Selection.Copy ....? With Range("a2:s2").Copy Range("a2:s" & LastRow) HTH, Bernie MS Excel MVP "Eva" wrote in message ... I have two sheets:Master with all data and sheet2 with some columns that are the same as master. I set a formula simply links some data in Sheet2. I need to copy this formula in sheet2 down up to last row in master sheet. I started working on the macro, but I am stuck. Can you help? Sub Macro7() Sheets("Master").Select Dim LastRow As Long LastRow = Cells(Rows.Count, 1).End(xlUp).Row 'MsgBox OstatniWiersz Sheets("Sheet2").Select Range("a2:s2").Select Selection.Copy ...? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Need Array Formula for Counting Blank & Non Blank Cells (Multiple Criteria) | Excel Discussion (Misc queries) | |||
Formula to copy multiple cells onto another sheet | New Users to Excel | |||
Copy to first Blank cell in Colum C Non blank cells still exist be | Excel Programming | |||
I want to copy a formula n Excel but skip any blank cells | Excel Worksheet Functions | |||
Formula to copy rng of cells where (value is met) to anther sheet | Excel Worksheet Functions |