LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 216
Default Columns that will grab a value from a previous column, incrimental

Here is what I want to do... I need to build a database
of a few 100 inputs. But all I want to do is put in one
input. For instance, each row has five columns. I put in
the first column and the other four can be calculating
using just the first column. For the second row I want it
to take the value of the last column of the row prior. So
on so on. So row 60 column 1 would take the value of row
59 column 5...

Is there a way to set it up so that all I need to do is
put in the first value, row 1 column 1. And excel will
calculate all of the values straight through?

For instance my columns are like this...
C1 C2 C3 C4
5 .5 2.5 7.5
7.5 .5 3.75 11.25
11.25 .5 .........

Thanks

 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
scrolling columns behind previous columns gfw Excel Worksheet Functions 4 October 23rd 09 10:54 PM
GRAB VALUES FROM COLUMN A WHERE COLUMN C = 302 Gluefoot Excel Discussion (Misc queries) 1 May 19th 09 09:41 PM
Losing previous highlighted columns when doing multiple column hi. gagirl Excel Worksheet Functions 2 October 9th 07 12:59 AM
Shortcut to select column with data in previous column TJAC Excel Discussion (Misc queries) 1 July 10th 07 06:12 PM
Numeric reference of column. Data Grab ? bigexcelfan Excel Discussion (Misc queries) 3 January 4th 06 11:26 PM


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

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"