Populate like cells across worksheets without a command button
Posted on 2014-04-20
I have a workbook with worksheets labeled
In Jan13 at M2 my client wants to enter a number and have that number populate to all other worksheets except Consolidated (fortunately ALL other worksheets are identical) at the same cell location in other worksheets. In other words, go to M2 in Jan13, enter in XXXX and all other worksheets at M2 will have XXXX
I showed him that all he needs to do is select all sheets except Consolidated, go to M2 and enter what he wants. He does not want to do that, not can I use a command button.