Posted: 2/2/2008 8:04:33 PM EDT
|
I have a pretty complicated household budget spreadsheet (open office calc) recently I have changed from a check card based recording to credit card use monthly , which has greatly complicated my sheets. I am trying to figure out a way to have a list in the card sheet forward an entry to the related item sheet. IE I enter an item of type food in the main page I want that to copy itself to the food sheet also. Is there any easy way to do this short of setting up a full fledged database? ( or a really hellacious IF/THEN nested conditional) far simpler just to add an item to both locations manually? |
|
yes say on the first sheet the amount you enter goes into cell C34 and that sheet is named Sheet1 the cell you want to manually update is in Sheet5 cell D56 the value of D56 should be =Sheet1.C34 the template I modified has examples of sheets making references to previous sheets www.geocities.com/arfpdf/budget.doc original: documentation.openoffice.org/Samples_Templates/User/template_2_x/calc/RunningBudget.ots |
|
I am an Excel junkie, so I don't know about Open Office.... In Excel, you use the paste command to perform that task, but it's a special kind of paste. It's called: "Paste link" -- it takes a certain cell with either a number or formula and creates a reference to it on another worksheet / workbook / whatever. For example, suppose cell A3 on worksheet 1 has the info you want to copy over to cell D6 on worksheet 2. In Excel, all you have to do is go to cell D6 on worksheet two and type this: =Sheet1!A3 That's all... so let's play like you have a large amount of cells you want to copy over from your food list in order. The cells in the 2nd worksheet would look like this in the formula bar: =Sheet1!A3 =Sheet1!A4 =Sheet1!A5 =Sheet1!A6 =Sheet1!A7 It's EXTREMELY simple to do what you describe with Excel, unless I am misunderstanding your post? |
|
Are we misunderstanding here that you need to determine which type of entry it is, then put the entry on the appropriate sheet? In other words, you want to make a list in whatever order you want, and have the spreadsheet determine where to put the entry without any intervention? |