Hi,
Does anyone have suggestions for the following:
The following code works great for adding the value of Cell A2 Sheet 2 to the last cell in column B Sheet 1.
Sub test()
Sheets("sheet2").Range("A2").Value = Sheets("sheet2").Range("A2").Value + _
Sheets("Sheet1").Range("B" & Rows.Count).End(xlUp).Value
End Sub
I would like to add the last cell in Column B Sheet 1 in Workbook 1 to
the value of cell A2 sheet1 in Workbook 2.
Basically the same formula but adding cells from different spreadsheets.
Any help would be greatly appreciated!
Bookmarks