Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Copy range C5:Lastrow and paste to two different worksheets
Good morning
I cannot seem to find a solution to this, and hope someone might be able to help me. I have three worksheets: Ratios, Trades, Trades2 I am trying to find a vba method to select the Range C5:(the last row used in columnC) on the Ratios sheet, and copy and paste this range to Cells F11-down on the Trades and Trades2 Sheets. Please could someone provide a suggestion for this. I really do appreciate the help Regards, Paul |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Copy range C5:Lastrow and paste to two different worksheets
Darn it, always pleasing when I manage to solve my own problem - but always
concerned I may have wasted someones time by posting here and then figuring it out two seconds later :p: this works perfectly in case someone else runs into a similar issue: Sub percentages() Dim LastrowA As Long Set SrcSht = Sheets("Ratios") Set DstSht = Sheets("Trades") Set DstSht1 = Sheets("Trades2") LastrowA = SrcSht.Cells(Cells.Rows.Count, "C").End(xlUp).Row SrcSht.Range("C5:C" & LastrowA).Copy DstSht.Cells(11, 6) SrcSht.Range("C5:C" & LastrowA).Copy DstSht1.Cells(11, 6) End Sub Thanks if u were investigating it for me though I do appreciate your time "PVANS" wrote: Good morning I cannot seem to find a solution to this, and hope someone might be able to help me. I have three worksheets: Ratios, Trades, Trades2 I am trying to find a vba method to select the Range C5:(the last row used in columnC) on the Ratios sheet, and copy and paste this range to Cells F11-down on the Trades and Trades2 Sheets. Please could someone provide a suggestion for this. I really do appreciate the help Regards, Paul |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
HELP Lastrow Range | Excel Discussion (Misc queries) | |||
Copy range from one worksheet and paste to multiple worksheets | Excel Discussion (Misc queries) | |||
Copy & Paste Range from all Worksheets in all Workbooks in a folder | Excel Programming | |||
Looping: Search Range in Multiple Selected Worksheets, Copy/Paste | Excel Programming | |||
Lastrow in Range | Excel Discussion (Misc queries) |