I WANT TO CONVERT ALL VLOOKUPS IN WORKSHEET TO THERE RETURN VALUES BUT ALSO LEAVE IN THE MATH OPERATORS
FOR EXAMPLE SAY CELL C12 IS ADDING 2 VLOOKUPS + I WANT A MACRO TO HAVE C12 READ =1125+100 NOT PASTE VALUE OF =1225
I want to run a macro that will take out the vlookups but leave the individual numbers that add or subtract so Cell C12 will be 1225 when viewing but if you click within cell C12 it will be =1125+100
Below is an example with numbers.
THE FORMULA IN C12 READS =VLOOKUP("120-00-0000",A:C,3,FALSE)+VLOOKUP("210-00-0000",A:C,3,FALSE)
THE FORMULA IN C13 READS =VLOOKUP("120-00-0000",A:C,3,FALSE)-VLOOKUP("210-00-0000",A:C,3,FALSE)
THE FORMULA IN C14 READS =VLOOKUP("120-00-0000",A:C,3,FALSE)/VLOOKUP("210-00-0000",A:C,3,FALSE)
THE FORMULA IN C15 READS =VLOOKUP("120-00-0000",A:C,3,FALSE)*VLOOKUP("210-00-0000",A:C,3,FALSE)
I WANT A MACRO TO CONVERT THE CELL C12=VLOOKUP("120-00-0000",B:D,3,FALSE)+VLOOKUP("210-00-0000",B:D,3,FALSE) TO =1125+100 BUT NOT PASTE VALUE OF 1225
I WANT A MACRO TO CONVERT THE CELL C13=VLOOKUP("120-00-0000",B:D,3,FALSE)-VLOOKUP("210-00-0000",B:D,3,FALSE) TO =1125-100 BUT NOT PASTE VALUE OF 1025
I WANT A MACRO TO CONVERT THE CELL C14=VLOOKUP("120-00-0000",B:D,3,FALSE)/VLOOKUP("210-00-0000",B:D,3,FALSE) TO =1125/100 BUT NOT PASTE VALUE OF 11.25
I WANT A MACRO TO CONVERT THE CELL C15=VLOOKUP("120-00-0000",B:D,3,FALSE)*VLOOKUP("210-00-0000",B:D,3,FALSE) TO =1125*100 BUT NOT PASTE VALUE OF 112500
ROW/COL A B C
1 ACCOUNT NUMBER ACCOUNT TITLE Balance
2 104-61-0000 CASH 5,000.00
3 120-00-0000 ACCOUNTS RECEIVABLE-A 1,125.00
4 120-02-0000 ACCOUNTS RECEIVABLE-B 3,120.00
5 120-26-0000 ACCOUNTS RECEIVABLE-C 400.00
6 210-00-0000 ACCOUNTS PAYABLE-A 250.00
7 210-02-0000 ACCOUNTS PAYABLE-B 450.00
8 210-06-0000 ACCOUNTS PAYABLE-C 100.00
9 237-01-0000 ACCRUED LIABILITIES-A 125.00
10 237-03-0000 ACCRUED LIABILITIES-B 320.00
11
12 1,225.00
13 1,025.00
14 11.25
15 112,500.00
Bookmarks