Re: $$Excel-Macros$$ Re: Macro for Ageing of Inventory

2014-12-23 Thread Vaibhav Joshi
I did not got the logic of putting 8 in cell C5, can u pl explain.. + *I did not do this for you. God is here working through me for you.* On Tue, Dec 23, 2014 at 9:18 PM, C.G.Kumar wrote: > May someone please look and advise macro to solve the puzzle. > > Thanks and Regards, > C.G.Kumar >

Re: $$Excel-Macros$$ Use of ADO Connection in Excel Macro

2014-12-23 Thread Vaibhav Joshi
Note the diff in two code, this will help you to understand difference.. Cheers!! + *I did not do this for you. God is here working through me for you.* On Wed, Dec 24, 2014 at 1:08 AM, Zafar Iqbal wrote: > Dear Expert, > > You did an excellent job for me. Thanks you very much for this kin

Re: $$Excel-Macros$$ Use of ADO Connection in Excel Macro

2014-12-23 Thread Zafar Iqbal
Dear Expert, You did an excellent job for me. Thanks you very much for this kindness and I hope for the same support in future, always. Regards, Zafar Iqbal On Tuesday, December 23, 2014 5:09:05 PM UTC+3, Vabz wrote: > > Hi > > Try this... > > > Sub Data_Merge_From_All_Files_SelectFolder_NO_AD

Re: $$Excel-Macros$$ Re: How to append row from 1 sheet to end of row of second sheet based on cell value

2014-12-23 Thread Bé Trần Văn
Preview File, you change the sheet name is not affected. 2014-12-23 22:44 GMT+07:00 Vaibhav Joshi : > Glad this helped you. > > Cheers!! > On Dec 23, 2014 9:10 PM, "bobengler" wrote: > >> Thank you for your time and expertise. It's good to know there is good >> support out there. >> >> Bob Engle

Fwd: $$Excel-Macros$$ Re: Macro for Ageing of Inventory

2014-12-23 Thread C.G.Kumar
May someone please look and advise macro to solve the puzzle. Thanks and Regards, C.G.Kumar -- Forwarded message - From: C.G.Kumar Date: Mon Dec 22 2014 at 7:09:55 PM Subject: Re: $$Excel-Macros$$ Re: Macro for Ageing of Inventory To: excel-macros@googlegroups.com Macro is not

Re: $$Excel-Macros$$ Re: How to append row from 1 sheet to end of row of second sheet based on cell value

2014-12-23 Thread Vaibhav Joshi
Glad this helped you. Cheers!! On Dec 23, 2014 9:10 PM, "bobengler" wrote: > Thank you for your time and expertise. It's good to know there is good > support out there. > > Bob Engler > > >*From:* Ashish Kumar > *To:* Vaibhav Joshi > *Cc:* "excel-macros@googlegroups.com" > *Sent:* Friday,

Re: $$Excel-Macros$$ Re: How to append row from 1 sheet to end of row of second sheet based on cell value

2014-12-23 Thread bobengler
Thank you for your time and expertise. It's good to know there is good support out there. Bob Engler From: Ashish Kumar To: Vaibhav Joshi Cc: "excel-macros@googlegroups.com" Sent: Friday, December 19, 2014 10:35 PM Subject: Re: $$Excel-Macros$$ Re: How t

Re: $$Excel-Macros$$ Re: How to append row from 1 sheet to end of row of second sheet based on cell value

2014-12-23 Thread bobengler
Thank you. It works great. I really appreciate your time and expertise. Bob Engler From: Vaibhav Joshi To: "excel-macros@googlegroups.com" Sent: Saturday, December 20, 2014 1:27 AM Subject: Re: $$Excel-Macros$$ Re: How to append row from 1 sheet to end of ro

$$Excel-Macros$$ Very urgent need of Linux System Admin.

2014-12-23 Thread Mazhar Khan
Hello Associate, I'm Mazhar Khan, with Systel Inc. We've an urgent requirement with one of our client for *Linux System Admin. * *New Albany, OH*. Please find below the job description for the same and revert back to me with your consultant updated profile and contact details at the earliest.

$$Excel-Macros$$ Very urgent need of Sr. Facets Developer.

2014-12-23 Thread Mazhar Khan
Hello Associate, I'm Mazhar Khan, with Systel Inc. We've an urgent requirement with one of our client for *Sr. Facets Developer*. *Eau Claire, WI*. Please find below the job description for the same and revert back to me with your consultant updated profile and contact details at the earliest.

$$Excel-Macros$$ Urgent need of Jr. Net Developer with SSIS, SSRS and SQL

2014-12-23 Thread Mazhar Khan
Hello Associate, I'm Mazhar Khan, with Systel Inc. We've an urgent requirement with one of our client for *Jr. Net Developer with SSIS, SSRS and SQL experience*. *Plymouth, MN*. Please find below the job description for the same and revert back to me with your consultant updated profile and cont

Re: $$Excel-Macros$$ Use of ADO Connection in Excel Macro

2014-12-23 Thread Vaibhav Joshi
Hi Try this... Sub Data_Merge_From_All_Files_SelectFolder_NO_ADO() Dim bookList As Workbook Dim FileName As Variant Dim n As Long Dim disWB As Workbook Set disWB = ActiveWorkbook FileName = Application.GetOpenFilename(filefilter:="Excel Files (*.xl*), *.xl*", MultiSelect:=True) Application.Scre

Re: $$Excel-Macros$$ Use of ADO Connection in Excel Macro

2014-12-23 Thread Zafar Iqbal
Dear Expert, your guidance is needed to solve another problem in this code. I saved this code in Personal.xlb so that it should be available for all new work books. When I open new work book & run code, it is not updating active work book. Rather, it is up-dating data in personal.xlb. No data is

Re: $$Excel-Macros$$ Change date of all cells in an excel column

2014-12-23 Thread Ashish Kumar
Superb Solution Vaibhav Bhai. -- 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 Pleas

Re: $$Excel-Macros$$ Change date of all cells in an excel column

2014-12-23 Thread Vaibhav Joshi
Check this.. Cheers!! + *I did not do this for you. God is here working through me for you.* On Tue, Dec 23, 2014 at 4:46 PM, Aparna wrote: > hi, > > i have a column of around 150 different dates. i need to create a column > where the year of all the dates is same but the month and day are

$$Excel-Macros$$ Change date of all cells in an excel column

2014-12-23 Thread Aparna
hi, i have a column of around 150 different dates. i need to create a column where the year of all the dates is same but the month and day are from the corresponding cell in the original dates column eg. Original Col 08.06.1957 06.05.1963 02.10.1964 20.12.1957 New Col 08.06.2014 06.05

Re: $$Excel-Macros$$ Use of ADO Connection in Excel Macro

2014-12-23 Thread Vaibhav Joshi
Cheers!! + *I did not do this for you. God is here working through me for you.* On Tue, Dec 23, 2014 at 3:01 PM, Zafar Iqbal wrote: > Excellent. Bundle of Thanks You did a great job ... > > > On Tuesday, 23 December 2014 12:27:24 UTC+3, Vabz wrote: > >> Try this then...

Re: $$Excel-Macros$$ Use of ADO Connection in Excel Macro

2014-12-23 Thread Zafar Iqbal
Excellent. Bundle of Thanks You did a great job ... On Tuesday, 23 December 2014 12:27:24 UTC+3, Vabz wrote: > > Try this then... > > Sub Data_Merge_From_All_Files_SelectFolder_NO_ADO() > Dim bookList As Workbook > Dim FileName As Variant > Dim n As Long > > FileName = Applica

Re: $$Excel-Macros$$ Need function help for output of particular list on matching data

2014-12-23 Thread Vaibhav Joshi
Cheers!! + *I did not do this for you. God is here working through me for you.* On Tue, Dec 23, 2014 at 2:51 PM, Ashish Bhalara wrote: > Hi Mr.Vaibhav > Ones again thank you so much for your tremendous job to help me. > > Regards. > Ashish Bhalara > 9624111822 > P*Please do not print this e

Re: $$Excel-Macros$$ Use of ADO Connection in Excel Macro

2014-12-23 Thread Vaibhav Joshi
Try this then... Sub Data_Merge_From_All_Files_SelectFolder_NO_ADO() Dim bookList As Workbook Dim FileName As Variant Dim n As Long FileName = Application.GetOpenFilename(filefilter:="Excel Files (*.xl*), *.xl*", MultiSelect:=True) Application.ScreenUpdating = False For n = LBound(FileName) To U

Re: $$Excel-Macros$$ Need function help for output of particular list on matching data

2014-12-23 Thread Ashish Bhalara
Hi Mr.Vaibhav Ones again thank you so much for your tremendous job to help me. Regards. Ashish Bhalara 9624111822 P*Please do not print this email unless it is absolutely necessary. Spread environmental üawareness.♣♣♣* On Tue, Dec 23, 2014 at 2:31 PM, Vaibhav Joshi wrote: > Hi > > check this..

Re: $$Excel-Macros$$ Need function help for output of particular list on matching data

2014-12-23 Thread Vaibhav Joshi
Hi check this.. Cheers!! + *I did not do this for you. God is here working through me for you.* On Tue, Dec 23, 2014 at 11:17 AM, Ashish Bhalara wrote: > Dear experts, > > I try below function to get output from other sheet on matching data > written in L1 in sheet of 'Letter'. But this f