In the following attached file, we are trying to pull the data from the "Revisions" sheet to the "Title_Frame_Register" sheet in the AU and AV columns and match-up with the "Layout Tab ID" in the right row.
If those columns had data in them, then the code would tell it to go to the next columns that have "Revision Date" and "Revision Description", which would be the AY and AZ columns in "Title_Frame_Register" sheet. And so on.
Right now the code is bypassing all the columns it needs to go in (that have formulas) and putting it at the end of "Title_Frame_Register" sheet. Any assistance offered would be greatly appreciated.
Prior related question: http://rdsrc.us/3FLHyw