Feb 21 2021 03:30 AM
Dear Excel Community. I want to do myself a trainsplan. therefore I created "templates" which are all tables, where the last column is a product of the previous ones. since I am never training the same, my idea was to create those templates and then pasting them with a shortcut on a new sheet, so I kinda can build my own plan out of modular blocks however I want. the problem is that I can not paste any tables without the headline being lost. in addition to that if I type for example =table1 all the lines building the table dissapaer and if I want to track my progress by changing the reps the whole copied table dissapears. I would kindly appreciate any help.
thank you in advance,
mark
Feb 21 2021 04:27 AM
With your permission, if I can recommend you, explain your problem in detail. So you can get a solution proposal to your problem much faster.
At the same time, it is much easier for someone who wants to help to understand the subject.
A win-win situation for everyone.
Thank you for your understanding and patience
Nikolino
I know I don't know anything (Socrates)
Feb 21 2021 05:01 AM
Instead of "Format as Table" and referencing the defined name, use Name Manager to define the table name and the range of cells, which means you can include the header range of cells.
This will at least include the header range.
Feb 21 2021 05:09 AM
Here's another method if you insist to retain the template table formatted as a table.
Use Name Manager to create another name, below example is "TableHeader" with reference to the original table using hash # to set the all range of cells.
This will also include the header range of cells.
Feb 21 2021 05:43 AM
@shieldwulf thank you for your answer. in order to track my progress I want to improve the repetitions or the weight. if I do that in the copied table as u suggested 8for example changing 10 to 15) the whole table disappears. do you have any idea how to solve this issue too?
Feb 21 2021 05:47 AM
@NikolinoDE no need to ask, you are absolutely right, I will try better next time. the problem I have is that I want the created tables (seen below) to be pasted via =name (so I don't always have to go back to sheet1 poppy the thing and paste it). however the problem I encounter is, that if I do it by =name, the headline and all the colours disappear. in addition to that if I try to change from 10kg to 15kg (in the pasted =name table) for example the whole table disappears
Feb 21 2021 08:56 AM
I missed a bit what is the goal of this exercise. If we use =range (range could be data part of the table as =Table1, or with headers =Table1[#All], whatever), we only create reference on source data, nothing more. You do not create new table.
More simple case - we have any formatted value (text, number, etc) in cell A1. In B1 let use =A1. What we have now in B1 is value from A1 without it's formatting. =Table1[#All] works exactly the same way, the only you have as result are referenced values from Table1.
Feb 21 2021 10:25 AM
@Sergei Baklan Dear Sergei, thank you for your answer. I did not know that the =table1 only creates a reference so thanks for the clarification. My goal is to have a dynamic traingsplan. therefore I created the "templates" (as seen in the first picture down below, the numbers here are random and are kind of my weight atm) which I want to string together based on how I am training that day (on picture 2 you can see that I don't do the same traing on day 3 as on day 1 and 2). in order to make my life easier I created those templates on page 1 which I want to be able to paste via a short cut (ideally =squad) onto page 2 or another spread sheet thus creating the traingsplan the day I train, but I am not able to figure out how.
The goal of this is to
1. archive my traing
2. track progress (with the last row)
Feb 22 2021 01:56 AM
Unfortunately I don't know how to do that such way, if only to create with VBA function which takes table name as parameter and copy/paste it into another place.