Re: $$Excel-Macros$$ How to move a set of files ( In Nos ) in new folders & then get their files names & consolidating them using a Vlookup & offiset function

2016-02-29 Thread Paul Schreiner
Here. I made this one exclude anything with "XLS" in the filename. Paul- “Do all the good you can, By all the means you can, In all the ways you can, In all the places you can, At all the times you can, To all the people you can, As long as ever you can.” - J

Re: $$Excel-Macros$$ How to move a set of files ( In Nos ) in new folders & then get their files names & consolidating them using a Vlookup & offiset function

2016-02-29 Thread Devendra Sahay
Hi Paul, This is running properly, but can we save the prepared file in same folder, which we have selected. One more thing, the code which you have shared previously for folder creating & moving files in folder, is not running properly. its giving error for DB director. If you can solve this, wo

Re: $$Excel-Macros$$ How to move a set of files ( In Nos ) in new folders & then get their files names & consolidating them using a Vlookup & offiset function

2016-02-29 Thread Paul Schreiner
I can have it skip the "M" value if it is found. in the first and latest examples, your image number is found in the first part of the "1-2x.jpg"But the second example had "1.2x-jpg" trying to differentiate between THOSE values would be a little more difficult, but possible.it that necessary? Pau

Re: $$Excel-Macros$$ How to move a set of files ( In Nos ) in new folders & then get their files names & consolidating them using a Vlookup & offiset function

2016-02-29 Thread Devendra Sahay
Hi, Each time, when i prepare upload sheet. article name might be different but the naming after the article no would be similar. On Mon, Feb 29, 2016 at 11:08 PM, Paul Schreiner wrote: > Those are not the same filename structure as in your previous sample > filenames, > but they match your o

Re: $$Excel-Macros$$ How to move a set of files ( In Nos ) in new folders & then get their files names & consolidating them using a Vlookup & offiset function

2016-02-29 Thread Paul Schreiner
Wait.. you WANT to remove the -M in the Article? your latest sample includes the -M. This one should remove it. Paul- “Do all the good you can, By all the means you can, In all the ways you can, In all the places you can, At all the times you can, To all the

Re: $$Excel-Macros$$ How to move a set of files ( In Nos ) in new folders & then get their files names & consolidating them using a Vlookup & offiset function

2016-02-29 Thread Paul Schreiner
Those are not the same filename structure as in your previous sample filenames,but they match your original request. This should work for you. Paul- “Do all the good you can, By all the means you can, In all the ways you can, In all the places you can, At al

Re: $$Excel-Macros$$ How to move a set of files ( In Nos ) in new folders & then get their files names & consolidating them using a Vlookup & offiset function

2016-02-29 Thread Devendra Sahay
Hi, Code is getting the article no, but not removing (-M) & also not parsing the file names according to their view. On Mon, Feb 29, 2016 at 10:44 PM, Devendra Sahay < devendrasahanypt...@gmail.com> wrote: > Hi Paul, > > Please check attached file & images. > > Thanks, > > > On Mon, Feb 29, 2

Re: $$Excel-Macros$$ How to move a set of files ( In Nos ) in new folders & then get their files names & consolidating them using a Vlookup & offiset function

2016-02-29 Thread Paul Schreiner
Try this and see how it works Paul- “Do all the good you can, By all the means you can, In all the ways you can, In all the places you can, At all the times you can, To all the people you can, As long as ever you can.” - John Wesley --

Re: $$Excel-Macros$$ How to move a set of files ( In Nos ) in new folders & then get their files names & consolidating them using a Vlookup & offiset function

2016-02-29 Thread Devendra Sahay
Hi Paul, Please check the attached file, as asked. Thanks, Devendra On Mon, Feb 29, 2016 at 7:29 PM, Paul Schreiner wrote: > Sorry for the delay. > I spend 10-12 hours a day throughout the week on a computer. > When a beautiful weekend comes along, I tend to spend my time doing other > things

$$Excel-Macros$$ If Condition formula required

2016-02-29 Thread amar takale
-- Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s =TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @ https://www.facebook.com/discussexcel FORUM RULES 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, F

Re: $$Excel-Macros$$ How to move a set of files ( In Nos ) in new folders & then get their files names & consolidating them using a Vlookup & offiset function

2016-02-29 Thread Paul Schreiner
Sorry for the delay.I spend 10-12 hours a day throughout the week on a computer.When a beautiful weekend comes along, I tend to spend my time doing other things and never even APPROACHED my computer! Please see my earlier response. Paul- “Do all the good yo

Re: $$Excel-Macros$$ Having trouble w/ a Macro

2016-02-29 Thread Paul Schreiner
There's not near enough information here to make a guess.I'd have to have the entire workbook and test it myself. However:You're in VBA Debug.Did you try stepping through one line at a time to see where it's running into a problem?Do you have any "loops" that are not terminating/exiting?  Paul--

Re: $$Excel-Macros$$ How to move a set of files ( In Nos ) in new folders & then get their files names & consolidating them using a Vlookup & offiset function

2016-02-29 Thread Paul Schreiner
IF I understand correctly, your task should be easily accomplished.I've done something similar in the past.But my criteria was based on total file size. Do ALL of your filenames consist of 7 fields separated by "-"? If you were to use split() on your filenames, using "-" as a delimiterwould field

Re: $$Excel-Macros$$ Help building macro that takes data from entry form and fills out database

2016-02-29 Thread Paul Schreiner
Easily done, provided you give us some details!  Paul- “Do all the good you can, By all the means you can, In all the ways you can, In all the places you can, At all the times you can, To all the people you can, As long as ever you can.” - John Wesley --

Re: $$Excel-Macros$$ How to move a set of files ( In Nos ) in new folders & then get their files names & consolidating them using a Vlookup & offiset function

2016-02-29 Thread Devendra Sahay
Hey Pankaj, Please look into this & assist. Thanks, Devendra On Mon, Feb 29, 2016 at 3:22 PM, Devendra Sahay < devendrasahanypt...@gmail.com> wrote: > Please revert. > > On Sun, Feb 28, 2016 at 6:48 PM, Devendra Sahay < > devendrasahanypt...@gmail.com> wrote: > >> Hi Experts, >> >> Sorry for po

Re: $$Excel-Macros$$ How to move a set of files ( In Nos ) in new folders & then get their files names & consolidating them using a Vlookup & offiset function

2016-02-29 Thread Devendra Sahay
Please revert. On Sun, Feb 28, 2016 at 6:48 PM, Devendra Sahay < devendrasahanypt...@gmail.com> wrote: > Hi Experts, > > Sorry for posting such a big query on forum but this issue is time taking > & i want to do it in smart way but not able to do. So please check the > below mentioned scenario &