Copying From One Workbook to Another Workbook

Josh1012 · #1 09-11-2018, 02:48 AM

Quote:

Originally Posted by Josh1012

I want to see If I can Loop through Each workbook and copy a range of data from 2 different sheets within each workbook back to one sheet in the master workbook.

I realize how to finally do this, and this is what I came up with:

Code:

Sub CopyToAnotherWorkbook()



ActiveWorkbook.Sheets("Sheet5").ActivateNumRow = Sheets("Sheet5").UsedRange.Rows.Count
Range(Cells(1, 1), Cells(NumRow)).Select
Selection.Copy
Windows("Gerotor Design Studio Results.xlsm").Activate
ActiveCell.Select
ActiveSheet.Paste


End Sub

It's not what I originally wanted but it's easier to automate things I figure with many small macros and just call macro's when you need them. Although I'm not sure if this slows it down.

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Copying a Sheet in a Workbook to Another with Destination-Need Values Instead of Formulas	rsrasc	Excel Programming	4	08-19-2018 04:00 PM
Sharing a Workbook that contains array formula link to other workbook	Ahmad.rage22@gmail.com	Excel	0	03-12-2018 10:15 PM
Copying Every Other Row from one workbook to another.	eleno5485	Excel	1	04-07-2017 03:30 PM
data entered in one workbook should be updated in other relevant workbook based on the date	vedha	Excel	0	04-24-2015 08:45 PM
Range(Cell1,Cell2) Error on another workbook controlling some other workbook?	tinfanide	Excel Programming	1	02-09-2012 04:08 PM