Hi all, i was wondering if this is possible.
column G have random numbers. Using VBA, is it possible to create folders in "C:\Test" based on first number in a cell in column G. Once that folder is created then move files that start with that number from C:\Test to the folder created.

for example
Column G has value "123456789"
since first number of the value above is 1, a folder is created in C:\Test\1.
once that is done, there are files in "C:\Test", the files that start with 12342344 should be moved to Folder C:\Test\1
just wondering if this is possible

thanks