Forum Discussion
Trisa58
Oct 02, 2019Copper Contributor
How to use PrevSheet
I have a workbook that has weekly check register tabs. In the attached sample file I want cell H1 on Sheet 2 to pull the value in cell B1 of Sheet 1, with the hope that as I copy sheet 2 to sheet 3,...
PascalKTeam
Oct 09, 2019Iron Contributor
Hi
your VBA code is not correct but I've tried to set this up and it seems to work. Solutions in this https://kteamch-my.sharepoint.com/:x:/g/personal/pascal_kiefer_kteam_ch/EW8SX9eraLVGiab4yzyFvKMBaRRnL10ZWmaB5nT-Z9D9ow?e=ABDHfG&Download=1
let me know if this worked for you