Forum Discussion
copying the first 3 columns of data as you type and it appears in all the (or specified) worksheets
Dear All Hello! I wondered if there was a formula for a few columns in the first worksheet like surname. first name, hospital number which as you type can appear in the subsequent worksheets already...
If you run Excel 2021 or 365 no problem, as long as you can format your data as a structured Table
Sample attached
Many thanks for replying and your advice on this - i shall investigate structured tables! Lorenzo
You're welcome KatharineWylie
If you run 365 there's a sightly easier way to do what I shared....
- yes i can access 365
