I need to search a column of data for a specific text and if it finds my string on that row take three pieces of data on the same row but different column and populate them onto a seperate sheet on the same spreadsheet.
Here is my example:
A5 B5 B6 B7 B8 B9
Beef Blue Ribbon Beef BRB $5.00 2.00% Best Quality
Good Beef Jerky JER $6.50 25.00% Med Quality
Beef Ground Beef GB $2.51 50.00% Low Quality
Mixed Hotdogs HOT $1.25 1.00% Mixed/Meat
My example didn't format well, but basically in Column A is a type, Column B is the name, Column C is a abreviation, Column D is a price, Column D is a percent and Column F is a quality.
I need to search by column F for the quality and if it is Best place the name for the meat in Sheet2 under Column B under Title "Best" and then in column B place the abreviation, column C the price, column D the percent. Then repeat and look for another quality doing the same.
Help?
2007-03-08
15:13:08
·
5 answers
·
asked by
Gidgit
1
in
Programming & Design