We hope you enjoy your visit.

You're currently viewing our forum as a guest. This means you are limited to certain areas of the board and there are some features you can't use. If you join our community, you'll be able to access member-only sections, and use many member-only features such as customizing your profile, sending personal messages, and voting in polls. Registration is simple, fast, and completely free.


Join our community!


If you're already a member please log in to your account to access all of our features:

Username:   Password:
Add Reply
Excel help.
Topic Started: Mar 21 2011, 01:21 AM (662 Views)
Aaron
Member Avatar
A blast from the past.

So lets say I need to reference another worksheet (in the same workbook) (i.e. 21-Mar) and I need to reference a new worksheet everyday but the cell stays the same (i.e. ='21-Mar'!D$9, ='Mar-22'!D$9) but when I drag the cell down to copy it keeps the 21-Mar every and won't change is there away other then to change it my self to have it change on its own.
Offline Profile Quote Post Goto Top
 
Loona
Member Avatar
Flawgic Loless
[ *  *  *  *  *  *  * ]
You mean copying it from Mar 21 to Mar 22 it stays the same? Assuming you don't have a lot of data with that formula, you could always remove the worksheet name '21-Mar' from it. Then when you copy over to new dates it will always revert to what it's supposed to on the new worksheet.
If it's for something like a graph and it does it automatically, I've always found myself ending up changing the worksheet name manually in each formula...which is a big pain.
It seems like there is always an easier way to do things in Excel, but by the time you figure out how to do it, you could have just done it manually. :P

What I've always found frustrating with excel is it never copies the formulas the way you want. I've still yet to figure out how to copy the exact formulas in a column into a new column, without having them adjust their value locations from say A5 to B5.
Offline Profile Quote Post Goto Top
 
ElementalAlchemist
Member Avatar


Loona
Mar 21 2011, 10:57 AM
I've still yet to figure out how to copy the exact formulas in a column into a new column, without having them adjust their value locations from say A5 to B5.
$A$5
Offline Profile Quote Post Goto Top
 
Loona
Member Avatar
Flawgic Loless
[ *  *  *  *  *  *  * ]
^Is there a way to automatically insert dollar signs?
Offline Profile Quote Post Goto Top
 
Aaron
Member Avatar
A blast from the past.

No I have a summery worksheet then I have 21-Marc, 22-Marc worksheets. I want the summery to call the values in 21-Marc, 22-Marc etc.
Offline Profile Quote Post Goto Top
 
1 user reading this topic (1 Guest and 0 Anonymous)
« Previous Topic · Technology Chat · Next Topic »
Add Reply