Hello code experts
I have this data in step2 sheet. With the help of a code I want to create a new sheet and name it as step3. I want to copy the data from step2 to step3, select the first blank cell in the data in column A till above the grand total row in the end and fill them with reference to the above row, color them yellow (as shown in sheet3). Then select the whole data, copy and paste special values to remove the formulas. Sort the data by yellow color on the top and delete the non color cells. Remove " Total" with the extra space from HSN Code column and format to normal. I have manually done all the steps via a code but in this step, as I was not able to select the blank cells with the help of a code. I need your expertise to complete Step3.
Thank you in advance.
Copy step2 to step3 fill blanks.xlsx
Please note that the first blank cell in this data is A3 but it could be in any cell in some other data. If the code finds the first blank cell in the data then it will run correct in other data too. The columns are fixed from A to S. The number of rows too will be different in different scenarios. Hence, the code should select the row till below the last number in the A column (Above grand Total).