JOSTERBAUER
Board Regular
- Joined
- Jan 17, 2005
- Messages
- 101
How do I start to write this macro. I want to accomplish this. I want to take the numbers in H93:H140 on sheet 1, and add it into another woorkbook (Variance report) in a different location. I want that bank of number to grab the same amount of cells in Variance report workbook, and add them to it.
ex there is qty of 2 in cell h:93 on sheet 1 and it will grab the first cell in the bank on Variance report that has a qty of 3, and add the qty of 2 to say it know has a qty of (5)
I need help on getting this written.
ex there is qty of 2 in cell h:93 on sheet 1 and it will grab the first cell in the bank on Variance report that has a qty of 3, and add the qty of 2 to say it know has a qty of (5)
I need help on getting this written.