PDA

View Full Version : Sleeper: Format summary lines



austenr
06-01-2005, 09:52 AM
I have been struggling with this for a while. In the attached workbook there are areas highlighted in yellow and blue. The yellow areas are being moved as I want but I just discovered that the areas in blue are incorrect.

Some of the areas in blue may or may not be on the report depending on if there is anyone in that category or not. This is where I get stuck. My code right now (not that great but it worked) is a lot of If statements moving certain cells depending on the entries on the sheet. However, if there are additions or deletions in the areas in blue I cannot use my code as is because it will in most likelihood not move the correct data.

Is there a way to loop through all areas highlighted and have it come out formatted as in columns H ? M. I thought about a case statement but I am not sure where to put the code or if it would work for all lines highlighted.

As always this is a learning experience so any help would be appreciated.

austenr
06-01-2005, 12:32 PM
I took the long way around but got it to work...