Delete Columns and rows based on cell fill color

[JackW]

Ok, will try not to be too technical here. I am a locksmith and attempting to write a spreadsheet app. for my line of work. The output page will use columns A-G and rows 1-?10000? depending on the size of the system. If a 5 pin system is requested then columns A+B will be blacked out. 6 pin system A is blacked out. 7 pin system nothing blacked out. Also, if any cell matches the master key that was input, that cell is filled with red. I know, confusing.

Basically, I am trying to remove the blacked out columns automatically, and to remove the enitire row is any cell in that row is filled with red. Then to remove blank lines. Please help, I have been working on this for weeks. I'm not a programmer, just someone trying to make my life a little easier.

Sincerely
Jack W.

[mehmetcik]

Hi Jack

Happy to help you with this.

But you need to post before and after spreadsheets so we can see what you need.

The programming is relatively easy but will involve macros using several for next loops.

[JackW]

[ATTACH]294396[/ATTA

Will this work? I didn't want to attach the file. Its a fairly large spreadsheet.

Basically it will automatically delete the black columns and delete the rows containing red filled cells. Depending on user input, Columns A and/or B could be numbers or could be both blacked out.