NewOrderFac33
Well-known Member
- Joined
- Sep 26, 2011
- Messages
- 1,275
- Office Version
- 2016
- 2010
- Platform
- Windows
Good afternoon, I have two identically structured worksheets in the same workbook and I want to import the values from each cell in Sheet 2 to the corresponding cell in Sheet 1. The reason I want to do it programmatically, as against simply copying and pasting is that I then need to add some additional logic into the updating so that not ALL values are necessarily updated. I've figured how to do it within a nested loop, but it's taking ages. Essentially, it's For Each Cell in Sheet1.MyRange, import the value from the corresponding cell in Sheet2.
Any quick solutions out there, please?
Thanks - Pete
Any quick solutions out there, please?
Thanks - Pete