Copy data from 2 cells in one worksheet to the same cells in all worksheets in a workbook

You don't really need a macro for that. You can just select all the worksheets you want to change and enter the value and the formula on one of them. Then deselect all the worksheets by clicking on one of the previously un-selected sheets.

Regards, TMS

You're welcome.



If you are satisfied with the solution(s) provided, please mark your thread as Solved.


New quick method:
Select Thread Tools-> Mark thread as Solved. To undo, select Thread Tools-> Mark thread as Unsolved.

Or you can use this way:

How to mark a thread Solved
Go to the first post
Click edit
Click Go Advanced
Just below the word Title you will see a dropdown with the word No prefix.
Change to Solved
Click Save


You may also want to consider thanking those people who helped you by clicking on the little star at the bottom left of their reply to your question.

@LonesomeJoe: Unfortunately your post does not comply with Rule 2 of our Forum RULES. Do not post a question in the thread of another member -- start your own thread.

If you feel an existing thread is particularly relevant to your need, provide a link to the other thread in your new thread.

Old threads are often only monitored by the original participants. New threads not only open you up to all possible participants again, they typically get faster response, too.


I would suggest that you record a macro while you undertake the task manually. That will give you some clues as to what your macro needs to look like.

Regards, TMS