• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 359
  • Last Modified:

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?

Cheers
3-Bear-Down-2-Bull-UP.xlsm
0
cpatte7372
Asked:
cpatte7372
  • 3
1 Solution
 
cpatte7372Author Commented:
Hi Experts,

I thought you would have nailed this one.

Any ideas?
0
 
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"
0
 
cpatte7372Author Commented:
Eirman,

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

Anyway, I just realised that my request wouldn't work for me....
0
 
cpatte7372Author Commented:
Pointless request
0
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.

Join & Write a Comment

Featured Post

Cloud Class® Course: Python 3 Fundamentals

This course will teach participants about installing and configuring Python, syntax, importing, statements, types, strings, booleans, files, lists, tuples, comprehensions, functions, and classes.

  • 3
Tackle projects and never again get stuck behind a technical roadblock.
Join Now