LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 23
Default 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
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
variable ranges gramps Excel Discussion (Misc queries) 4 February 4th 10 02:33 PM
Help with Variable Ranges! Nelson B. Excel Discussion (Misc queries) 1 August 21st 08 03:30 PM
Variable Ranges Erika Excel Worksheet Functions 1 November 30th 07 09:21 PM
Variable ranges John Contact Excel Worksheet Functions 1 June 17th 05 08:02 AM
Sum Variable Ranges Erika Excel Worksheet Functions 6 December 23rd 04 03:52 PM


All times are GMT +1. The time now is 12:02 AM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"