How do I update cells in a particular column from sheet to sheet. I have a payroll worksheet and occasionally our employees borrow money, I need to continuously update that column regarding terms and payments made on loans. I would love it if I could also hide this information till I need to view it. Is there a way to shrink it with something for me to click on when I need to view it?
Update cells in a particular column from one sheet to another