Quote Originally Posted by bananas View Post
If you have below text in range("A1:A4") (Book2.xlsm) and percentage values in range("F132:F142"), I'm 100% sure.
A1: This is the active workbook(wb1).
A2: Scroll down to row 132 (in this workbook) and there you have the values in Col. F.
A3: Make sure you have wb2 ("Book1") open but this workbook must be active.
A4: I have included the code in this workbook but I normally keep my codes in the "Personal" workbook.
Book2.xlsm only have one sheet ("Sheet1") with this data plus code.
No, that text is NOT in any sheet.