Using Office 364 version 1802 (Build 9029.2253 Click-to-Run)
I'm using the formula =('Project Info'!A3) when trying to auto-populate data from worksheet 1 into worksheet 2 (both in the same file). I adjust the cell number when pulling from a different cell on the first worksheet. All the other worksheets pull this data as it should. The problem is when I try to use the same formula format for some merged cells near the end of the worksheet, it just copies in the formula itself, not the data from the first page. I know it's not because they are merged, because some of the other cells where it does work are also merged. Any ideas why and a fix? Thank you!
