About Us

GailK

Thanks Don and Dave... it works great!!!

"Don Guillett" wrote:

I understood your need to copy to col F based on row info in col A. Modify
to suit.

--
Don Guillett
SalesAid Software

"GailK" wrote in message
...
Thanks for such a quick response.... When putting in your coding it does
copy
the data into column F however into F2 when the last line is F462. Please
note it copies over a formula in F2 (so it's not as though this was a
blank
cell). Any suggestions?

regards,
Gail

"Don Guillett" wrote:

l4 should be lastrow
..cells(lastrow,"f").PasteSpecial Paste:=xlValues

--
Don Guillett
SalesAid Software

"Don Guillett" wrote in message
...
try this

with Sheets("dailyTeleStat")
lastrow=.cells(.rows.count,"a").end(xlup).row
Sheets("calc worksheet").Range("C95:J95").Copy
.cells(l4,"f").PasteSpecial Paste:=xlValues
end with

--
Don Guillett
SalesAid Software

"GailK" wrote in message
...
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
Show Printable Version	Search this Thread: Advanced Search
Display Modes
Switch to Linear Mode Switch to Hybrid Mode Threaded Mode

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Copying rows of data into new worksheet but placing data into colu	Thalarctos	Excel Discussion (Misc queries)	0	June 6th 10 04:01 AM
Comparing data between sheets, and copying rows with data	Fleone	Excel Programming	1	June 2nd 06 06:54 PM
Copying data as static as source data changes	pfrost	Excel Worksheet Functions	3	March 13th 06 02:52 PM
Copying Data into Column with Existing Data	GZul	Excel Discussion (Misc queries)	0	February 9th 06 11:30 PM
Copying data down to next dirty cell, then copying that data	slarson	Excel Programming	0	September 15th 03 09:19 PM

Menu

About Us