LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 8
Default Saving files based on lookup

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
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
lookup help. lookup result based on data in 2 columns lcc Excel Worksheet Functions 3 April 6th 10 01:20 PM
macro to lookup value and open tab based on lookup value brandyvine Excel Programming 3 December 16th 08 09:57 AM
Closing files and saving files dan Excel Worksheet Functions 0 August 15th 06 04:07 AM
Sumproduct - Condition based on lookup of a Lookup Hari Excel Discussion (Misc queries) 12 May 31st 06 09:28 AM
Saving different files based upon data in particular column DKY[_46_] Excel Programming 14 August 6th 05 04:27 PM


All times are GMT +1. The time now is 08:47 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"