At this point I really have no idea what you really need help with. It was my understand from your first post,
Is there a macro that can apply the formulas to each worksheet but only down to last row of data within each sheet?
I have the following which works fine if there is only one worksheet. But is there a way of making this run on all active worksheets?
that your code worked fine you just needed it to run on all active worksheets. I am going to take a complete shot in the dark guess that maybe this is what you are looking to acomplish:
If this is not what you are looking for then you need to CLEARLY and CONCISELY state what you goal is and how the data is being stored in your sheet. Best of luck.
Bookmarks