•1 min read•from Microsoft Excel | Help & Support with your Formula, Macro, and VBA problems | A Reddit Community
VBA code for pulling a number at the end of another sheet
I’ve got a sheet where BOL numbers are indexed (I’m talking thousands of lines) and I want to make a macro that will:
-open the index workbook
-pull the number from the last line in column A, and add 1 to it
-paste it into my current workbook in cell B1
-Then close the index workbook
Any suggestions?
[link] [comments]
Want to read more?
Check out the full article on the original site