I have values that are subtotaled in different cells throughout Sheet 1 (E11, E21, E24, E27, E34, etc) for 41 towns. Sheet 2 is a summary of just the 41 towns. I want my Sheet 1 (E11) data to appear in Sheet 2 (B2), Sheet 1 (E21) to appear in Sheet 2 (B3), Sheet 1 (E24) to appear in Sheet 2 (B4), Sheet 1 (E27) to appear in Sheet 2 (B5), Sheet 1 (E34) to appear in Sheet 2 (B6), etc.
Bookmarks