Is there some way to "lock" a cell into it's place on sheet so that it will permanently stay in that position across all the other sheets?
I.E. let's say I create column labels in Sheet1 and I want them to automatically populate their same cells on Sheet2 and Sheet3.
Also, I need these cells to override the formatting in the sheets they are populating and retain the formatting they had on the first page.
I'm also hoping for a way to do this without a macro, but a simple macro would work too.
Thanks!