I am importing data from a SQL query with 7 columns and a variable number of
rows. One of the columns is "Type". There are 3 possible types: Requirement,
Enhancement and Defect. With the first two types, I would like the row height
to be large so that I can see all the information in the cells for a given
row (i.e., I don't want anything truncated). However to cut down on the size
of the spreadsheet, I would like to adjust every row that is under type
"defect" to be smaller (say row height = 30).

I can't figure out how to do this. Any help would be very much appreciated.
If the solution involves a macro or some VB script, please act like you're
talking to a toddler because I do have a little experience with VB but zero
experience with using VB in Excel. Thanks for any assistance.