Most of the things are done just few fine tuning needed
1)when I was running the code it divided the wrong sheet many times and I was confused, then I noticed the code is written for "sheet1" and order of my sheet was changed. can u please change that to sheet name(instead of sheet number) "studump"?The sheet number may change but I can keep the sheet name constant. I tried to do it myself but ended up with error.
2)If in destination sheet, sheet with same name exist instead of quitting it should create sheets with name assigned through input and suffixed by random numbers
3)most of the unnecessary data is now getting deleted from date columns .Just need to delete decimal numbers.Please include decimal number in unnecessary data list for date column and delete record(row containing numbers with decimal point in date filed.
4)To delete the unnecessary columns from both the newly created sheet I run the below given macro in both the sheets
can you integrate this code into the code written by you so that after importing the data this code will run in both the newly created sheet
Also in future code please change date column from "B" to "O"
Thanks again
Bookmarks