A Microsoft Office (Excel, Word) forum. OfficeFrustration

If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below.

Go Back   Home » OfficeFrustration forum » Microsoft Excel » General Discussion
Site Map Home Register Authors List Search Today's Posts Mark Forums Read  

Range names in financial projections; to enable getting data from a specific period



 
 
Thread Tools Display Modes
  #1  
Old August 22nd, 2004, 09:25 PM
L Mehl
external usenet poster
 
Posts: n/a
Default Range names in financial projections; to enable getting data from a specific period

Hello --

In projecting cash flows over time, I want to name the summary rows
(revenue, expenses, capital expenditures, etc.) so that I can easily get
each row's value for a specific period, for further processing.

I have seen the method where columns and rows are named, and the
intersection of a column and row is named using their combination, separated
by a space (as the intersection operator).

Can anyone recommend methods which have worked for them?

Thanks for any help.

Larrry Mehl
mehl_at_cyvest.com


  #2  
Old August 23rd, 2004, 01:07 PM
BrianB
external usenet poster
 
Posts: n/a
Default

Select table and set it up via Insert/Name/Create


---
Message posted from http://www.ExcelForum.com/

  #3  
Old September 2nd, 2004, 05:46 AM
L Mehl
external usenet poster
 
Posts: n/a
Default

Thanks.


"BrianB " wrote in message
...
Select table and set it up via Insert/Name/Create


---
Message posted from http://www.ExcelForum.com/



 




Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is Off
HTML code is Off
Forum Jump

Similar Threads
Thread Thread Starter Forum Replies Last Post
Dynamic range (column); include only rows before blank row above more data L Mehl General Discussion 6 August 22nd, 2004 08:59 PM
Chart Data Table, Data Range, etc. do not update on Chart RichardS Charts and Charting 3 December 17th, 2003 06:56 PM
Setting Source Data to a Named Range rather than cell Range Justin Smith Charts and Charting 2 December 5th, 2003 06:56 PM


All times are GMT +1. The time now is 01:12 PM.


Powered by vBulletin® Version 3.6.4
Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 OfficeFrustration.
The comments are property of their posters.