So what is the macro required? How will the macro know which spreaasheet to modify? Also, can you share exactly what you are trying to do here?