Begging For Help Again *Love you guys*

[yojeff]

Ok, I have a few hundred work orders done in Excel. Each spread sheet is a seperate file but all are identical in structure (basic order form). I need to change the value in the same cell on all the forms (manager's name needs to be changed on all our forms).

Question: How do I do this without having to open and edit all five thousand forms?


This forum is batting 1000 with all my stupid question. I may have to post up my secret mango salsa recipe......... Yum..

Thanks, YoJeff.

 

[xenou]

If the workbooks all have one sheet (or the sheet in question is the first sheet no matter what), then replace:

Sheets(1)
For
Sheets("MySheet")

Otherwise, we need some way to identify the sheet - perhaps by a common tab name, or by some cell that is always on the sheet and contains the same value.