Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Subtracting & counting rows
I work for a prefab home company and we have a packing list using Excel.
There are many sub-category to correspond with the house package. I’m trying to write a VB sub-routine that will find a sub-category i.e. #101 and then find the next sub-category #102. (All sub-categories numbers are in “A” column.) Once it locates the two sub-category it will subtract the two to calculate the number of rows. Then it produces a range from “A” column to “Q” column, so it can copy this area to another part of the spread sheet. On each house package the sub-category numbers are never on the same row. Can this be done? *** Sent via Developersdex http://www.developersdex.com *** |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Counting characters in multiple rows when rows meet specific criteria | Excel Worksheet Functions | |||
subtracting with blank rows inbetween? | Excel Worksheet Functions | |||
Counting unique values and subtracting those of no interest | Excel Worksheet Functions | |||
Counting rows, then counting values. | Excel Discussion (Misc queries) | |||
Counting Rows Then Counting Values in Columns | Excel Programming |