mangisqa
07-19-2011, 10:36 AM
Hello,
I am trying to move my formulas into VBA so that my large spreadsheet runs faster:
On Sheet Paste Full Report Here in column G i have the following formula:
=IFERROR(VLOOKUP(A5,'Managers-Shifts'!$A$2:$D$999985,4,FALSE),"New Employee")
This continues down to Line 16000. How can I write this in VBA to calculate?
Note: A5 is a variable that changes depending on the row the formula is located.
I am very new to this and learn best by seeing an example and given labels.
Thanks!
Q
I am trying to move my formulas into VBA so that my large spreadsheet runs faster:
On Sheet Paste Full Report Here in column G i have the following formula:
=IFERROR(VLOOKUP(A5,'Managers-Shifts'!$A$2:$D$999985,4,FALSE),"New Employee")
This continues down to Line 16000. How can I write this in VBA to calculate?
Note: A5 is a variable that changes depending on the row the formula is located.
I am very new to this and learn best by seeing an example and given labels.
Thanks!
Q