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
