I get a an excel document every day. I have to transfer a portion of the information onto a second excel sheet. While the information changes daily the location on both sheets never changes. I'm tired of copying and pasting! What is something I can do to speed this process up of transferring data form one sheet to another sheet? Could a macro be a good solution for this issue?