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)
You could help us help you by being more complete in the descriptions of:
- the source table
- the nature of "the numbers" in that source table
- the number of numbers
- their nature (as formulas themselves, or simply as data points)
- the static or dynamic nature of the table (and the numbers therein)
- the receiving ("different" was your word) table
- whether it's dynamic or static in composition
- what it's rows and columns represent and how those relate to the source table
- and anything else that would help understand the task you're trying to achieve
Automatically identify titles and paste them from one table to the last empty row of another table
First of all, those data elements are not being pasted into "the last empty row of another table";
- it's not the last row
- those are not tables
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:
- where that first source table is coming from
- what those secondary areas are all about, how they'll be used etc.
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.
- the source table
