Extracting data from 2 columns and putting the data in one cell in another worksheet. Those 2 collums come from 12 worksheets.

[xpost]

[/xpost]

What i want to do is:

1. In column D over 12 worksheets i have the words or description of : resale, Labor, utility. depending on what is said the items was.

2. In column E I have a dollar amount listed in those 12 worksheets.

3. There are 15 worksheets in this workbook named ( Jan-Dec, Year to date, option page, New equip repairs)

4. What i want to do is with this information i gave you is: I want to search thru column D of all 12 worksheets and extract the word resale and in column E i want to extract the dollar amount that is connected with the word resale.

5. Then i want to to add all the amounts that are associated with resale over all 12 months and put them in A45 cell on the worksheet named "Year to date".

The problem is i don't know if i use a VLOOKUP formula or i use some sort of macro. I'm just kind of lost on this one.



Dennis

posted also: https://www.mrexcel.com/board/…om-12-worksheets.1161876/

That wont work for this situation. what i really have is a column on each 12 months that has different sale descriptions in it like ( resale, insurence, supplies) and and a column that has the amount for each of the previous mentioned items. I want to filter out all that says resale and all the totals amounts for resale in the other column and add the amounts up and place that total in a cell on another worksheet . Tried to explain that to the best of my ability. Not sure how to do that.

Dennis

Roy

Im attaching a example of my workbook. It is kinda brief but i think you will get the pic of what im wanting. I want all the resale items for each month that is listed to be filtered out show up as a total on the YTD sheet. Cell C48.

I only want the total amout to show up on YTD page Cell C48.

Thanks

Roy,

I dont think you understand what i want. I want Cell C48 on YTD sheet to have the amount that is in collum E added up AFTER you filter out retail in Coullum D.

So another words only show in cell C48 that have retail in collum D out for the 12 months and show the amount added up of Colum E for the 12 months.

Roy ,did you get my last message? I really need some help with this.