If i understand this correctly you want to move just the files from E drive to the same folder name in D:
for eg: you have a folder named ABCD in e drive as well as in d drive but file name XYZ is in D drive and UVW is in e drive so you want to move UVW to folder named ABCD in D drive. THis can be achieved by creating a batch file. Firstslty you will have to create a list of all the file names put it in a spreadhseet. and then follow the below instructions: in excel type copy in "A" column and "B" coulmn type the file names with extension (for eg.xls) and in 3rd column type where you need to place the files. i.e. d:\ABCD respectively against each file name. copy the three coulmns paste it in edit+ and then do ctrl"H" and replace all tabs with "space" save the file as ".bat" then move the ".bat" file to the folder where all the files are there and then doublke clikc on it. and then exit and you will see all the files in the respective folder. Let us know if you face any issues with this. Thanks, Dharmesh On Thu, Nov 26, 2009 at 4:13 AM, Abhishek Jain <abhishek....@gmail.com>wrote: > Thank you guys for replying. > > I think I should elaborate it. There are different files in the sub-folders > at both locations. I just want to copy the contents of Location 2 to > Location 1 without disturbing anything in Location. > I don't want to delete anything from Location 1. > > Cheers.. > > Abhishek > > > > > On Wed, Nov 25, 2009 at 12:49 PM, Abhishek Jain <abhishek....@gmail.com>wrote: > >> Hi Guys, >> >> I am not sure whether I should ask it here or not because as the subject >> suggests, this is a non-excel query. >> >> What is the scenario - >> >> I have two locations: >> >> 1. D:\My Collection >> 2. E:\My Collection >> >> Under both these folders I have like 500 subfolders. *All the subfolders >> are named exactly same in both these locations.* >> >> What I want to achieve - >> >> I want to copy (or move) the contents of subfolders from location no. 2 to >> location no. 1. >> >> Example - >> >> Copy *.* from E:\My Collection\Folder 1 to D:\My Collection\Folder >> 1 >> Copy *.* from E:\My Collection\Folder 2 to D:\My Collection\Folder >> 2 >> Copy *.* from E:\My Collection\Folder 3 to D:\My Collection\Folder >> 3 >> and so on. >> >> You all would appreciate that manually doing this with around 500 folders >> would be a headache. Is there any batch program or software or something >> which can help me in this ? >> >> Any sort of help is greatly appreciated. Thanks in advance. >> >> Best regards, >> >> Abhishek Jain >> >> >> -- >> >> ---------------------------------------------------------------------------------- >> Some important links for excel users: >> 1. Excel and VBA Tutorials(Video and Text), Free add-ins downloads at >> http://www.excelitems.com >> 2. Excel tutorials at http://www.excel-macros.blogspot.com >> 3. Learn VBA Macros at http://www.vbamacros.blogspot.com >> 4. Excel Tips and Tricks at http://exceldailytip.blogspot.com >> >> >> To post to this group, send email to excel-macros@googlegroups.com >> If you find any spam message in the group, please send an email to: >> Ayush Jain @ jainayus...@gmail.com or >> Ashish Jain @ 26may.1...@gmail.com >> <><><><><><><><><><><><><><><><><><><><><><> >> HELP US GROW !! >> >> We reach over 6,500 subscribers worldwide and receive many nice notes >> about the learning and support from the group. Our goal is to have 10,000 >> subscribers by the end of 2009. Let friends and co-workers know they can >> subscribe to group at >> http://groups.google.com/group/excel-macros/subscribe > > > -- > > ---------------------------------------------------------------------------------- > Some important links for excel users: > 1. Excel and VBA Tutorials(Video and Text), Free add-ins downloads at > http://www.excelitems.com > 2. Excel tutorials at http://www.excel-macros.blogspot.com > 3. Learn VBA Macros at http://www.vbamacros.blogspot.com > 4. Excel Tips and Tricks at http://exceldailytip.blogspot.com > > > To post to this group, send email to excel-macros@googlegroups.com > If you find any spam message in the group, please send an email to: > Ayush Jain @ jainayus...@gmail.com or > Ashish Jain @ 26may.1...@gmail.com > <><><><><><><><><><><><><><><><><><><><><><> > HELP US GROW !! > > We reach over 6,500 subscribers worldwide and receive many nice notes about > the learning and support from the group. Our goal is to have 10,000 > subscribers by the end of 2009. Let friends and co-workers know they can > subscribe to group at > http://groups.google.com/group/excel-macros/subscribe > -- Thanks, Dharmesh -- ---------------------------------------------------------------------------------- Some important links for excel users: 1. Excel and VBA Tutorials(Video and Text), Free add-ins downloads at http://www.excelitems.com 2. Excel tutorials at http://www.excel-macros.blogspot.com 3. Learn VBA Macros at http://www.vbamacros.blogspot.com 4. Excel Tips and Tricks at http://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com If you find any spam message in the group, please send an email to: Ayush Jain @ jainayus...@gmail.com or Ashish Jain @ 26may.1...@gmail.com <><><><><><><><><><><><><><><><><><><><><><> HELP US GROW !! We reach over 6,500 subscribers worldwide and receive many nice notes about the learning and support from the group. Our goal is to have 10,000 subscribers by the end of 2009. Let friends and co-workers know they can subscribe to group at http://groups.google.com/group/excel-macros/subscribe
