Thank you oeldere! Much appreciate!
Could you please explain the syntax behind the formula? I'm having trouble applying the formula for the other months. For instance, how would the formula change to do the same thing for the February and March data?
I'm assuming the &B$2& is grabbing the sheet name from the top of the column, but what does the Char(63+Row())&"2" do? I've also never seen the "&" used in formulas before. Could you please explain that as well?
Thanks again!
Bookmarks