I work for a small mortgage company and we keep a Google spreadsheet active at all times with each officer’s open loans so that everyone has access to loan numbers and we can all keep track of where each one is in the process. Once a loan is funded it is cut and pasted to a new page labelled “funded” and then again when paid.
The issue I am having is that nearly every time I go to add a new loan, even if all of the rows above it are correct, half the entries suddenly lose their alignment. I have it set so that every entry in column C is aligned left, but then when I go to write in a new loan (manually-- I don’t import), the data for just that cell in column C aligns right. So I select the entire column again and set it to align left. Three loans later and I have to do it over again. It’s not that much effort but it is aggravating as hell and I just want my alignments to stay as I assign them.
My meager understanding is that when someone is cutting and pasting, they’re taking the data AND the formatting with them. How do I prevent this? Is there code I can use in the script? Is there a different way to get the data from one page to another without taking the formatting with it that I can harangue my processors about until they do that instead?