| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
How to move data to another worksheet depending on the criteria
Hi. Is there a way to list, on a separate sheet in the same workbook, only
rows of data with a value in a specific column? I want to list closed leads and all data in that row) as long as there is a specific value of 100 or 0 in column F. If there is a different value in column F for that lead, then I don't want it to appear on this list. Is there a way to do this with a formula and not a pivot table and automatically instead of filtering? Ideally, I would like it to add the row to the bottom of the list. For example, my colums are (A-I):- Opportunity ID, Reminder Call, Customer Name, Opportunity, Sales Stage, Probability, First Name, Last Name and Received Date Thanks |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
How to move data to another worksheet depending on the criteria
Harwookf,
Take a look at Data - Filter - Advanced filter. It will do exactly as you have asked. You have to set up a criteria range somewhere on the sheet. Or you can use Autofilter, then copy/paste the stuff. -- Earl Kiosterud www.smokeylake.com Note: Top-posting has been the norm here. Some folks prefer bottom-posting. But if you bottom-post to a reply that's already top-posted, the thread gets messy. When in Rome... ----------------------------------------------------------------------- "harwookf" wrote in message ... Hi. Is there a way to list, on a separate sheet in the same workbook, only rows of data with a value in a specific column? I want to list closed leads and all data in that row) as long as there is a specific value of 100 or 0 in column F. If there is a different value in column F for that lead, then I don't want it to appear on this list. Is there a way to do this with a formula and not a pivot table and automatically instead of filtering? Ideally, I would like it to add the row to the bottom of the list. For example, my colums are (A-I):- Opportunity ID, Reminder Call, Customer Name, Opportunity, Sales Stage, Probability, First Name, Last Name and Received Date Thanks |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
How to move data to another worksheet depending on the criteria
I just noticed that you don't want a manual process like filtering. So never mind. It
might be do-able with formulas, but it may be messy. A macro might be the only way. -- Earl Kiosterud www.smokeylake.com Note: Top-posting has been the norm here. Some folks prefer bottom-posting. But if you bottom-post to a reply that's already top-posted, the thread gets messy. When in Rome... ----------------------------------------------------------------------- "Earl Kiosterud" wrote in message ... Harwookf, Take a look at Data - Filter - Advanced filter. It will do exactly as you have asked. You have to set up a criteria range somewhere on the sheet. Or you can use Autofilter, then copy/paste the stuff. -- Earl Kiosterud www.smokeylake.com Note: Top-posting has been the norm here. Some folks prefer bottom-posting. But if you bottom-post to a reply that's already top-posted, the thread gets messy. When in Rome... ----------------------------------------------------------------------- "harwookf" wrote in message ... Hi. Is there a way to list, on a separate sheet in the same workbook, only rows of data with a value in a specific column? I want to list closed leads and all data in that row) as long as there is a specific value of 100 or 0 in column F. If there is a different value in column F for that lead, then I don't want it to appear on this list. Is there a way to do this with a formula and not a pivot table and automatically instead of filtering? Ideally, I would like it to add the row to the bottom of the list. For example, my colums are (A-I):- Opportunity ID, Reminder Call, Customer Name, Opportunity, Sales Stage, Probability, First Name, Last Name and Received Date Thanks |
|
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
How to move data to another worksheet depending on the criteri
OK thanks. I'll try the advanced filter and macro and see how that goes.
"Earl Kiosterud" wrote: I just noticed that you don't want a manual process like filtering. So never mind. It might be do-able with formulas, but it may be messy. A macro might be the only way. -- Earl Kiosterud www.smokeylake.com Note: Top-posting has been the norm here. Some folks prefer bottom-posting. But if you bottom-post to a reply that's already top-posted, the thread gets messy. When in Rome... ----------------------------------------------------------------------- "Earl Kiosterud" wrote in message ... Harwookf, Take a look at Data - Filter - Advanced filter. It will do exactly as you have asked. You have to set up a criteria range somewhere on the sheet. Or you can use Autofilter, then copy/paste the stuff. -- Earl Kiosterud www.smokeylake.com Note: Top-posting has been the norm here. Some folks prefer bottom-posting. But if you bottom-post to a reply that's already top-posted, the thread gets messy. When in Rome... ----------------------------------------------------------------------- "harwookf" wrote in message ... Hi. Is there a way to list, on a separate sheet in the same workbook, only rows of data with a value in a specific column? I want to list closed leads and all data in that row) as long as there is a specific value of 100 or 0 in column F. If there is a different value in column F for that lead, then I don't want it to appear on this list. Is there a way to do this with a formula and not a pivot table and automatically instead of filtering? Ideally, I would like it to add the row to the bottom of the list. For example, my colums are (A-I):- Opportunity ID, Reminder Call, Customer Name, Opportunity, Sales Stage, Probability, First Name, Last Name and Received Date Thanks |
|
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
How to move data to another worksheet depending on the criteri
I've just posted a simple, non-array formulas play in your identical posting
in .worksheet.functions. Pl refrain from multi-posting. -- Max Singapore http://savefile.com/projects/236895 xdemechanik --- |
|
#6
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
How to move data to another worksheet depending on the criteri
Apologies for the duplication.
"Max" wrote: I've just posted a simple, non-array formulas play in your identical posting in .worksheet.functions. Pl refrain from multi-posting. -- Max Singapore http://savefile.com/projects/236895 xdemechanik --- |
|
#7
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
How to move data to another worksheet depending on the criteri
Would you be able to provide the formula that you posted? I have searched
for the other post unsuccessfully. "Max" wrote: I've just posted a simple, non-array formulas play in your identical posting in .worksheet.functions. Pl refrain from multi-posting. -- Max Singapore http://savefile.com/projects/236895 xdemechanik --- |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| move data to another sheet depending on criteria | Excel Worksheet Functions | |||
| Populate, Depending on Criteria | Excel Discussion (Misc queries) | |||
| Auto copy down depending on criteria | Excel Worksheet Functions | |||
| Delete row depending on criteria | Excel Discussion (Misc queries) | |||
| Adding sales depending on 2 Criteria | Excel Worksheet Functions | |||
Hybrid Mode
