Aug-03-2020, 04:09 PM
Hello,
Is there a way to center align ws3 cells as the values from ws1 get written into the ws3?
Is there a way to center align ws3 cells as the values from ws1 get written into the ws3?
ws3[f'A{i+2}']=ws1['A1'].value[28:]
ws3[f'D{i+2}']=ws1['B4'].value
ws3[f'E{i+2}']=ws1['D4'].value
ws3[f'I{i+2}']=ws1['B'][-1].value
ws3[f'J{i+2}']=ws1['D'][-1].value
ws3[f'O{i+2}']=ws1['E'][-1].value
ws3[f'N{i+2}']=ws2[f'I{i+6}'].value