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
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