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...
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
KatharineWylie 365 sample attached