Hi, I'm new here and also new to VB. I used the excel record macro function to did some work on my spreadsheet. It's sorta neat, but I want it to perform more and more user friendly. This is an excel sheet that calculates the number of poles with specific class and height. I want my excel to pick up everything from sheet "input" and start computing and storing each row of data from the sheet "input". If you could kindly look at my 2nd tab which is the calculation, it does identify the highlighted area and add to the zero inventory or latest input by using the two easy macro I created. But I want to start computing from the 1st row of data from sheet "input" to the last row of data from sheet "input" instead of copying rows of data tab to tab. Please help me with this. This is very urgent and I need your great assistance. Thank you very much. Your effort is highly appreciated. Please see the attachment for the macro I created. Once again, thank you.![]()
Bookmarks