Seems like this has been answered before. But i've spent a few hours trying to retrofit, and keep getting compile errors. Long story short: when the macro activates it needs to allow the user to navigate to a workbook, open that workbook, copy the data available, and paste into the first empty cell in cell A95 on the "Balance Check Paste" tab of the original workbook. Ideally, it closes the file it opened once complete (i haven't gotten that far yet).
The code i have will do everything up to pasting it into the workbook. I found a solution that could do the last blank cell in column A, but i have hidden cells that help hold places in a pivot sheet, and it would just overwrite those. So i went to a range and have hit a brick wall.
Sub Daily_Update()' '###-Import data from PMS export sheets-### ' 'Import Balance Check Data Application.ScreenUpdating = False Dim uploadfile As Variant Dim uploader As Workbook Dim CurrentBook As Workbook Set CurrentBook = ActiveWorkbook MsgBox ("Please select file with Balance Check data for import") uploadfile = Application.GetOpenFilename() If uploadfile = "False" Then Exit Sub End If Workbooks.Open uploadfile Set uploader = ActiveWorkbook With uploader Application.CutCopyMode = False Range("A2:E2" & Cells(Rows.Count, "A").End(xlUp).Row).Copy End With Set CurrentBook = ActiveWorkbook With CurrentBook.Sheets("Balance Check Entry").Range("a95").CurrentRegion LR_wbSelectNew = .Rows(.Rows.Count).Row End With End Sub