possible tricky [well for me anyway]
Part1: say I have
a1= 50
a2=300
How could I write a [button] macro that when run would take any cell from a defined range. in this case cells to E1 an added them together so that E1=350.
Part2: would be to determine what cell it goes to base on a value in B1.
so that if
B1 =1 then E1 if
B1 =2 then E2 etc....
Part3: [If possible] If the macro was repeated with the new values they would be added to the total already in E1, ie if a1=60, then E1=410 [350+60]
The purpose is that depending on a line number [B1] send the costs of items to the right department.
hope someone can throw me a bone on this one. Cheers
Part1: say I have
a1= 50
a2=300
How could I write a [button] macro that when run would take any cell from a defined range. in this case cells to E1 an added them together so that E1=350.
Part2: would be to determine what cell it goes to base on a value in B1.
so that if
B1 =1 then E1 if
B1 =2 then E2 etc....
Part3: [If possible] If the macro was repeated with the new values they would be added to the total already in E1, ie if a1=60, then E1=410 [350+60]
The purpose is that depending on a line number [B1] send the costs of items to the right department.
hope someone can throw me a bone on this one. Cheers