Re: $$Excel-Macros$$ Bell Curve Chart

Hi Saurav, Please check this tutorial. https://www.youtube.com/watch?v=_PqnDYMO3lw On Mon, Jan 30, 2017 at 12:12 PM, sourav devrani < souravdevrani1...@gmail.com> wrote: > Hi Guys, > > I want to create " Bell Curve Chart " in excel but i don't know how to > create this chart and logic behind

Re: $$Excel-Macros$$ How to use Index Match for two different files

Paul, would you please look into this. On Jan 16, 2017 9:31 AM, "Devendra Sahay" <devendrasahanypt...@gmail.com> wrote: > Hey Paul, > > > Would you please look into this. > > > On Sat, Jan 14, 2017 at 11:07 AM, Devendra Sahay < > devendrasahanypt...@gma

Re: $$Excel-Macros$$ How to use Index Match for two different files

Hey Paul, Would you please look into this. On Sat, Jan 14, 2017 at 11:07 AM, Devendra Sahay < devendrasahanypt...@gmail.com> wrote: > Hi Paul, > > Yes both columns have only one column, I just wanted to check howmany > values ar availble in the dump using vlookup.

Re: $$Excel-Macros$$ How to use Index Match for two different files

----- > > > On Tuesday, January 10, 2017 4:07 AM, Devendra Sahay < > devendrasahanypt...@gmail.com> wrote: > > > Hi Paul, > > Code is working fine, but can we make this code more flexible like It can > identify the header name i

Re: $$Excel-Macros$$ How to use Index Match for two different files

----- > > > On Monday, January 9, 2017 11:23 AM, Devendra Sahay < > devendrasahanypt...@gmail.com> wrote: > > > Paul, I mean to say first occurrence of the order id. > > On Jan 9, 2017 9:51 PM, "Paul Schreiner" <schreiner_p...@att

Re: $$Excel-Macros$$ How to use Index Match for two different files

e times you can,To all the people > you can,As long as ever you can.” - John Wesley* > ----- > > > On Monday, January 9, 2017 11:06 AM, Devendra Sahay < > devendrasahanypt...@gmail.com> wrote: > > > Paul, Thanks for your reply. Can we extract th

Re: $$Excel-Macros$$ How to use Index Match for two different files

, January 7, 2017 10:42 PM, Devendra Sahay < devendrasahanypt...@gmail.com> wrote: Hi Team, Sorry for posting such a long query on the forum, but am working on few reports in which I have to write the Index match formula multiple times on daily basis. So am thinking to write a macro for

Re: $$Excel-Macros$$ How to use Index Match for two different files

Paul & Mandeep, Would you please look into this. On Mon, Jan 9, 2017 at 4:16 PM, Devendra Sahay < devendrasahanypt...@gmail.com> wrote: > Guys waiting for your reply. > > On Sun, Jan 8, 2017 at 9:12 AM, Devendra Sahay < > devendrasahanypt...@gmail.com> wrot

Re: $$Excel-Macros$$ How to use Index Match for two different files

Guys waiting for your reply. On Sun, Jan 8, 2017 at 9:12 AM, Devendra Sahay < devendrasahanypt...@gmail.com> wrote: > Hi Team, > > Sorry for posting such a long query on the forum, but am working on few > reports in which I have to write the Index match formula multiple time

$$Excel-Macros$$ How to use Index Match for two different files

Hi Team, Sorry for posting such a long query on the forum, but am working on few reports in which I have to write the Index match formula multiple times on daily basis. So am thinking to write a macro for this but as I am new to VBA, am not able to do so. If you guys can help me out here, would

Re: $$Excel-Macros$$ Re: Interview Questions with Answers (Excel+VBA+Access+SQL Server)

Hey Guys, Can you please share the files again ? Please. On Tue, Dec 6, 2016 at 6:43 AM, Devendra Sahay < devendrasahanypt...@gmail.com> wrote: > Hey Guys, > > Can you please share the files again ? Please. > > On Mon, Dec 5, 2016 at 9:35 PM, Chris <pip

Re: $$Excel-Macros$$ Re: Interview Questions with Answers (Excel+VBA+Access+SQL Server)

Hey Guys, Can you please share the files again ? Please. On Mon, Dec 5, 2016 at 9:35 PM, Chris wrote: > > > > *Thank you!You, sir, saved my day (interview tomorrow ;D)* > > -- > Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s >

Re: $$Excel-Macros$$ Excel Table to HTML table

okay bro, will check it with the tool. On Sep 12, 2016 4:26 PM, "Gowrisankar Arthanari GSA" <a.go...@gmail.com> wrote: > yes, its one type of HTML code​ > > On Mon, Sep 12, 2016 at 4:14 PM, Devendra Sahay < > devendrasahanypt...@gmail.com> wrote: > >> i

Re: $$Excel-Macros$$ Excel Table to HTML table

Hi, can we get the written HTML Code in text format,so that we can use that code in webpage tool. On Sep 12, 2016 2:11 PM, "Devendra Sahay" <devendrasahanypt...@gmail.com> wrote: > Thanks for the help, will check the HTML code in the tool and share the > response. >

Re: $$Excel-Macros$$ Excel Table to HTML table

Thanks for the help, will check the HTML code in the tool and share the response. On Sep 12, 2016 1:31 PM, "Gowrisankar Arthanari GSA" <a.go...@gmail.com> wrote: Find the updated one. it work with excel, language used in excel will be reproduce. On Mon, Sep 12, 2016 at 12:42 PM

Re: $$Excel-Macros$$ Excel Table to HTML table

of rows increase or decrease then will this code will act accordingly. On Mon, Sep 12, 2016 at 12:30 PM, Gowrisankar Arthanari GSA < a.go...@gmail.com> wrote: > PFA​ > > On Mon, Sep 12, 2016 at 12:27 PM, Devendra Sahay < > devendrasahanypt...@gmail.com> wrote: > &

Re: $$Excel-Macros$$ Excel Table to HTML table

Hi Guys, Is there any other possible way to do this, Please help guys. On Sat, Sep 10, 2016 at 1:43 PM, Devendra Sahay < devendrasahanypt...@gmail.com> wrote: > Hi, > > Have tried all the codes & tricks in shared URLs but none of them giving > desired output. Is there any

Re: $$Excel-Macros$$ Excel Table to HTML table

katricak/801024 > http://windowssecrets.com/forums/showthread.php/107929-VBA-code-to-HTML > http://dailydoseofexcel.com/archives/2011/09/20/roll-your- > own-html-from-excel-vba/ > > -- > > On Sat, Sep 10, 2016 at 12:18 PM, Devendra Sahay < > devendrasahanypt...@gmail.com> w

Re: $$Excel-Macros$$ Excel Table to HTML table

Hi Guys, Is there any who can solve this problem. On Fri, Sep 9, 2016 at 8:41 PM, Devendra Sahay < devendrasahanypt...@gmail.com> wrote: > Hi Guys, > > Am waiting for response. If anyone can help in this regard would be > helpful. > > On Fri, Sep 9, 2016 at

Re: $$Excel-Macros$$ Excel Table to HTML table

Hi Guys, Am waiting for response. If anyone can help in this regard would be helpful. On Fri, Sep 9, 2016 at 8:46 AM, Devendra Sahay < devendrasahanypt...@gmail.com> wrote: > Hi Experts, > > Am working for company in which i have to convert an excel table in HTML > table forma

$$Excel-Macros$$ Excel Table to HTML table

Hi Experts, Am working for company in which i have to convert an excel table in HTML table format & as am not from the technical background then I have to struggle with existing templates to modify them as per new requirement. I found a code on google, which is giving as desired output but I want

Re: $$Excel-Macros$$ Re: how i convert pdf file to Excel using macro.

Hi Frank, This is a group which allows its members to post queries which they face doing their Daily Job in offices. So if you are getting irrelevant mails from the group, you can unsubscribe from the group by sending a separate mail to mentioned mail id. To unsubscribe from this group and all

Re: $$Excel-Macros$$ Re: VBA macro - WhatsApp group.

Please add mine too, Its- 8527433364 On Wed, Aug 31, 2016 at 2:33 PM, Lokesh Kumar wrote: > Please add my number in what'sup group 9718534717 > > On Thu, Aug 25, 2016 at 12:01 PM, Manoj Kumar > wrote: > >> Please add my number in what'sup

Re: $$Excel-Macros$$ Re: Shortcut key to Align Left, Right & Center in Excel

Hi Nave, Could you please share the tool for the Test & DEMO, So that we can give suggestion & inputs to make it better. On Wed, Aug 17, 2016 at 5:27 PM, Nave Rachman wrote: > Hi > I'm working on a new productivity tool for Excel, and looking for Excel > users to test

Re: $$Excel-Macros$$ Vlookup Sensitive Case

Hi Sachin, You can also try this one- =SUMPRODUCT(EXACT($F$4,$B$5:$B$11) * ($C$5:$C$11)) Please change the ref. accordingly. On Mon, Aug 8, 2016 at 12:52 PM, NOORAIN ANSARI wrote: > Dear Sachin, > > Please try it... > >

Re: $$Excel-Macros$$ Re: Introduce Yourself !!

Hey Folks, Am Devendra aged about 25, working a Sr. Executive-OPS in a pioneer brand in E-Commerce sector. Have 4+ years of experience in MIS & Operations.My interest are learning new things & spreading them in my peers. am also a music lover. On Fri, Jun 17, 2016 at 12:30 PM, Deepu Dubey

Re: $$Excel-Macros$$ Count of date in multiple sheets of same workbook

Hi Guys, Please revert. On Wed, Jun 15, 2016 at 11:10 PM, Devendra Sahay < devendrasahanypt...@gmail.com> wrote: > Hi Guys, > > > Right now am working in on report in which I have to count the a > particular date in multiple sheets & am doing it by using the functi

$$Excel-Macros$$ Count of date in multiple sheets of same workbook

Hi Guys, Right now am working in on report in which I have to count the a particular date in multiple sheets & am doing it by using the function - Countifs and the i have to write a long formula for it. Another one issue is to extract total amount of bookings in current week in multiple sheets.

Re: $$Excel-Macros$$ How to Consolidate two different sheet using macro

Hi Mandeep, Please help me out here. On Fri, Jun 3, 2016 at 12:51 PM, Devendra Sahay < devendrasahanypt...@gmail.com> wrote: > Hi Experts, > > Please revert > > On Thu, Jun 2, 2016 at 11:43 PM, Devendra Sahay < > devendrasahanypt...@gmail.com> wrote: >

Re: $$Excel-Macros$$ How to Consolidate two different sheet using macro

Hi Experts, Please revert On Thu, Jun 2, 2016 at 11:43 PM, Devendra Sahay < devendrasahanypt...@gmail.com> wrote: > Please reply friends as I have to finish this task tomorrow & i have more > than 13000 rows in excel sheet to reconcile. > > On Thu, Jun 2, 2016 at 10

Re: $$Excel-Macros$$ How to Consolidate two different sheet using macro

Please reply friends as I have to finish this task tomorrow & i have more than 13000 rows in excel sheet to reconcile. On Thu, Jun 2, 2016 at 10:45 PM, Devendra Sahay < devendrasahanypt...@gmail.com> wrote: > Hi Experts, > > Right now am facing an issue with consolidati

$$Excel-Macros$$ How to Consolidate two different sheet using macro

Hi Experts, Right now am facing an issue with consolidation,am sharing query with you.Please check & share the solution. *@Paul, have much expectations from you. Please help* 1) Have a DB sheet & other one is mapping the main issue is if the field name (Column-G) in DB exists in the Mapping

$$Excel-Macros$$ How to calculate TAT from created & solved date timestamp

Hi Experts, Currently am facing issue to calculate TAT of user request from their created & solved time, but am not satisfied with the output. So please check the attached file & Pivot. 1) want to extract TAT with NOW function 2) want to group the count & contribution in 4 groups 24 Hours,48

Re: $$Excel-Macros$$ Marco to split the text into execl

> yes, it is .csv > > On Tue, Apr 19, 2016 at 10:18 PM, Devendra Sahay < > devendrasahanypt...@gmail.com> wrote: > >> Hi Mahesh, >> >> Please confirm the file format, is it .csv >> >> >> >> >> On Tue, Apr 19, 2016 at 10:16 PM, Mah

Re: $$Excel-Macros$$ Marco to split the text into execl

Hi Mahesh, Please confirm the file format, is it .csv On Tue, Apr 19, 2016 at 10:16 PM, Mahesh wrote: > Hi, > > I want to split it by rows. > > For example- > if the text file contains 12 lacs rows, then I would like make 03 > different text files with 4lacs row in

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

- > > > > > > > > *“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

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* > - > > > On Thursday, March 17, 2016 12:48 PM, Devendr

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

RowNum = Dict_Article.Count + 2 Dict_Article.Add Article, RowNum Else RowNum = Dict_Article.Item(Article) End If If (Sheets("Sheet1").Cells(RowNum, "A").Value & "X" = "X") Then Sheets("Sheet1").Cells(Ro

$$Excel-Macros$$ Copying files from a folder & pasting them in new folder

Hi Experts, Right now am using a code to copy a batch of file from a folder & pasting them in new folder but the issue is, i have to put all the file names in a column & right now i have files in a different columns. So please check the attached files & the code & please modify it for selecting

Re: $$Excel-Macros$$ Copying files from a folder & pasting them in new folder

> Next rng > > *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 yo

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

, "-")* > > *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

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

t; > > > > > > *“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

gt; 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 th

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

can,At all the times you can,To all the people > you can,As long as ever you can.” - John Wesley* > ----- > > > On Monday, February 29, 2016 12:15 PM, Devendra Sahay < > devendrasahanypt...@gmail.com> wrote: > > > > Hi 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

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. > >

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

-- > > > > > > > > *“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

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:

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

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 >

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

@Paul, Please help, as i am waiting for your 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

$$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

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 & assist. Scenario- I have 2000 (.jpg ) images in a folder, with a similar names like mentioned ( only

Re: $$Excel-Macros$$ Re: Copy data from different sheets to 1 summary sheet (single excel file)

Hi Mandeep, If we have multiple files, then how can we make a consolidated sheet using a macro ? Thanks, On Thu, Feb 11, 2016 at 2:09 PM, Mandeep Baluja wrote: > Worksheets Combine !! Run this macro Hope you're aware about how to run a >> macro !! if not try this >>

Re: $$Excel-Macros$$ Change in existing macro.

Hi Mandeep, What if, I want to move these files from one folder to destination folder, how can we do this ? because then i have a count of files on which i have to work. Please assist. Thanks, Devendra On Mon, Feb 1, 2016 at 6:39 PM, Mandeep Baluja wrote: > > > Sub

$$Excel-Macros$$ Change in existing macro.

Hi Team, I want to change the procedure of assigning the path for running macro in below macro. currently m assigning both paths for- *From where to copy & where to paste the files*, I want to open a box for assigning the path for both. Please assist. Option Explicit Sub CopyToFold() Dim i As

Re: $$Excel-Macros$$ Merge multiple Workbook

h can search the column with that > particular header name (common accross All the workbooks and paste it. > > Regards, > > Sandeep K Chhajer. > > Sent from my BlackBerry 10 smartphone. > *From: *Devendra Sahay > *Sent: *Wednesday 27 January 2016 10:59 > *To: *excel

Re: Fw: $$Excel-Macros$$ Merge multiple Workbook

Hi Sandeep, I have a code, which simply goes to specific folder & open the workbooks one by one & copy the data and paste them in same sheet (Where the marcro is written). ** Make sure all the files have same header, because it copies all the data including the header. So if this is relevant,

Re: $$Excel-Macros$$ Sorting Comma Separated Values in a cell

Thanks Pankaj & Mandeep, all the codes running properly on real time data. On Fri, Jan 15, 2016 at 7:10 PM, Pankaj Sharma wrote: > Result type2 is here: > > > Sub SortRangeData2() > > Dim sh1 As Worksheet, sh2 As Worksheet > Dim rng1 As Range, rng2 As Range,

Re: $$Excel-Macros$$ Sorting Comma Separated Values in a cell

Hi Mandeep, Please revert, as I am facing a big issue because of this. Thanks On Fri, Jan 15, 2016 at 11:33 AM, Devendra Sahay < devendrasahanypt...@gmail.com> wrote: > Hi Mandeep, > > Please revert. > > > On Thu, Jan 14, 2016 at 5:37 PM, Devendra Sahay < >

Re: $$Excel-Macros$$ Sorting Comma Separated Values in a cell

Hi, I dont want to sort column a, I want to sort the comma separated data alphabetically & numerically in column 2. but the code which i have shared, it shorts the data of column a & b both, So all the data shuffled This is the required format of the data. Col 1Col 2 A

Re: $$Excel-Macros$$ Sorting Comma Separated Values in a cell

Hi Mandeep, Please revert. On Thu, Jan 14, 2016 at 5:37 PM, Devendra Sahay < devendrasahanypt...@gmail.com> wrote: > Hi, > > I dont want to sort column a, I want to sort the comma separated data > alphabetically & numerically in column 2. > > but the code wh

Re: $$Excel-Macros$$ Sorting Comma Separated Values in a cell

Hi, Sample of the data is attached. Please check ​. Thanks, -- 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

$$Excel-Macros$$ Sorting Comma Separated Values in a cell

Hi Experts, Currently I am using below code to sort comma separated values within a cell but In case I have to sort these value with their respective ref. name. this code sorts the values & the ref. name alphabetically & data shuffled all the data, So because of this am unable to reconcile the

$$Excel-Macros$$ Assigning a folder to merge the files in that folder

Hi Experts, Currently I am using below code to merge a set of excel files in one file, but I have to change the path in code, each time for run this code. So if we can assign a path at the time of running this code, would be helpful. So please assist. I have highlighted the code, where am

Re: $$Excel-Macros$$ Assigning a folder to merge the files in that folder

Hey Mandeep, Its working properly. Thanks ☺☺ On Thu, Jan 7, 2016 at 10:47 PM, Mandeep Baluja wrote: > Check this code now !! > > Regards, > Mandeep baluja > > Sub Merge_Files() > Dim objFSO As Object > Dim objFolder As Object > Dim objFile As Object > Dim i As Long > Dim

Re: $$Excel-Macros$$ Download data of a Google sheet in excel sheet with VBA

1 PM, Devendra Sahay < devendrasahanypt...@gmail.com> wrote: > Hi Mandeep, > > Thanks for your prompt reply & The Google sheet which I have, contains > more than 20k rows & its a shared sheet. It requires a login name & id of > my organization domain. So ho

Re: $$Excel-Macros$$ Download data of a Google sheet in excel sheet with VBA

Hi Mandeep, Thanks for your prompt reply & The Google sheet which I have, contains more than 20k rows & its a shared sheet. It requires a login name & id of my organization domain. So how we will handle this. & If a key combination can be added to download the data from web through VBA On

$$Excel-Macros$$ Download data of a Google sheet in excel sheet with VBA

Hi Experts, @ Paul, an you please help me in this concern. I have searched a lot on Google for above concern but none of the code is running, So If you can help then please help me out here on this issue. Any help on this would be appreciated & thanks in advance for your help. -- With

$$Excel-Macros$$ How to download data of a Google sheet in excel sheet with VBA

Hi Experts, @ Paul, an you please help me in this concern. I have searched a lot on Google for above concern but none of the code is running, So If you can help then please help me out here on this issue. Any help on this would be appreciated & thanks in advance for your help. -- With

$$Excel-Macros$$ How to download data of a Google sheet in excel sheet with VBA

Hi Experts, I have searched a lot on Google for above concern but none of the code is running, So If you can help then please help me out here on this issue. Any help on this would be appreciated & thanks in advance for your help -- With Regard !!! Devendra Rahi -- Are you =EXP(E:RT) or

Fwd: $$Excel-Macros$$ How to download data of a Google sheet in excel sheet with VBA

Hi Experts, I have searched a lot on Google for above concern but none of the code is running, So If you can help then please help me out here on this issue. Any help on this would be appreciated & thanks in advance for your help -- With Regard !!! Devendra Rahi -- Are you =EXP(E:RT) or

Re: $$Excel-Macros$$ Get files in a New folder with help of Macro

Hi Paul, Its working. ☺☺ But can we add a option to select folder. (Like a file which I am using to merge files) Please check Add-Ins option in attached file. On Tue, Dec 1, 2015 at 11:23 PM, Devendra Sahay < devendrasahanypt...@gmail.com> wrote: > Thanks Paul. > > I will try to

Re: $$Excel-Macros$$ Get files in a New folder with help of Macro

Or we can put the file in a folder & run the macro & it will detect the folder location where the file is & it will split the files in folder. OR we can use a user form to assign the folder path Whichone one is easier, please assist. On Wed, Dec 2, 2015 at 1:59 PM, De

Re: $$Excel-Macros$$ Get files in a New folder with help of Macro

ey* > ----- > > -- > *From:* Devendra Sahay <devendrasahanypt...@gmail.com> > *To:* excel-macros@googlegroups.com > *Sent:* Wednesday, December 2, 2015 3:47 AM > > *Subject:* Re: $$Excel-Macros$$ Get files in a New f

Re: $$Excel-Macros$$ Get files in a New folder with help of Macro

End If > fCnt = 1 > End If > fso.movefile FolderName & FileNm.Name, NewFolder > > Next FileNm > MsgBox "Finished" > End Sub > > *Paul* > ----- > > > > > > >

$$Excel-Macros$$ Get files in a New folder with help of Macro

Hi Experts, I have a excel sheet of files names, which are in a folder & I want to extract these files (which i have in excel sheet) in a new folder with the help of a macro. Please help me out. -- With Regard !!! Devendra Rahi -- Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you

Re: $$Excel-Macros$$ Get files in a New folder with help of Macro

y done. > > If not, then I'll need to know what you actually wish to do. > > > *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 lon

Re: $$Excel-Macros$$ Get files in a New folder with help of Macro

gt; > *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.” -

$$Excel-Macros$$ Reg-Convert this no to text

Hi..Experts.. i m facing a problem to convert a number in text, so kindly help me on this problem -- P Before printing, think about the environment. Devendra sahay -- FORUM RULES (986+ members already BANNED for violation) 1) Use concise, accurate thread titles. Poor thread