I'm looking to automatically deposit columns of information from one worksheet to a second worksheet when a certain cell shows "RECEIVED" by using a macro button. All data that is moved from the original spreadsheet will have the blank columns deleted and columns moved together. Each time this happens, the columns will be moved into the next available spot on the second worksheet. I know nothing about VBA. I'm am working on tutorials but this may take me until the end of time before I finish this project.