antonyjones1
02-04-2012, 12:15 AM
Hi all,
I was wnodering if someone could help me with a simple macro I need to put together.
I need to put together a macro that will search the first worksheet in excel for all entries in column "Name" that don't contain the character *. If it comes across a row with no * in it I then want it to Search column "description" to ensure that this Name has "Jam" as well as "Toast". If only toast and no Jam is being received I want it to check if this name has "Butter". If the name is receiving butter I want it to populate a second worksheet with the "number","Name" and a "notes" column. The number field is the number from sheet 1 the name field is the name from sheet 1 and the entry in notes is "no jame but butter". If no butter or Jam is being received then I want it to pull the name,number and then in notes say "toast only". I also want it to check for multiple instances of jam. So If there are 3 rows with the same name having jam I want it to populate the new sheet with name,number and under notes say "3 lots of jam".
I have attached a spreadsheet with data in sheet 1 and the results i'm looking to achieve in sheet 2. Thanks in advance for all help!
I was wnodering if someone could help me with a simple macro I need to put together.
I need to put together a macro that will search the first worksheet in excel for all entries in column "Name" that don't contain the character *. If it comes across a row with no * in it I then want it to Search column "description" to ensure that this Name has "Jam" as well as "Toast". If only toast and no Jam is being received I want it to check if this name has "Butter". If the name is receiving butter I want it to populate a second worksheet with the "number","Name" and a "notes" column. The number field is the number from sheet 1 the name field is the name from sheet 1 and the entry in notes is "no jame but butter". If no butter or Jam is being received then I want it to pull the name,number and then in notes say "toast only". I also want it to check for multiple instances of jam. So If there are 3 rows with the same name having jam I want it to populate the new sheet with name,number and under notes say "3 lots of jam".
I have attached a spreadsheet with data in sheet 1 and the results i'm looking to achieve in sheet 2. Thanks in advance for all help!