I'm trying to automate a report i currently create from a pivot table and then "spruce" up manually. Been working on it today and have easily managed to get all the data from my pivot table. The problem lies in the formatting.
For each region i do a breakdown by surveyor of their jobs per month by area, postcode and product on three seperate reports. So you get something like this:
What i'm looking for is how to express an xldown command that will go from (assume Ben Smith is A1, 25 is B1) A2 to the next cell formatted bold, offset -1 (so in this case B2:B5) i can then add in the conditional formatting vba to add the data bars in which i know how to do.
So literally find and select the next "non bold" cell, then select from this cell down to the cell before the next "bold" formatted cell.
Your help would be greatly appreciated
Thanks
Ben
For each region i do a breakdown by surveyor of their jobs per month by area, postcode and product on three seperate reports. So you get something like this:
i then do data bars on these broken down figures ie. Beeston, Nottingham and Carlton for Ben Smith, Derby, Alvaston etc for John Regis.Ben Smith 25
Beeston 10
Nottingham 11
Carlton 4
John Regis 34
Derby 10
Alvaston 3
Belper 2
Allestree 8
Chaddesden 5
Peartree 6
Next Surveyor etc
What i'm looking for is how to express an xldown command that will go from (assume Ben Smith is A1, 25 is B1) A2 to the next cell formatted bold, offset -1 (so in this case B2:B5) i can then add in the conditional formatting vba to add the data bars in which i know how to do.
So literally find and select the next "non bold" cell, then select from this cell down to the cell before the next "bold" formatted cell.
Your help would be greatly appreciated
Thanks
Ben
Last edited: