updating multiple cells when 1 cell is filled with data from second worksheet

Hi,

was wondering what i need to do in excel to get this working:

i have two worksheets
1. is a transaction table
2. is a stock table

now i have got the stock items names into a drop down list on the transaction table and what i want it to do is when i enter a item on the transaction table from the drop down i want it to enter the price of the item which is part of the stock list

the items name starts in cell A2 and the price cell that i want updated start in H2 on the transaction list

the items name start in cell B2 and the price cell that holds the price value start on I2 in the stock table

any help would be much appreciated and i hope i have explained that well enough

cheers

Hi,

I have been looking at Index and Match functions, and i can't seem to get one working over the 2 worksheets

Can someone please give a bit more information on this, maybe even an example one

Cheers

Hi, i have attached a example spread sheet with what i want to do.

hopefully it will help you guys to help me

Example Stock Sheet.xlsx

Hi Guys,

I have figured out part of the stock level part of my problem by moving the ID column over and setting the A Cells as the Item names and using a vlookup to get the total stock level, now i just need to figure out the adjustment part

you guys got any clues on how to do this??

Hey,

I dont know if this will help anyone answer my question but this is basically a worded if statement that should cover the stock level bit,

if (transaction type set to sold minus stock level of number in quantity to actual stock level)
elseif (transaction type set to Into Stock add stock level of number in quantity to actual stock level)
elseif (transaction type set to Shrinkage minus stock level of number in quantity to actual stock level)

all i need to know now is how i can implement that into excel, if anyone could answer this i would be most grateful

cheers

Hey Guys,

Using the same methods as i did to get the actual stock level i have completed the pricing issue i was having, still cant get the stock adjustment bit working and i really need this as i need to be implementing it asap