Forum Discussion

KatharineWylie's avatar
KatharineWylie
Copper Contributor
Sep 06, 2024

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

Resources