A formula doesn't "cut and paste", period. You can try the Advanced
Filter feature, which can copy data to a new location, have formulae
that match specific data based on criteria (depending on the nature of
the criteria), or use VBA to perform the copy/paste operations
automatically.


On Nov 28, 3:21 pm, sm wrote:
Is there one formula within a range of data to:

pick out from the data, based on certain conditons, items that fill the
conditions and to cut and paste those items to another area of the
spreadsheet, and at the same time have other data filling other conditions
cut and pasted to another area of the worksheet, etc.?

Thank you in advance.