Hello,
Excel 2007, Windows 7
I have a worksheet I've been assigned to automate for work. Essentially I'm creating it in order to eliminate human error; and cut the users time of data entry in half (possibly).
Currently I'm working on a Vlookup formula that works great! but I quickly came to the realization that when inserting a new row; formulas don't copy from the other cells. I can't place the vlookup formula in every cell of the column because they insert new rows pretty frequently
Is there any way I can fix this issue? I'm just starting to learn macro/vba and I'm pretty sure that may be the way to go, but I have no clue where to begin.
Excel 2007, Windows 7
I have a worksheet I've been assigned to automate for work. Essentially I'm creating it in order to eliminate human error; and cut the users time of data entry in half (possibly).
Currently I'm working on a Vlookup formula that works great! but I quickly came to the realization that when inserting a new row; formulas don't copy from the other cells. I can't place the vlookup formula in every cell of the column because they insert new rows pretty frequently
Is there any way I can fix this issue? I'm just starting to learn macro/vba and I'm pretty sure that may be the way to go, but I have no clue where to begin.