|First, a posting tip:|
Please click on the blue line at the end of this post and read the instructions on how to post VBA code in this forum. By enclosing the code within the pre tags, the indents will be retained and the code will be easier to read.
re: "Below is the code that only works on one sheet ("1")...I would like it to to work on the entire workbook."
I'm a little confused by that statement.
The code you posted is monitoring C5:C6 on whatever sheet whose module it is stored in and writes data to a sheet named "1".
When you say you want it to "work on the entire workbook" I don't know if you mean that you want to write the data to the entire workbook or if you want it to monitor C5:C6 on every sheet in the workbook and still write the data to the sheet named "1" or something totally different.
Please explain your goal in a little more detail.
Click Here Before Posting Data or VBA Code ---> How To Post Data or Code.