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.