BC_George
New member
Hi all
I work in hospital admin and have a problem that I think somebody here will be able to solve really easily. For context: admitting staff without IT skills are copying and pasting numerous data fields into 1 worksheet which results in crazy formatting issues and is impossible to control.
We need a simple user-friendly system for hospital admissions; several fields that the clerk can fill in and which then populate into another tab on the same spreadsheet. This will keep the admin staff away from having to navigate around large amounts of data.
When a new patient is admitted and their data is entered in the first worksheet, I need it to automatically populate into the next blank line on the second worksheet. I thought this would be easy to figure out but can't find anything on forums & help functions that seems to fit.
I'm using Excel 2010; don't ask why we don't use Access. It's a long and frustrating story. Any help is massively appreciated!
I work in hospital admin and have a problem that I think somebody here will be able to solve really easily. For context: admitting staff without IT skills are copying and pasting numerous data fields into 1 worksheet which results in crazy formatting issues and is impossible to control.
We need a simple user-friendly system for hospital admissions; several fields that the clerk can fill in and which then populate into another tab on the same spreadsheet. This will keep the admin staff away from having to navigate around large amounts of data.
When a new patient is admitted and their data is entered in the first worksheet, I need it to automatically populate into the next blank line on the second worksheet. I thought this would be easy to figure out but can't find anything on forums & help functions that seems to fit.
I'm using Excel 2010; don't ask why we don't use Access. It's a long and frustrating story. Any help is massively appreciated!