Forum Discussion
KatharineWylie
Sep 06, 2024Copper Contributor
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 set up in that excel file.
The remaining columns would be subject specific to that worksheet ie test results or finance.
We have one very large excel spreadsheet with lots of columns for one patient and despite hide columns it would be better to split the data for managing and reading
I do hope this makes sense! Perhaps it is not possible but i am grateful for any advice out there on managing large sets of columns going off onto the horizon!
best wishes
Excel novice
- LorenzoSilver Contributor
If you run Excel 2021 or 365 no problem, as long as you can format your data as a structured Table
Sample attached
- KatharineWylieCopper Contributor
Many thanks for replying and your advice on this - i shall investigate structured tables! Lorenzo
- LorenzoSilver Contributor
You're welcome KatharineWylie
If you run 365 there's a sightly easier way to do what I shared....