Transfer some particular information to particular column in another sheet

[imran91]

Hi guys

I have this problems: there is 3 sheets (Incoming,control,master). Sheet incoming is the place that my boss will register new orders. In sheet control, I have tables that controls in and out of an items. and every customer only have one table means that if there is 20 customer, there will be 20 same tables in that sheet. if customer A come to order 10 items, all the 10 items will go to the same table. but, for every in and out of an items, it will appear in master sheet. does anyone know how to do this? you guys can look and study a bit about the simple formula i have made at the attachment.

is it clear? because i found it hard to explain. i just try my luck if there is someone here understand my probs..

Thanks

Imran..

[dilipandey]

Hi Imran.

Where you have applied your formula ?
It will be helpful if you can explain the your requirement after transferring the same to excel logics.. like when this matched to that criteria.. this should appear there .. kind of.. I hope you are getting this. thanks.

Regards,
DILIPandey

<click on below 'star' if this helps>

[imran91]

sorry if you confused with my problems..You can see the formulas at the master sheet and at the control sheet (balance and blue rows)..If the 1st customer is B, it will registered as the 1st customer in Incoming sheet and the data will go to B's table. then B order some items again, it will go to the 2nd part in the B's table. Later, A come as 2nd customer and it will registered as 3rd customer in Incoming sheet. The A's items will be go to its own table in the 1st part. And after that, all the data from blue rows in Control sheet will go to the Master sheet.