Forum Discussion
Insert the numbers of a table in the last row of a different table (no VB)
Is there a formula that can put the numbers in a table in the last row of the different table? (no VB)
My English is not very good, so I gave a simple example, but now that I show the main sheet
The third and fourth columns from the right is subject
There is a cash word in this photo and I want to use these numbers in the daily registration table, and when I record the purchase and arrival of goods in the warehouse in the table above, they are identified based on the words and in Cardex ( i don't know what you call that , maybe "inventory" )with this header, for example Cardex Methane inventory is recorded automatically.
This is a simple and basic example of my cardex
Your English a far far better than my Arabic, so no need to apologize.
That spreadsheet, however, is not designed to facilitate the neat extraction of data from it to another spot. You've set it up (or somebody else set it up) with blank black rows between entities, and variable numbers of rows between those artificial dividers, and inconsistent use of the rows to begin with. A well designed datable uses one row per record.
So my question to you is how much flexibility there is to redesign the whole process?
Let me encourage you to spend some time understanding Excel Tables
https://exceljet.net/excel-tables
https://exceljet.net/glossary/excel-table
