Mirror 2 cells across 2 worksheets
I'm creating 2 different request forms on different worksheets of the same workbook. There are common cells across the 2 forms and I prefer that people do not have to complete the same information twice. I want them to complete NAME on either sheet and have the other auto-populate. The either part is important so if they go to Sheet 2 and complete NAME, the same cell in Sheet 1 is populated. Appreciate solutions!
|