Need a Copy Macro to copy from 20 workbooks to a master workbook with 10 sheets

thankyouforyourhelp

New Member
Joined
Mar 13, 2019
Messages
1
I have a master workbook with about 10 sheets, each sheet has its own name, for example Origins, Twisted etc. For each sheet in my master workbook, I have 2 files XXX Pene, and XXX Oppo, from where I need to copy data.

Copy from XXX Pene: a range from cell B14 to cell D19 Paste to Master sheet xxx: a range from cell E17 to cell G22

Copy from XXX Oppo: a range starting with cell B13 Paste to Master sheet xxx:a range starting with cell A26

Oigins Pene & Origins Oppo are in the same folder; Twisted Pene & Twisted Oppo are in the same folder; But Origins and Twisted are in different folders

Here are 2 specific example:

1. For my master workbook sheet "Origins":

I need to copy data in a range from cell B14 to cell D19 in origins pene, and paste it to a range from cell E17 to cell G22 in the master workbook sheet Origins

I need to copy data in a range starting with cell B13 in the origins Oppo, and paste it to a range starting with cell A26 in the master workbook sheet Origins

2. For Twisted, I need to copy data from another 2 files,Twisted Pene & Twisted Oppo

I need to copy data in the range from cell B14 to cell D19 in Twisted Pene, and paste it to a range from cell E17 to cell G22 in my master workbook sheet Twisted

I need to copy data in a range starting with cell B13 in the origins Oppo, and paste it to a range starting with cell A26 in my master workbook sheet Twisted

3. So on and so forth for the rest


There will be more sheets adding to my master workbook, but need the same cope paste work. I will need to do the work every week so that I really wish this process could be done automatically.

Thank you very much in advance if anyone could help me with it! :)
 

Some videos you may like

Excel Facts

Highlight Duplicates
Home, Conditional Formatting, Highlight Cells, Duplicate records, OK to add pink formatting to any duplicates in selected range.

Watch MrExcel Video

Forum statistics

Threads
1,109,351
Messages
5,528,192
Members
409,807
Latest member
nicky736

This Week's Hot Topics

  • Change military grades into rank
    Afternoon all Need help with formula that will change military rank (i.e. 1, 2, 3 into Amn, A1C, SrA). Running IF formula that does not work...
  • VBA COUNTIF SOLUTION
    Hi The following are the errors spread across the several columns from E to Q ie. 13 columns across several sheets with more than 500 rows per...
  • INSERT ROW WITH SPECIFIS TEXT IN A COLUMN
    Hi All! How can identify that that the row to be inserted has to be inserted before 1st row with specific text in column F. If I record the...
  • Auto-Create a monthly Sign in sheet for preschool students
    The image below is what each page looks like. Above is space for the "Child Name" "Month" "Class" School days are obviously Monday-Friday but...
  • VBA vlookup multiple results
    Hi folks, Hopefully someone out there can help. I have a list to vlookup which works (ish). the lookup only picks up the first instance of the...
  • Extract values for earliest/latest times
    I am trying to put together a formula to get the earliest start time, the latest end time from column A for each person in Column B-F without the...
Top