Excel Formula Across all Worksheets

Hi Experts,

I use to open up individual spreadsheets to each time I needed to carry certain requirments. Each spreadsheet basically carry out the same functions. The problem is I think its pointless opening up a new spreadsheet when I can combine them in one workbook with individual worksheets.

So I moved the worksheets from each individual excel workbook to the spreadsheet attached. Now the problem is the three worksheets that I moved over, '2 Bull Up 3 Bear Dwn 2 Bull Up, Four Lows Five Highv2 and 3 Lows Four High hasn't carried the formulas when I moved them over.

This isn't a huge problem because all the code in the first worksheet can be used with the other worksheets. For example, moduel 1 has code that I would like to be used with all worksheets, also code in Module 3 I would also like to be used in all worksheets, but you'll notice that the modules reference a particular worksheet i.e. Four Lows Five High.

Now, my guess is that what I need is somekind of way of getting the code to work globally on all worksheets? This is where an Excel Expert would come in.

I figure I'm going to need the code to be placed in "This Workbook", but I'm guessing and I'm no expert.

If you can help so that in future whenever I create a worksheet or move a worksheet over the code will work on that worksheet as well?

Who is Participating?
cpatte7372Connect With a Mentor Author Commented:

My response wasn't meant to be serious ......

Anyway, I just realised that my request wouldn't work for me....
cpatte7372Author Commented:
Hi Experts,

I thought you would have nailed this one.

Any ideas?
EirmanChief Operations ManagerCommented:
An off-topic tip .... the next time you don't get a quick response, don't create your own!

Unanswered EE questions automatically get priority after about 24 hours.

If you don't get a reply within the next 36 hours or so, just click on "Request Attention"
cpatte7372Author Commented:
Pointless request
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.