Thread: [Solved] Blank Line Supression
View Single Post
 
Old 11-21-2012, 12:14 AM
Nibbles Nibbles is offline Windows 7 64bit Office 2010 64bit
Novice
 
Join Date: Nov 2012
Posts: 9
Nibbles is on a distinguished road
Default

Hi Paul, ive uploaded a small demo file that might explain it better.

Although the final file is much larger with much more data it has the same basic components.

Essentially, the boxes that are shaded green are what I want to retain, rather than the line being surpressed. To do this, i'd put an x in the metal#x box to tell it that that line isnt the last one and make an IF function that looks for that x in the line below. If it finds it it would add a space to stop the line being surpressed but if not would surpress it as normal. That way, the overall size of the table would only be for the number of entries actually required.

Hope that helps!

Steve
Attached Files
File Type: xlsx demo.xlsx (9.7 KB, 10 views)
Reply With Quote