cool0masty2
New Member
- Joined
- Oct 11, 2013
- Messages
- 20
I have 2 sheets... both have tables...
One have Item Names in one column and Remaining Qty in the next column...
the Other have Items Names is one column and Qty Sold in the next column...
I want both this tables to get attached with each other in a way that when I put item name in the first sheet and put some qty in it, it deducts the same value from the other sheet..
In easy words...
Its
One is Stock Sheet.
Second is Sales Sheet.
I have
Laptops in Stock Sheet i.e.
[TABLE="class: grid, width: 500, align: left"]
<tbody>[TR]
[TD]HP Laptop[/TD]
[TD]2[/TD]
[/TR]
[TR]
[TD]DELL Laptop[/TD]
[TD]4[/TD]
[/TR]
[TR]
[TD]Toshiba Laptop[/TD]
[TD]7[/TD]
[/TR]
</tbody>[/TABLE]
I have
Same data in Sales Sheet.
[TABLE="class: grid, width: 500, align: left"]
<tbody>[TR]
[TD]HP Laptop[/TD]
[TD]1[/TD]
[/TR]
[TR]
[TD]DELL Laptop[/TD]
[TD]4[/TD]
[/TR]
[TR]
[TD]Toshiba Laptop[/TD]
[TD]3[/TD]
[/TR]
</tbody>[/TABLE]
I want
Stock Sheet
to become this...
[TABLE="class: grid, width: 500, align: left"]
<tbody>[TR]
[TD]HP Laptop[/TD]
[TD]1[/TD]
[/TR]
[TR]
[TD]DELL Laptop[/TD]
[TD]0[/TD]
[/TR]
[TR]
[TD]Toshiba Laptop[/TD]
[TD]4[/TD]
[/TR]
</tbody>[/TABLE]
Please Help ?
One have Item Names in one column and Remaining Qty in the next column...
the Other have Items Names is one column and Qty Sold in the next column...
I want both this tables to get attached with each other in a way that when I put item name in the first sheet and put some qty in it, it deducts the same value from the other sheet..
In easy words...
Its
One is Stock Sheet.
Second is Sales Sheet.
I have
Laptops in Stock Sheet i.e.
[TABLE="class: grid, width: 500, align: left"]
<tbody>[TR]
[TD]HP Laptop[/TD]
[TD]2[/TD]
[/TR]
[TR]
[TD]DELL Laptop[/TD]
[TD]4[/TD]
[/TR]
[TR]
[TD]Toshiba Laptop[/TD]
[TD]7[/TD]
[/TR]
</tbody>[/TABLE]
I have
Same data in Sales Sheet.
[TABLE="class: grid, width: 500, align: left"]
<tbody>[TR]
[TD]HP Laptop[/TD]
[TD]1[/TD]
[/TR]
[TR]
[TD]DELL Laptop[/TD]
[TD]4[/TD]
[/TR]
[TR]
[TD]Toshiba Laptop[/TD]
[TD]3[/TD]
[/TR]
</tbody>[/TABLE]
I want
Stock Sheet
to become this...
[TABLE="class: grid, width: 500, align: left"]
<tbody>[TR]
[TD]HP Laptop[/TD]
[TD]1[/TD]
[/TR]
[TR]
[TD]DELL Laptop[/TD]
[TD]0[/TD]
[/TR]
[TR]
[TD]Toshiba Laptop[/TD]
[TD]4[/TD]
[/TR]
</tbody>[/TABLE]
Please Help ?