Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Copy most recent data from one workbook to another with a Macro
I need to write a marco that will copy data from one workbook and paste it in
another. The trick is that I want it to copy only the new month's data instead of copying the entire year. For example I have a table that looks like this Month Stuff 1 Stuff 2 Stuff 3 January 935,853 191,486 101,672 February 896,220 188,517 106,998 March 820,738 173,282 98,372 April 886,912 192,227 99,025 May 857,066 189,090 97,562 June July The table I am pasting the data to looks similiar, but it just missing the most recent month of data. The current macro that I have copies the entire year and looks like this: Workbooks.Open "L:\Blkacc223508.xls" Worksheets("Total-1").Select Range("C3:N14").Select Selection.Copy Windows("2008 worksheets.xls").Activate Range("B59").Select Selection.PasteSpecial Paste:=xlPasteValues, Operation:=xlNone, SkipBlanks _ :=False, Transpose:=True Range("A72").Select Thank you in advance for your help. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Create a macro to copy data from one workbook to another | Excel Discussion (Misc queries) | |||
$%Macro to Copy from one workbook to other when matching data | Excel Discussion (Misc queries) | |||
macro for copy data from all worksheets of a workbook to single sh | Excel Discussion (Misc queries) | |||
Macro Help. Copy data from 1 workbook to another on next available | Excel Discussion (Misc queries) | |||
Macro to copy data into another workbook | Excel Discussion (Misc queries) |