Good afternoon all,
i have an extensive list that i am trying to break down to multiple tabs. where row g is item group and row k is city. I would like it to copy to sheet 2 all of the lines in item group 100 for city anytown then copy to sheet 3 all of the lines for group 300 city anytown and so forth. THEN do the same for the rest of the cities. both item groups and cities are variables so i really cant set them as a criteria.
please help
i have an extensive list that i am trying to break down to multiple tabs. where row g is item group and row k is city. I would like it to copy to sheet 2 all of the lines in item group 100 for city anytown then copy to sheet 3 all of the lines for group 300 city anytown and so forth. THEN do the same for the rest of the cities. both item groups and cities are variables so i really cant set them as a criteria.
please help