Hello,
I am relatively new to VBA, and i need help with what i think is a fairly complex macro.
I have a force testing machine that saves a spreadsheet full of data about what the force measured is at any one moment of time.
I need a macro that goes through the columb where the force is on each worksheet(probably over 100 different worksheets), finds the highest force, and consolodates them into a master list.
Oh, and im sing excel 2003 if that matters.
If you can shed any light on me or show me where to go to find help i would be greatly appreciative.
Thankyou!
I am relatively new to VBA, and i need help with what i think is a fairly complex macro.
I have a force testing machine that saves a spreadsheet full of data about what the force measured is at any one moment of time.
I need a macro that goes through the columb where the force is on each worksheet(probably over 100 different worksheets), finds the highest force, and consolodates them into a master list.
Oh, and im sing excel 2003 if that matters.
If you can shed any light on me or show me where to go to find help i would be greatly appreciative.
Thankyou!
