Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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. |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
FORMULA TO PICK NUMBER | Excel Worksheet Functions | |||
how do I write a formula to pick a date or N/A? | Excel Worksheet Functions | |||
I need to use a formula to pick up a value by the font color? | Excel Discussion (Misc queries) | |||
Array Formula to Pick Average | Excel Discussion (Misc queries) | |||
Formula to pick out number values | Excel Worksheet Functions |