Ahh got it,
by MarkFlax - 5/4/10 4:13 AM
In Reply to: Clarification by CNN80
and thanks for that CNN80.
I can also see now why you need that macro.
Hopefully others here will be able to help with that, but what about working with this in the meantime...?
You may want to work on a couple of dummy, (copied), sheets, saved in a completely different location, in case you make an error and lose anything. In fact, I would copy all of the original workbooks and place them off the hard disk somewhere, a backup.
Do this manually once more. But before doing it, "Record a macro", by going to Macros > Record a macro. Fill in the blanks, Macro name, Shortcut key if you want it, or create an object button, and make it available for any worksheet.
Then carry out the steps you would do manually to make this formula work. When you're done, Stop the recording.
Since all of your data is presented in the same form and same cell locations in each sheet, that same macro should work for each.
Would that work?
Was this reply helpful? (0) (0)