Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
copy range between sheets
I would like to know how I can copy ranges between sheets.
What i have for code right now doesnt work at all. Could someone give advice? Thank you. here's what i have so far: roundNumber = InputBox("Enter the round number for which you would like summary for.", "Summary") K = 4 For J = 4 To 700 If Worksheets(1).Cells(J, "C") = roundNumber Then Set rng = Worksheets(1).Range("F" & J, "O" & J) Set newrng = Worksheets(4).Range("C" & K, "L" & K) newrng = rng K = K + 1 End If Next J --- Message posted from http://www.ExcelForum.com/ |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
copy cell info to other sheets, other sheets dont contain all row. | Excel Worksheet Functions | |||
Sheets named from range, and copy data? | Excel Discussion (Misc queries) | |||
How to repeat a code for selected sheets (or a contiguous range of sheets) in a Workbook? | Excel Worksheet Functions | |||
in VBA Sheets("mysheet").Copy Befo=Sheets(1) how do i get a reference to the newly created copy of this sheet? | Excel Worksheet Functions | |||
copy sheet1 and name sheets using names from a range | Excel Programming |