Being new to vba, I have written the following code which copies a formula into a cell. Although this works, it is extreamly slow being I repeat this for several other values.
This formula concatenates the SO_number & Full Item that is in column K of the current sheet and looks for the resulting value in the SO sheet by concatenating column B and E.
the SO sheet contains information from Sales Orders. Sheet1 is the final product that contains information from other sheets (POs for example) and related information from the SO sheet.
Here is some sample data:
SO
Sheet1
I would like to replace the formula with vba code that finds the row with the desired information and then use the Row number for the other values that I need. This way, I am only looking up the data once per row and the final sheet only contains the values (rather than the formulas).
Any guidance would be appreciated.
Thanks
Bookmarks