Hello All,
I'm not a programmer, so I'm looking forward to a spot on response.
I want to know if there is a macro that will effectively find VLOOKUP formulas in a tab and copy/paste/values - leaving all other formulas/cells unscathed.
For example, if there were subtotal rows, summing up information from VLOOKUPs all throughout the tab, would anyone have a macro that could find the VLOOKUPs and paste the value of it within the cell that the formula is currently within.
- Church
Bookmarks