My workbook uses both vlookup (price lists) and macros that update a log when I run it.
For example, cost of item A is $10 currently. Using vlookup, prices from the price sheet are entered automatically on a sales sheet. I run the macro that takes that sale info and copies parts of the row to...