Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Help Arranging Data on Spreadsheet
I have constructed a spreadsheet which details the comparison between
expenditures generated in maintaining a boat between two partners ( Adam & Bill ) , who share these equally. This spreadsheet has the following columns :- A :- Date B:- Name C:- Purchase D:- Amount F:- Adam's purchase amount divided by 2 G:- Bill's contributions H: Balance between F & G "Adam" does all the purchasing and this amount divided by 2 is shown in column F . The other partner "Bill" has his contributions detailed in column G and then the totals in F & G are compared to show the Balance in column H. As subsequent purchases and contributions arise and are entered as described , these appear in column C3, C4...etc with the resultant BALANCE being constantly adjusted in column H but always shown in cell H2. Similarly with the totals shown in columns F & G , i.e these also are adjusted automatically with the data entered in column C but are also always shown in cells F2 and G2 I would like these amounts now shown in cells H2 , F2 & G2 to appear on the same row as the latest entry in column C but don't know how to arrange this so it happens each time I enter a purchase in column C. Can anyone help with this , please ? B.N. |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Help Arranging Data on Spreadsheet
In cell H3 enter =H$2$ and drag down
do the same for F and G Hope this helps -- Richard " wrote: I have constructed a spreadsheet which details the comparison between expenditures generated in maintaining a boat between two partners ( Adam & Bill ) , who share these equally. This spreadsheet has the following columns :- A :- Date B:- Name C:- Purchase D:- Amount F:- Adam's purchase amount divided by 2 G:- Bill's contributions H: Balance between F & G "Adam" does all the purchasing and this amount divided by 2 is shown in column F . The other partner "Bill" has his contributions detailed in column G and then the totals in F & G are compared to show the Balance in column H. As subsequent purchases and contributions arise and are entered as described , these appear in column C3, C4...etc with the resultant BALANCE being constantly adjusted in column H but always shown in cell H2. Similarly with the totals shown in columns F & G , i.e these also are adjusted automatically with the data entered in column C but are also always shown in cells F2 and G2 I would like these amounts now shown in cells H2 , F2 & G2 to appear on the same row as the latest entry in column C but don't know how to arrange this so it happens each time I enter a purchase in column C. Can anyone help with this , please ? B.N. |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
Help Arranging Data on Spreadsheet
Sorry, I should be =$H$2
-- Richard "Richard" wrote: In cell H3 enter =H$2$ and drag down do the same for F and G Hope this helps -- Richard " wrote: I have constructed a spreadsheet which details the comparison between expenditures generated in maintaining a boat between two partners ( Adam & Bill ) , who share these equally. This spreadsheet has the following columns :- A :- Date B:- Name C:- Purchase D:- Amount F:- Adam's purchase amount divided by 2 G:- Bill's contributions H: Balance between F & G "Adam" does all the purchasing and this amount divided by 2 is shown in column F . The other partner "Bill" has his contributions detailed in column G and then the totals in F & G are compared to show the Balance in column H. As subsequent purchases and contributions arise and are entered as described , these appear in column C3, C4...etc with the resultant BALANCE being constantly adjusted in column H but always shown in cell H2. Similarly with the totals shown in columns F & G , i.e these also are adjusted automatically with the data entered in column C but are also always shown in cells F2 and G2 I would like these amounts now shown in cells H2 , F2 & G2 to appear on the same row as the latest entry in column C but don't know how to arrange this so it happens each time I enter a purchase in column C. Can anyone help with this , please ? B.N. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Baffling! Spreadsheet Data Form Size | Excel Discussion (Misc queries) | |||
how do I get data from one excel spreadsheet to another | Excel Discussion (Misc queries) | |||
Help PLEASE! Not sure what answer is: Match? Index? Other? | Excel Worksheet Functions | |||
Finding repeated data in a excel spreadsheet | Excel Discussion (Misc queries) | |||
Pulling data from 1 sheet to another | Excel Worksheet Functions |