May 24 2022 10:53 AM
Is there a formula that can put the numbers in a table in the last row of the different table? (no VB)
May 24 2022 11:08 AM
You could help us help you by being more complete in the descriptions of:
May 24 2022 12:24 PM
Automatically identify titles and paste them from one table to the last empty row of another table
May 24 2022 12:53 PM
First of all, those data elements are not being pasted into "the last empty row of another table";
That said, you could in those smaller formatted regions, pull data from the table in the upper left of your screen by using FILTER or one of the LOOKUP formulas.
But before we get into those possible solutions, why don't we back up still further and get you to describe:
You really need to do some more work in setting for the full business process here, the larger context in which you are seeking to use Excel. And then we can do some designing to make optimum use of Excel's abilities. What you're doing so far looks more like an attempt to take a process that might work on paper and simply transfer it over to Excel; but that often is not the best way to use Excel.
May 24 2022 01:24 PM
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
May 24 2022 02:06 PM
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