evandrobp
New Member
- Joined
- Jul 25, 2019
- Messages
- 3
Hello all, thanks in advance.
I've tried tons of formulas and combinations but no success. It doesn't matter if I have to add the tab name for each section of the formula or if there's a way to get every tab's names without mention it in the formula.
No VBA please (unfortunately).
I'm trying to apply a formula to a MASTER tab and this should give me all the rows from the next tab and so on...
i.e.:
<tbody>
</tbody>The orange color is from TAB_1 and the green color is from TAB_2 --> (the # of rows will always vary, it's not the same)
The thing is: sometimes I do have tabs with 500 or 1000 rows, it really depends on the week's numbers.
Is there a way to import all the data from TAB_1, TAB_2, etc. , to the MASTER only with the option of paste the report on the specific tabs?
When the rows from TAB_1 is done, jump to TAB_2 (from first cell), then jump to TAB_3, etc.
And if I add a row the TAB_1 it will add automatically to the MASTER/TAB_1 section and then update the list with the TAB_2 right after that, etc.
The MASTER tab should just get data from other TABS, and those ones may vary like I said. I did formulas using as reference absolute cells, relative, etc, but nothing. Always gave me the wrong solution.
Does it make any sense?
I really appreciate all your help guys!
(Please excuse the typos.)<style type="text/css"> table.tableizer-table { font-size: 10px; border: 1px solid #CCC ; font-family: Arial, Helvetica, sans-serif; } .tableizer-table td { padding: 4px; margin: 3px; border: 1px solid #CCC ; } .tableizer-table th { background-color: #1A80E4 ; color: #FFF ; font-weight: bold; }</style>
I've tried tons of formulas and combinations but no success. It doesn't matter if I have to add the tab name for each section of the formula or if there's a way to get every tab's names without mention it in the formula.
No VBA please (unfortunately).
I'm trying to apply a formula to a MASTER tab and this should give me all the rows from the next tab and so on...
i.e.:
MASTER
| Item Id | Item Description |
|---|---|
| 273623 | AABBCC |
| 935155 | BBCCDD |
| 644229 | DDEEFF |
| 908624 | EEFFGG |
| 204115 | GGHHII |
| 18424 | IIJJKK |
| 389924 | KKLLMM |
| 927228 | MMNNOO |
| 199706 | OOPPQQ |
| 490029 | QQRRSS |
<tbody>
</tbody>
The thing is: sometimes I do have tabs with 500 or 1000 rows, it really depends on the week's numbers.
Is there a way to import all the data from TAB_1, TAB_2, etc. , to the MASTER only with the option of paste the report on the specific tabs?
When the rows from TAB_1 is done, jump to TAB_2 (from first cell), then jump to TAB_3, etc.
And if I add a row the TAB_1 it will add automatically to the MASTER/TAB_1 section and then update the list with the TAB_2 right after that, etc.
The MASTER tab should just get data from other TABS, and those ones may vary like I said. I did formulas using as reference absolute cells, relative, etc, but nothing. Always gave me the wrong solution.
Does it make any sense?
I really appreciate all your help guys!
(Please excuse the typos.)<style type="text/css"> table.tableizer-table { font-size: 10px; border: 1px solid #CCC ; font-family: Arial, Helvetica, sans-serif; } .tableizer-table td { padding: 4px; margin: 3px; border: 1px solid #CCC ; } .tableizer-table th { background-color: #1A80E4 ; color: #FFF ; font-weight: bold; }</style>
