Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
Hi,
I have many many files which I want to save in different folders. All files has a number in C1 and based on that number, I need to do a lookup in a separate file containing the name of the folder. The file has to saved in the corresponding folder. Ex: File A has number 123 in cell C1 Folder-file looks like this: Number Foldername 123 Folder A 234 Folder B etc. In this example, Folder A is the correct folder, and the file needs to be moved from the current location to the subfolder "Folder A". Repeat for all files in top-folder. I guess this is quite simple to program in VBA ..... if you know how..... Any help would be most appreciated. Regards, André |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
lookup help. lookup result based on data in 2 columns | Excel Worksheet Functions | |||
macro to lookup value and open tab based on lookup value | Excel Programming | |||
Closing files and saving files | Excel Worksheet Functions | |||
Sumproduct - Condition based on lookup of a Lookup | Excel Discussion (Misc queries) | |||
Saving different files based upon data in particular column | Excel Programming |