OK
The only thing I see that needs to change is on the summery sheet cell R5 needs to copy C26 instead of C25. That was my error in what I posted it. Sorry.
On the Tabs on Cell B39 I forgot to delete the information in quick quote that gets pasted in new on every tab. If you could delete that so that it does not show up on all the tabs.
If you could type in "Location:" on cell K27 on the tabs that would be great also.
I am not sure what all I can do without messing up the macro or I would do it.
Is there a way to make the summery sheet stay in the order of the tabs? Example: I move a tab from the end to the middle or vice versa it changes on the summery sheet to keep them in order as they appear at the bottom of the spread sheet? This is not a big deal but it would keep the summery sheet in order of the areas or job type as we arrange the tabs.
Again Thanks for all the help with this.
|