Copy data from one worksheet and paste into another in the right column

[suryab]

Hi all,

I have data that I want to copy are in the following format and they can change. I receive this information in many files on a daily basis which I need to copy to another file.

Fruit_Type Qty
Apple 5
Orange 4
Kiwi 3

and the destination worksheet data columns are in the following format where I want to paste the fruit quantity in the right column:

Apple Banana Pear Orange Kiwi Blueberry

I would appreciate some idea on how I can copy the fruit quantity into right columns using a macro.

Many thanks in advance.

Regards,
Surya

[berlan]

If the input data is in Columns A and B in Sheet1, then in the output sheet, try:

A2: =SUMIF(Sheet1!$A:$A,A$1,Sheet1!$B:$B)

and copy to the right.

Row\Col	A	B	C	D	E	F
1	Apple	Banana	Pear	Orange	Kiwi	Blueberry
2	=SUMIF(Sheet1!$A:$A,A$1,Sheet1!$B:$B)	0	0	4	3	0

[suryab]

Hi Berlan,

Many thanks. And my apology as my post was not very clear. I have edited it now. Appreciate your thoughts.