cybermatrix
New Member
- Joined
- Jun 2, 2010
- Messages
- 37
I need a macro to build a spread sheet based on values from another spreadsheet.
Basically I need it to look for a value in a suppliers spreadsheet and if that row contains the value then add that value to the new spreadsheet in a column.
Example a supplier description for a product has 100% cotton and I need the value 100% cotton put in a column titled Material in the new spreadsheet. There are hundreds of values to look for. So I was thinking about having a column with all the values in a sheet as to what to look for.
I'm open for suggestions as to how to make this happen.
Basically I need it to look for a value in a suppliers spreadsheet and if that row contains the value then add that value to the new spreadsheet in a column.
Example a supplier description for a product has 100% cotton and I need the value 100% cotton put in a column titled Material in the new spreadsheet. There are hundreds of values to look for. So I was thinking about having a column with all the values in a sheet as to what to look for.
I'm open for suggestions as to how to make this happen.
