Formula to pick out, cut and paste
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. |
Formula to pick out, cut and paste
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. |
All times are GMT +1. The time now is 03:03 AM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com