Create excel file based on animal column
Skip same name
output should be file name dog.xlsx
same steps for create all files with relevant column like output screen shoot
If I will run bot to next day then bot will add data with existing data and so on… like
2nd day output
here B3 should be dog not dog1
If input file have new name under animal column then bot will create xlsx file with new name and add relevant data.
Please help me out.
Note: I am able to create .xlsx files but not able to write relevant data.