Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Copy / Paste macro
Hello,
I am trying to automate the following process and am wondering if anyone could help me with creating a macro to accomlish the following: Search a column (i.e F), which consists of only date entries in form mm/dd/yy hh:mm, and filter in all entries which match last month (current month -1). Then cut those entries, open file called bc-log.xls and paste them starting at row 2, saving changes to both files. There can be anywhere from 10 to 50 entries that the filter would match.... the number of previous month entries always varies. Thank you, Luke Slotwinski |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
copy multiple worksheets of a workbook, and paste onto a Word document ( either create new doc file or paste onto an existing file.) I need this done by VBA, Excel Macro | Excel Programming | |||
Copy and Paste macro needs to paste to a changing cell reference | Excel Programming | |||
how to count/sum by function/macro to get the number of record to do copy/paste in macro | Excel Programming | |||
Macro to Copy/Paste then Paste to Next Line | Excel Programming | |||
Copy and Paste Macro Help please.... | Excel Programming |