Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!
Sub Get_Data() Dim wbk As Workbook Dim destWbk As Workbook Set destWbk = ActiveWorkbook FileToOpen = "K:\Working Data\Loading.xls" Set wbk = Workbooks.Open(FileToOpen) wbk.Sheets(1).Range("A1:IV65536").Copy Destination:=destWbk.Sheets("TotalReq_vs_Bars").Range("A1") wbk.Close End Sub
Add your voice to the tech community where 5M+ people just like you are talking about what matters.
|Reference between list of ingredients and mixtures in Excel||4||34|
|how can I determine if an Excel spreadsheet will fit on an 8.5 by 11 inch sheet?||3||59|
|how to read data from all excel sheet and copy it in in Master sheet||2||26|
|Records being deleted when Condition Not Met||30||28|
Join the community of 500,000 technology professionals and ask your questions.