Searching for values and the adding other values
Posted by Ben on December 15, 2000 2:29 PM
How do I create a macro that searches in Column B of Sheet 2 for the value in cell J2 on Sheet 1 and when if finds it, it adds the value in cell M2 of Sheet 1 to cell D on Sheet 2 if it is January and cell E if it is February and so on until December.
Then it needs to search for the value of J2 in Column B of Sheet 3 and when it finds it, it subtracts the value in cell J2 on Sheet 1 from cell D on the same row as the value it has found, on Sheet 3.
Also, it needs to be a number not a formula such as =10-2-2-4