Solved

Excel Formula Across all Worksheets

Posted on 2011-03-11
4
335 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
  • 3
4 Comments
 

Author Comment

by:cpatte7372
ID: 35112716
Hi Experts,

I thought you would have nailed this one.

Any ideas?
0
 
LVL 23

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

Is Your Active Directory as Secure as You Think?

More than 75% of all records are compromised because of the loss or theft of a privileged credential. Experts have been exploring Active Directory infrastructure to identify key threats and establish best practices for keeping data safe. Attend this month’s webinar to learn more.

Question has a verified solution.

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

Sparklines have been introduced with Excel 2010 and are a useful tool for creating small in-cell charts, used for example in dashboards. Excel 2010 offers three different types of Sparklines: Line, Column and Win/Loss. What it does not offer is a…
Workbook link problems after copying tabs to a new workbook? David Miller (dlmille) Intro Have you either copied sheets to a new workbook, and after having saved and opened that workbook, you find that there are links back to the original sou…
The viewer will learn how to use a discrete random variable to simulate the return on an investment over a period of years, create a Monte Carlo simulation using the discrete random variable, and create a graph to represent the possible returns over…
Graphs within dashboards are meant to be dynamic, representing data from a period of time that will change each time the dashboard is updated with new data. Rather than update each graph to point to a different set within a static set of data, t…

948 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

Need Help in Real-Time?

Connect with top rated Experts

23 Experts available now in Live!

Get 1:1 Help Now