Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
copying data
Hi,
I'd like to copy the range in 'calc worksheet' into 'DailyTeleStat' worksheet following the last entry. I have seen vba coding where data can be copied into the first empty row, however, the row being copied into is not complete empty .. contains date/week number/period etc in the first few columns (b-e); therefore, I'd been looking to have the data copied starting at column f. How can I update the coding below to accomplish my means? Sheets("calc worksheet").Select Range("C95:J95").Select Application.CutCopyMode = False Selection.Copy Sheets("dailyTeleStat").Select Range("F461").Select Selection.PasteSpecial Paste:=xlValues, Operation:=xlNone, SkipBlanks:= _ False, Transpose:=False Thanks, Gail |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Copying rows of data into new worksheet but placing data into colu | Excel Discussion (Misc queries) | |||
Comparing data between sheets, and copying rows with data | Excel Programming | |||
Copying data as static as source data changes | Excel Worksheet Functions | |||
Copying Data into Column with Existing Data | Excel Discussion (Misc queries) | |||
Copying data down to next dirty cell, then copying that data | Excel Programming |