daleholden
Board Regular
- Joined
- Sep 22, 2002
- Messages
- 243
Hi Guys
I have a sheet called DropShip with stock data in it
A1 SKU
F1 Total Cost
J1 Sale Price
I1 Stock Drop Down List
Located on separate sheet AllFees W1:W8
[TABLE="width: 188"]
<tbody>[TR]
[TD]In Stock -Listed
[/TD]
[/TR]
[TR]
[TD]In Stock -Stopped
[/TD]
[/TR]
[TR]
[TD]Out of Stock - Listed
[/TD]
[/TR]
[TR]
[TD]Out of Stock - Stopped
[/TD]
[/TR]
[TR]
[TD]Out of Stock - Removed
[/TD]
[/TR]
[TR]
[TD]Discontinued - Stopped
[/TD]
[/TR]
[TR]
[TD]Discontinued - Removed
[/TD]
[/TR]
[TR]
[TD]Back Order - Stopped
[/TD]
[/TR]
[TR]
[TD]Back Order - Removed
[/TD]
[/TR]
</tbody>[/TABLE]
Live data sheet from suppler called New Data
A1 SKU
G1 Total Cost
H1 Sale Price
I1 Report =In Stock, Out of Stock, No Longer Listed
I need a solution to for everytime I update / refresh data on NewData sheet the prices are checked against the Sku and the prices updated to the new values in F1 & J1. Also check stock level
If it report In Stock do nothing
If it report Out of Stock update to show ‘Out of Stock – Stopped’
If it reports No Longer Listed to show ‘Discontinued – Stopped’
Please note DropShip is an Excel table and wil grow
NewData not a table but grows as well
Please can you tell me if it is possible and how can i complete it
Cheers Dale
I have a sheet called DropShip with stock data in it
A1 SKU
F1 Total Cost
J1 Sale Price
I1 Stock Drop Down List
Located on separate sheet AllFees W1:W8
[TABLE="width: 188"]
<tbody>[TR]
[TD]In Stock -Listed
[/TD]
[/TR]
[TR]
[TD]In Stock -Stopped
[/TD]
[/TR]
[TR]
[TD]Out of Stock - Listed
[/TD]
[/TR]
[TR]
[TD]Out of Stock - Stopped
[/TD]
[/TR]
[TR]
[TD]Out of Stock - Removed
[/TD]
[/TR]
[TR]
[TD]Discontinued - Stopped
[/TD]
[/TR]
[TR]
[TD]Discontinued - Removed
[/TD]
[/TR]
[TR]
[TD]Back Order - Stopped
[/TD]
[/TR]
[TR]
[TD]Back Order - Removed
[/TD]
[/TR]
</tbody>[/TABLE]
Live data sheet from suppler called New Data
A1 SKU
G1 Total Cost
H1 Sale Price
I1 Report =In Stock, Out of Stock, No Longer Listed
I need a solution to for everytime I update / refresh data on NewData sheet the prices are checked against the Sku and the prices updated to the new values in F1 & J1. Also check stock level
If it report In Stock do nothing
If it report Out of Stock update to show ‘Out of Stock – Stopped’
If it reports No Longer Listed to show ‘Discontinued – Stopped’
Please note DropShip is an Excel table and wil grow
NewData not a table but grows as well
Please can you tell me if it is possible and how can i complete it
Cheers Dale