Working with a TVA industrial customer who gets consolidated bills covering 8 different meters. Spending too much time manually separating the charges by meter number for analysis. Anyone have a VBA macro that can parse these multi-meter bills and split them into separate worksheets? The bill format is fairly consistent - each meter section starts with the meter number and account details.
Simple VBA macro to split utility bills by meter
Terry, I built something similar for FirstEnergy multi-meter accounts. The macro looks for meter number patterns and creates new worksheets based on those breaks. It's about 50 lines of code but works reliably. Main challenge is handling different charge categories consistently across meters. Happy to share if you think it would work for TVA format.
That would be great Jim, thanks! TVA format is pretty straightforward - meter number appears in column A followed by usage and demand data in the next several rows. If your macro can handle that basic pattern, I can probably modify it for the specific TVA layout.