Macro to run on all worksheets

[Jam_Ica]

I need to write a macro that will insert a new column (A) and assign a numerical value based on what is in column B. So basically it should check all worksheets and where ever it sees the word t-shirt in column B it should insert a 1. I then new a new worksheet created at the end that will go through and pull the number from coulmn G for anywhere that had the 1 insrted in column A. I hope this makes sense. It is for inventory purposes and we use excel. Each worksheet is a different stand and we need to be able to pull in the number of each item sold between all of the stands. Any help would be awsome! I part to insert a column and inser a number based on what is in the coumn I dont think will be to bad its the getting the macro to work for the whole workbook and the final page with the totals.

 

[Manohar M G]

hi,

Can you explain with example

 

[Jam_Ica]

Hopefully that pic worked if not here is the link
http://twitter.com/#!/JAM_ica/status/104569703757914114/photo/1

So basically I have a workbook with about 20 differnet sheets set up this same way only there are different items in each stand. Some stands have the same items. I have created a master key type of thing of all the sheets so that i have all of the different products. What I am trying to do is insert a coulmn infront of what is currently coulmn A and do a vlookup to the key I made so that they are number coded. I wanted to write a macro that would do this to all sheets in the workwook. Then after that is done add a new sheets at the end that would lookup all of the numbers that were placed in coulmn A pull in all amounts that are total coulmn. So it would would pull in all totals for the item with #6 in coulmn A and add them together.