I have a worksheet that will have variable numbers of data row entries, and
variable numbers of columns depending on entries chosen in the first two
columns. I want to group those rows in different sections of another
worksheet, based on the type of entry.

I'm not sure if I'm explaining it very well. This is an expense report
list. I would like the user to be able to enter each expense and have the
second worksheet group by personal or company charge, then sum the costs of
each. The entry worksheet has the following columns:
Col A: Personal or Company Charge - drop-down list, 2 choices
Col B: Type - drop-down list, 5 choices
Col C: Cost
Col D: Label based on type chosen (If "Personal Auto", Col D says "# Miles")
Col E: Data entry (depending on Col D label)
Col F: Label based on type chosen (blank for 1 "type")
Col G: Data entry (depending on Col F label)
Col H: Label based on type chosen (blank for 3 "types")
Col I: Data entry (depending on Col H label)

On the second worksheet, I want to list the personal charge rows by type in
one area, and the company charges by type in a different area. I thought I
had it for a minute, using nesting IF statements, but I don't know how to say
"get the next one if the first one has already been listed". Is this doable,
or am I going about this the wrong way?

Thanks for any help or suggestions!