Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Dynamic Copy and paste to another worksheet
Sub Tester1()
Set rng = Worksheets("Groups") _ .Cells(Rows.Count, 1).End(xlUp)(2) Worksheets("Selection").Range("B4:F14") _ .Copy Destination:=rng rng.Offset(-1, 5).Resize(12, 20).FillDown End Sub Assume you are pasting to column A and the formulas begin in column F in Sheet groups and there are 20 columns of formulas to filldown next to the pasted data (11 rows). -- Regards, Tom Ogilvy "Tony Scullion" wrote in message ... Hi Group,a R How do I copy and paste the contents from range (b4:f14) on a worksheet called Selection to another worksheet called Groups where it will... 1 Be dynamically added to the bottom of an ever growing list 2 It copies and applies the formula from the cells above TIA Tony |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Dynamic Copy and paste to another worksheet
Pefect - thanks Tom
Tony -----Original Message----- Sub Tester1() Set rng = Worksheets("Groups") _ .Cells(Rows.Count, 1).End(xlUp)(2) Worksheets("Selection").Range("B4:F14") _ .Copy Destination:=rng rng.Offset(-1, 5).Resize(12, 20).FillDown End Sub Assume you are pasting to column A and the formulas begin in column F in Sheet groups and there are 20 columns of formulas to filldown next to the pasted data (11 rows). -- Regards, Tom Ogilvy "Tony Scullion" wrote in message ... Hi Group,a R How do I copy and paste the contents from range (b4:f14) on a worksheet called Selection to another worksheet called Groups where it will... 1 Be dynamically added to the bottom of an ever growing list 2 It copies and applies the formula from the cells above TIA Tony . |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
copy & paste worksheet with print settings into new worksheet | Excel Discussion (Misc queries) | |||
Impossible? dynamic copy/paste | Excel Discussion (Misc queries) | |||
Copy worksheet with dynamic chart? | Charts and Charting in Excel | |||
allow me to copy and paste in a protected worksheet | New Users to Excel | |||
copy/Paste references other worksheet | Excel Worksheet Functions |