Automatic Subtotals using VBA in Excel

[66tigger40]

Hi

Hope i can explain this correctly...

I have a spreadsheet that I run some code on to remove columns, rows etc which all works fine - the final stage is for VBA to:

Find the first blank cell in column C

Move right two and then subtotal above

And then loop again until it comes to the end of the data range

I'm stuck on how best to do this?

Any help greatly received as always

N

 

[SkipVought]

Hi,

You've deleted these rows and destroyed you table's contiguous flow...

why didn't you use the Data/Subtotal feature that is built into excel? A few keystrokes and you have a subtotaled table.

Skip,
[sub]
[red][/red]
[/sub]

 

[66tigger40]

Hi Skip

Thank you for your response - I can't use the standard Subtotal tool as there is no change in...

For example

Row 1 Contains Company Name and Account Number

Column C then has the Amounts

But the Company Name isn't duplicated or the account number

Does that make any sense at all?

Thanks again

 

[SkipVought]

"But the Company Name isn't duplicated or the account number"

Why not? Sure seems like a simple expansion of data to solve a rather complex coding prolem.

Skip,
[sub]
[red][/red]
[/sub]

 

[66tigger40]

Hi Skip

Your right - being newbie to VBA what would be the easiest way to get it to autofill the account code down for each subset?

Thanks for the help and advice

 

[SkipVought]

If you wanted to use the sheet as a report, and give the appearance of your currect format, consider using the features of Format/Conditional Formatting... where the FONT could be shaded the same as the cell interior if the cell & previous values are equal.

Skip,
[sub]
[red][/red]
[/sub]