Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Counting variable ranges and auto-summing variable ranges
It's been a while since I've used VBA, I'm hoping someone can
help me. I have a spreadsheet of data for several accounts, I divide the data into sections based on the account number in Column A. I then insert two blank rows between each section. Now I need to do two things. (1) In column A of the first blank row below each data section, I need to calculate the number of entries in that section, (2) using offset, moving to the right I need to do an autosum on 3 columns. Just recording the autosum function locks it into the first range of cells autosum picks, so that won't work on any sections other than the first -- I have ~500 sections and 8000 rows of data to analyse. If I have to enter the autosum manually for 500 rows and 3 columns (1500 entries) I'll die. Not to mention it'll take forever. If you can help I'd really appreciate it. Thanks, Norm |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
variable ranges | Excel Discussion (Misc queries) | |||
Help with Variable Ranges! | Excel Discussion (Misc queries) | |||
Variable Ranges | Excel Worksheet Functions | |||
Variable ranges | Excel Worksheet Functions | |||
Sum Variable Ranges | Excel Worksheet Functions |