take number value in column B if adjacent text value in column A equals "XXXX"

[PowerpointRanger]

As a small business owner I am bound to my point of sales (POS) software and sometimes its limitations. My POS will generate monthly reports that show each of my business's department sales. For example, JANUARY department sales report will be;

January:
Greeting Cards: $323
Impulse buys: $113
Boxes: $300
Mailbox Rent: $2,000
etc

However if a department has zero sales then that department is left off of the list.

February
Greeting Cards: $112
Boxes: $515
Mailbox rent: $2,500
etc

Therefore when I try and create a workbook on a separate tab that graphs and adds up all the departments I cannot simply say Department Boxes sales = cell B2 every time.

I need a macro that searches the entire first column to find a certain department "boxes" and will then populate the numeric value of sales in that department one column to the right.

looking for something that says "if [boxes] is cell A2 then show value in cell B2"

 

[jtakw]

Hi,

I may not have understood you completely, but I think you may not need VBA/macro to accomplish what you need, if your setup is similar to my sample, and you can create a list of all your products in Sheet 2, then using VLOOKUP may do what you need:

Excel 2010
	A	B
1	January:
2	Greeting Cards:	$323
3	Impulse buys:	$113
4	Boxes:	$300
5	Mailbox Rent:	$2,000
Sheet1

Excel 2010
	A	B
1	Departments	Sales
2	Greeting Cards:	$323
3	Packing materials:	$0
4	Impulse buys:	$113
5	Stationery:	$0
6	Stuff:	$0
7	Boxes:	$300
8	Other stuff:	$0
9	Mailbox Rent:	$2,000
Sheet2

Cell Formulas
Range	Formula
B2	=IFERROR(VLOOKUP(A2,Sheet1!A$2:B$12,2,0),0)

Sheet 2 B2 formula copied down.

If this is not what you mean, please provide some sample data and expected results.