i have a sheet
a b c d
ph jp phone shoes 5
st jp phone shoes 7
ma jp phone shoes 4
ph sr store shoes 6
st sr store shoes 7
ma sr store shoes 8
column a tells me were there order was made
column b is the salesman name
column c tells me their dept.
d the amount sold.
(in reality the list has about 200 rows and 5 more columns of numbers
i need to have a code that tells it to look in column c and if the word phone is in the cell then to add the # in the row of "ma" to the row with "Ph"
(ph stands for phone, st = store, and ma=mail)
the idea is that a phone person might have worked in the store so those numbers are different. but the ma should be added to their normal position ie. phones or store.
this is very lenghty so please feel free to ask any q i need help
my boss wants this yesterday
a b c d
ph jp phone shoes 5
st jp phone shoes 7
ma jp phone shoes 4
ph sr store shoes 6
st sr store shoes 7
ma sr store shoes 8
column a tells me were there order was made
column b is the salesman name
column c tells me their dept.
d the amount sold.
(in reality the list has about 200 rows and 5 more columns of numbers
i need to have a code that tells it to look in column c and if the word phone is in the cell then to add the # in the row of "ma" to the row with "Ph"
(ph stands for phone, st = store, and ma=mail)
the idea is that a phone person might have worked in the store so those numbers are different. but the ma should be added to their normal position ie. phones or store.
this is very lenghty so please feel free to ask any q i need help
my boss wants this yesterday