I am new to VBA and I am trying to write a macro to copy data from Product File to FileMaster. My problem is I want data to be copied to next empty row in FileMaster.
For example FileMaster is filled with previous data up to cell C50 and I want my data copied from cell C51 but is struggling with this.