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?