Column Headings and Linking
A quick question (if there is such a thing); when adding a link from one sheet to a cell in another sheet do the column headings have to be the same?
My assumption would be they don't, I imagine the column name 'internally' is irrelevant and there is an underlying system generated reference, otherwise changing a column name would be really complicated!
I'm having limited success with cell linking at the moment and 'matching' the column headings was a suggestion.
What I would like to have is a sub-sheet, that has some cells populated via the content of another sheet and some cells created with automations based on the linked cell content.
Most desirable is for a new row on the top sheet to force a new row with the appropriate linked cell content in the sub-sheet.