same sheet copy/paste special

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Rpettis31 - 12 Mar 2008 15:34 GMT

I have data that is prefilled from other sheets to this master sheet.
The dates are prefilled and a Vlookup applies the data in the appropriate
cell without VB. I just want to copy and paste special the values in the
sheet for the current date.

DATE Positions
03/12/08 500 <--- want to automate the copy paste special rather
than the manual process.

For dt=2 to 1000
If cells(dt,1)=date then Copy paste special this row.
Next dt

Reply to this Message

JLGWhiz - 12 Mar 2008 16:01 GMT

This psuedo code gives the syntax you would use.
Dim dt As Range
For dt=2 to 1000
If cells(dt,1)=date Then
dt.EntireRow.Copy
Range("Z1").PasteSpecial Paste:=xlPasteValues
Next dt

> I have data that is prefilled from other sheets to this master sheet.
> The dates are prefilled and a Vlookup applies the data in the appropriate
[quoted text clipped - 13 lines]
>
>

Reply to this Message

JLGWhiz - 12 Mar 2008 19:48 GMT

Forgot the End If

This psuedo code gives the syntax you would use.
Dim dt As Range
For dt=2 to 1000
If cells(dt,1)=date Then
dt.EntireRow.Copy
Range("Z1").PasteSpecial Paste:=xlPasteValues
End If
Next dt

> I have data that is prefilled from other sheets to this master sheet.
> The dates are prefilled and a Vlookup applies the data in the appropriate
[quoted text clipped - 13 lines]
>
>

Reply to this Message