I've posted a message before with this spreadsheet I use at work with Excel 2013. The page is laid out where multi items need to be pasted in. The cells to paste in are merged and it doesn't allow the data to be directly entered into the cells, I need to click on the cells then paste in the formula bar. I've unmerged the cells and tried 'Center across selection' as horizontal alignment. But this causes all kinds of issues with justification.
I wanted to show an example but I don't see an option to attach it. There are at least 23 items that have to be dropped in. Consider I'm using this all day and working multiple claims at a time while on the phone, I'm going mad with this arcadic process!
Doing this should be a simple, clean and fast. Working many claims I'm finding myself making mistakes, like dropping in the wrong cell or the text from the source program didn't copy.
So since the format has to be like this. Is there a way to create a separate area on the sheet or on another sheet where I can add the data in a form, just like with Access. This way it would be a simple interface, limiting errors. Then of course the data would move into the formatted sheet.
Any suggestions are appreciated!
I wanted to show an example but I don't see an option to attach it. There are at least 23 items that have to be dropped in. Consider I'm using this all day and working multiple claims at a time while on the phone, I'm going mad with this arcadic process!
Doing this should be a simple, clean and fast. Working many claims I'm finding myself making mistakes, like dropping in the wrong cell or the text from the source program didn't copy.
So since the format has to be like this. Is there a way to create a separate area on the sheet or on another sheet where I can add the data in a form, just like with Access. This way it would be a simple interface, limiting errors. Then of course the data would move into the formatted sheet.
Any suggestions are appreciated!