I am needing assistance. This maybe somewhat common knowledge for some, however I am new to VBA.
I have one spreadsheet that I have written a macro to organize data how I need it. What I need to know is how to have the macro browse and open another excel file. Then place the data from one sheet to another.
See if you can use this as a starting point. You'll have to modify it, of course.
Dim varFile As Variant
Dim wbkCurrent As Workbook
Dim wbkOther As Workbook
' Prompt user to select another workbook
varFile = Application.GetOpenFilename(FileFilter:="Excel Workbooks (*.xls*),*.xls*")
If VarType(varFile) = vbBoolean Then
' Reference to the active workbook
Set wbkCurrent = ActiveWorkbook
' Open the other workbook
Set wbkOther = Workbooks.Open(varFile)
' Do something with the selected workbook
' Close the other workbook