I have an excel sheet which contains data and I have to paste it in another sheet.
After pasting the I have to insert table with headers
This is the pasted data
Click on insert>Table option
We will get the following pop up
Click on ok
And The Output will look like the below screenshot.
But I don’t have to do it using UI interaction
I need to complete this process without opening excel sheet.
I have attached the excel sheet for the same.
Book1.xlsx (12.2 KB)
Is there a way by which we can do the following stuff??
Thanks in advance??