?
Solved

Excel Formula Across all Worksheets

Posted on 2011-03-11
4
Medium Priority
?
344 Views
Last Modified: 2012-08-13
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
Comment
Question by:cpatte7372
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 3
4 Comments
 

Author Comment

by:cpatte7372
ID: 35112716
Hi Experts,

I thought you would have nailed this one.

Any ideas?
0
 
LVL 24

Expert Comment

by:Eirman
ID: 35112986
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
 

Accepted Solution

by:
cpatte7372 earned 0 total points
ID: 35115624
Eirman,

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

Anyway, I just realised that my request wouldn't work for me....
0
 

Author Closing Comment

by:cpatte7372
ID: 35154446
Pointless request
0

Featured Post

Want to be a Web Developer? Get Certified Today!

Enroll in the Certified Web Development Professional course package to learn HTML, Javascript, and PHP. Build a solid foundation to work toward your dream job!

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

This tutorial explains how to create a series of drop-down lists that are dependent upon prior selections to guide (“force”) the user to make the correct selection and reduce data errors within Microsoft Excel. Excel 2010 was used for this tutorial;…
This code takes an Excel list of URL’s and adds a header titled “URL List”. It then searches through all URL’s in column “A”, looking for duplicates. When a duplicate is found, it is moved to the top of the list. The duplicate URL’s are then highlig…
Many functions in Excel can make decisions. The most simple of these is the IF function: it returns a value depending on whether a condition you describe is true or false. Once you get the hang of using the IF function, you will find it easier to us…
Although Jacob Bernoulli (1654-1705) has been credited as the creator of "Binomial Distribution Table", Gottfried Leibniz (1646-1716) did his dissertation on the subject in 1666; Leibniz you may recall is the co-inventor of "Calculus" and beat Isaac…

765 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question