Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Copy Current Month into YTD Spreadsheet
I would like to create a macro to copy the current month information from one
spreadsheet into a Montly YTD spreadsheet. I want to be able to create a macro so that for example if it's June, the macro would know how many columns over it needs to "copy to" on the YTD spreadsheet. I will be doing this each month. Hope that makes sense. Thanks! -- AJ |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Copy Current Month into YTD Spreadsheet
Sub dural()
Sheets("Data").Range("A:A").Copy Sheets("Monthly").Activate Cells(1, Month(Date)).Select ActiveSheet.Paste End Sub -- Gary''s Student - gsnu200796 "AJ" wrote: I would like to create a macro to copy the current month information from one spreadsheet into a Montly YTD spreadsheet. I want to be able to create a macro so that for example if it's June, the macro would know how many columns over it needs to "copy to" on the YTD spreadsheet. I will be doing this each month. Hope that makes sense. Thanks! -- AJ |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Subtract a future month from the current month to get remaining m. | Excel Worksheet Functions | |||
Retrieve data for previous 3, 6, 12 month given current month | Excel Worksheet Functions | |||
copy worksheet from previous month and rename to current month | Excel Programming | |||
Unable to copy another spreadsheet to the current spreadsheet with | Excel Programming | |||
How to open another Excel spreadsheet to copy data into current spreadsheet ? | Excel Programming |