I am preparing to design a new spreadsheet, but I don't know how to achieve
one aspect of it.

I will have a variable number of rows, representing my data records, on the
"worksheet" portion. To each row, an attribute will be added by a user.

If the attribute is X, the entire row should be placed in another location
on a report. if it is Y, it is a different location on that report. Once
those row copy/inserts are completed, there may need to be some more
actions...summing, tidying up the report format based on the numebr of rows,
etc.

Any areas of Excel that can help achieve this, pls let me know.

Thanks in advance,
Tom

My problem is that the starting workset will always have a variable number
of rows...and therefor, a variable number of rows of type X or Y to be
inserted into another location.

I don't know how to automate this process...that is...let the user simply
fill in X or Y for each record and then format all the results properly,
because each instance it is done, there is a different number of rows to act
on. So I cannot figure out how to get a macro to act on this data
consistently, or any other method to do what I need done.

I am trying to find something like "Insert Next" so that once X or Y is
applied, that worksheet row is inserted in the next available row on the
finished report. The ultimate would be that any summing functions, and other
report features, at the "bottom" of that data would also move along with it,
and remain at the bottom, no matter how many rows were inserted.