Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Code for Copying and Pasting data to a separate Workbook
Hello -
I have a workbook that I copy from on a daily basis and paste into another workbook. In each instance, the workbook that I paste to has a slightly different name (i.e., to account for the change in date). As an example: I copy from Sheet5, Range A1:B20 from Workbook A, and paste it into Sheet 3 of Workbook B, Range C1:D20. Is there a way to automate this via VBA? For example, is there code that can say: select this range and place it, via paste special values, in this workbook (perhaps where a dialog box prompts the user for the workbook name) in this range? Thanks in advance for any suggestions or sample code you may be able to provide. |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Copying and pasting links within the same workbook | Excel Worksheet Functions | |||
VBA copying & pasting into a different workbook | Excel Programming | |||
Need to Improve Code Copying/Pasting Between Workbooks | Excel Discussion (Misc queries) | |||
Copying and pasting entire workbook | Excel Programming | |||
Streamline copying and pasting code | Excel Programming |