| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
same sheet copy/paste special
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 |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
same sheet copy/paste special
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 "Rpettis31" wrote: 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 |
|
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
same sheet copy/paste special
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 "Rpettis31" wrote: 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 |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Can't Copy and Paste or Paste Special between Excel Workbooks | Excel Discussion (Misc queries) | |||
| Automating copy/paste/paste special when row references change | Excel Programming | |||
| help w/ generic copy & paste/paste special routine | Excel Programming | |||
| Create new sheet from cell-info and then copy/paste special | Excel Programming | |||
| Dynamic Copy/Paste Special Formulas/Paste Special Values | Excel Programming | |||
Linear Mode
