Macro needed to move sheets to folders

[natedog1024]

Aloha.

I need help writing a macro. My accounting program spits out a file with 40 sheets, each named xxx or 123 for a specific store number. From here I need to take each sheet and dump it to a folder that also has the corresponding store number. I then share the directory and each store can access their info.

so my workbook looks like this - 123 124 125 126 127 128

My directory looks like this -

123
124
125
126
127
128

I need a quick and easy way to move those individual sheets into the correct folders. My accounting program will spit out 5 different workbooks so i need to do this a total of 5 times.

any help would be appreciated.

Thanks, Nate

[royUK]

I assume the Folders exist. This code needs adding to your PERSONAL>xls or creating as an addin. I haven't tested it but it should work.

Please Login or Register  to view this content.