Results 1 to 3 of 3

Count and compute rows of data with different catagories and description 2003 format

Threaded View

bsengineer Count and compute rows of... 09-28-2009, 08:42 PM
shg Re: PLEASE help! My macro... 09-28-2009, 08:51 PM
Leith Ross Re: PLEASE help! My macro... 09-28-2009, 08:51 PM
  1. #1
    Registered User
    Join Date
    09-28-2009
    Location
    North Carolina, USA
    MS-Off Ver
    Excel 2003
    Posts
    4

    Question Count and compute rows of data with different catagories and description 2003 format

    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.
    Attached Files Attached Files
    Last edited by bsengineer; 09-28-2009 at 09:30 PM. Reason: Follow forum rules

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1