use macros to copy and paste from 1 file to several files

J

Joy

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.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Automation of scanned file storage based on content 0
Merging from an Excel file with graphics 1
how to copy and paste value from one sheet to another 4
Synchronization problems while moving folders to new email 1
Pasting a cell into bookmarked table from excel vba 1
A couple questions BEFORE using Office 365 0
VBA to Find Key Words in Word doc then Extract Content to Excel.xlsm file 3
Project Online Timesheets Actuals Mismatches - data not publishing to projects 0

Top