tweetiemaster
New Member
- Joined
- Aug 2, 2007
- Messages
- 4
i am working on a project that i need excel to extract specific data from one sheet and add it to another sheet based on the value of the cell. for example. one column may have 300 rows of data but i may only need 15-20 rows out of that column depending on what the value is. or to make it simpler if i have 300 apples and some of those apples are labeled as bad apples i only want the bad apples from that column to show on another sheet. i have found an if statment similar to what i was looking for but it would only work on the entire row and not just the column. this particular tab is updated weekly (my raw data tab) each week adds 7 columns to the wooksheet and every other column has different critiera that needs to be met.
i basically need something that would say "if column B is not in the acceptable range then select column A and B and copy it to another worksheet"
Just FYI using Access is not an option for this particular project
i basically need something that would say "if column B is not in the acceptable range then select column A and B and copy it to another worksheet"
Just FYI using Access is not an option for this particular project