•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
Tagged with
#rows.com
#Excel alternatives for data analysis
#Excel compatibility
#Excel alternatives
#natural language processing for spreadsheets
#generative AI for data analysis
#no-code spreadsheet solutions
#VBA
#macro
#workbook
#pull number
#BOL numbers
#Excel
#index
#column A
#cell B1
#last line
#add 1
#paste
#current workbook