datatronics505
Board Regular
- Joined
- Nov 26, 2022
- Messages
- 55
- Office Version
- 365
- Platform
- Windows
- MacOS
- Mobile
- Web
For the purpose of following an online course on accounting, I have created two tables: one is a daily journal where all transactions are recorded and the other is a T-account that reflects changes of an individual account that was previously listed in that journal. Both are formatted as tables, columns that need to contain only text are formatted as text, those that contain dollar amounts are formatted accordingly and columns containing dates are formatted for dates.
As presented in the screenshot, there's only one T-account (the table on the right), but as the journal grows, so will the number of those small tables.
I am trying to reference specific cells from the daily journal into the cells of the smaller T-account table in order to avoid re-typing the same data. For example, both the daily journal and the T-account tables have the Date column. I am referencing the specific Transaction date from the daily journal into the Date cell of the appropriate T-account table by clicking on the Date cell first, typing "=" followed by clicking on the Transaction date cell and pressing TAB. Results however are unpredictable. I will get the reference to the date right but then when trying to reference the account name (cells at both tables are formatted as text) I am getting the literal text describing the reference and not the text value that I want to see in the cell.
Furthermore, when pressing TAB when done entering data into the last cell in the row of the T-account table, the new row immediately references the next date in the Daily journal, something I don't want.
Material found online about referencing data from one table to another mentions referencing rows and columns entirely, and not individual cells. How would I address particular cells only from the Daily journal table into individual T-account tables? Preferably as an absolute reference.
As presented in the screenshot, there's only one T-account (the table on the right), but as the journal grows, so will the number of those small tables.
I am trying to reference specific cells from the daily journal into the cells of the smaller T-account table in order to avoid re-typing the same data. For example, both the daily journal and the T-account tables have the Date column. I am referencing the specific Transaction date from the daily journal into the Date cell of the appropriate T-account table by clicking on the Date cell first, typing "=" followed by clicking on the Transaction date cell and pressing TAB. Results however are unpredictable. I will get the reference to the date right but then when trying to reference the account name (cells at both tables are formatted as text) I am getting the literal text describing the reference and not the text value that I want to see in the cell.
Furthermore, when pressing TAB when done entering data into the last cell in the row of the T-account table, the new row immediately references the next date in the Daily journal, something I don't want.
Material found online about referencing data from one table to another mentions referencing rows and columns entirely, and not individual cells. How would I address particular cells only from the Daily journal table into individual T-account tables? Preferably as an absolute reference.
Last edited by a moderator: