| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Coping Dates from workbook to workbook
For some reason everything copys to the new work book except for the date
column "L" can someone help me please. I stoped the code and it will only select the first date. But all other works why? how do I fix? ActiveSheet.Range("A2").AutoFilter Field:=12, Criteria1:="<" Application.ScreenUpdating = False Workbooks.Open Filename:= _ "C:\Users\Kenny\Documents\Toyota\Floater\Daily Tracker Report.xls" Windows("New Tracker.xls").Activate Range("L6").End(xlDown).Copy <======================== Windows("Daily Tracker Report.xls").Activate Worksheets("sheet1").Range("A5").PasteSpecial Paste:=xlPasteValues Windows("New Tracker.xls").Activate Range("A6:B6").Select Range(Selection, Selection.End(xlDown)).Select Selection.Copy Windows("Daily Tracker Report.xls").Activate Worksheets("sheet1").Range("B5").PasteSpecial Paste:=xlPasteValues Windows("New Tracker.xls").Activate Range("G6:K6").Select Range(Selection, Selection.End(xlDown)).Select Selection.Copy Windows("Daily Tracker Report.xls").Activate Worksheets("sheet1").Range("D5").PasteSpecial Paste:=xlPasteValues Windows("New Tracker.xls").Activate Range("A6").Select 'Range(Selection, ActiveCell.SpecialCells(xlLastCell)).Select 'Selection.EntireRow.Delete 'Windows("Daily Tracker Report.xls").Activate ActiveSheet.Range("A2").AutoFilter Field:=12 |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Date changes when cutting and pasting dates to new workbook /works | Excel Discussion (Misc queries) | |||
| Linking dates to different workbook, then data. | Excel Worksheet Functions | |||
| I want to do a workbook with dates and times | Excel Discussion (Misc queries) | |||
| Formatting a workbook with dates | Excel Discussion (Misc queries) | |||
| how do I link purchase order dates from one excel workbook to ano. | Excel Worksheet Functions | |||
Threaded Mode
