| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
use macros to copy and paste from 1 file to several files
Hi, i have a file that i regularly work on for data to be pasted to several
files. In the data, it contains part of the filenames of the files that each set of data needs to be pasted to. As an example, i have data called "Master file". in one of the worksheet, lines 1 to 100 needs to be copied and inserted into line 3 of File A, line 102 to 200 needs to be copied and inserted into line 3 of File B. At the same time, File A and B needs to be created and name "File A" and "File B" . I have to do this to about 10 files several times a month. Please let me know if you have a good automated solution for this. Thank you. |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| copy&paste 28 individual files into one file/28 work sheets | Excel Worksheet Functions | |||
| Problem with copy and paste together with macros | Excel Worksheet Functions | |||
| Copy and Paste Macros | Excel Discussion (Misc queries) | |||
| Creating a macros to copy and paste cells | Excel Discussion (Misc queries) | |||
| Copy and pasting files with macros | Excel Discussion (Misc queries) | |||
Threaded Mode
