Hi Everyone !

I have a query in excel sheet automation .

I’m having two excel sheets ,

- is the master excel sheet .this excel sheet will have rows from A to AE .

The column A contains the formulas like (sum=B:AE) - This is the another excel file , where I am taking data from this sheet and copying it to

Sheet 1

here I will be copying the values from B columns , since A columns is having the formulas

Now I want to ensure that both the A column length and B to AE column length should match , so that if the A column length is shorter that the column length of Bto AE then the formula should be copied to every cell in the column A .

can anyone please help me with this