Hi Experts, I am having a problem with one of my macro.
In my daily job, I have to do below mention task. . I will have one Excel file, in which i will have sheet1, and on sheet1 i will ahve a list of files. on the basis i will have to move certen file from one location to subfolder in same location. Example : I have folder "C/Pankaj" in that folder i have 30 files. Some team somewhere have already reviewd 10 files out of those 30 files. Now they sent me list (Excel file > Sheet1> columnA) of files they have reviewed. Now my task is to Create a sub folder in "C/Pankaj/To be Reviewd" And go through the list and Mark status of the file if that is found in "C/Pankaj" as found and move rest of the file in sub folder i created "C/Pankaj/To be Reviewd" so team can review only that. So if there are 10 files in the list i have to check whether they are there in the folder or not, so i can validate the work. and then move rest all other files to created subfolder. I used to have a macro file created by my ex colleague (Password Protected, so i never saw he code) for the same which used to take minutes for this task. But accidently that file got deleted by my team member and now the same task is taking lots of my daily time. So can you please help me with the macro to do the same. I would be really appreciated, as it is impacting my daily productivity and i am about to loose my job as i am getting escalation from audit team that they are not getting input from me on time. as i am doing it manually. So please help guys. Attaching is the sample list to be worked on. . -- Pankaj Pandey Bhopal -- Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s =TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @ https://www.facebook.com/discussexcel FORUM RULES 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Jobs posting is not allowed. 6) Sharing copyrighted material and their links is not allowed. NOTE : Don't ever post confidential data in a workbook. Forum owners and members are not responsible for any loss. --- You received this message because you are subscribed to the Google Groups "MS EXCEL AND VBA MACROS" group. To unsubscribe from this group and stop receiving emails from it, send an email to excel-macros+unsubscr...@googlegroups.com. To post to this group, send email to excel-macros@googlegroups.com. Visit this group at https://groups.google.com/group/excel-macros. For more options, visit https://groups.google.com/d/optout.
List.xlsx
Description: MS-Excel 2007 spreadsheet
