Re: $$Excel-Macros$$ Turning repating data in a Row into a sigle column

2014-05-03 Thread koul . ashish
Can u please share a sample file ? Sent on my BlackBerry® from Vodafone -Original Message- From: Freddy Sender: excel-macros@googlegroups.com Date: Sat, 3 May 2014 20:04:03 To: Reply-To: excel-macros@googlegroups.com Subject: $$Excel-Macros$$ Turning repating data in a Row into a sigle

$$Excel-Macros$$ Turning repating data in a Row into a sigle column

2014-05-03 Thread Freddy
I have a file with either 3 or 5 fields as follows: id-number, husband's name, husband's birthday, possibly spouse name and possibly spouse birthday. I am trying to an automated procedure construct a master list of all names and birthdays in one set of columns. Can anyone help me find an a

$$Excel-Macros$$ changed email address

2014-05-03 Thread isabelle_mamet
Please note that due to excessive Spam, I had to change my email address from isabelle_ma...@edev.co.uk to isabelle-ma...@edev.co.uk (- instead of _)   A cause d'un exces de spam, j'ai du changer mon adresse email de isabelle_ma...@edev.co.uk a isabelle-ma...@edev.co.uk (remplacer le _ par -)

Re: $$Excel-Macros$$ Unique name requirement without use advance filter in macro

2014-05-03 Thread Vaibhav Joshi
HTH On Sat, May 3, 2014 at 7:48 PM, Vaibhav Joshi wrote: > Hi > > Do you want using UDF or thru MACRO fetching result. > > Thx > > > > On Sat, May 3, 2014 at 7:01 PM, kapil Gupta wrote: > >> Thanks for a reply but i want answer by using vba. >> >> Regards, >> Kapil Gupta >> >> On Thursday, M

Re: $$Excel-Macros$$ Unique name requirement without use advance filter in macro

2014-05-03 Thread Vaibhav Joshi
Hi Do you want using UDF or thru MACRO fetching result. Thx On Sat, May 3, 2014 at 7:01 PM, kapil Gupta wrote: > Thanks for a reply but i want answer by using vba. > > Regards, > Kapil Gupta > > On Thursday, May 1, 2014 11:40:05 AM UTC+5:30, Vabz wrote: > >> PFA >> >> Cheers!! >> >> >> On Th

Re: $$Excel-Macros$$ Macro to look for x in Columns and paste data in worksheet in various folders

2014-05-03 Thread Vaibhav Joshi
Remove space from name of folder. It should be "Folder5" & not "Folder 5". Thx On Sat, May 3, 2014 at 5:14 PM, prkhan56 wrote: > Hello Vaibhav > > When I run the macro > > I get this error: Run time 1004 > > Microsoft Excel cannot access the file C:\Test\Macro\Folder 5….*.I don’t > know how

Re: $$Excel-Macros$$ Unique name requirement without use advance filter in macro

2014-05-03 Thread kapil Gupta
Thanks for a reply but i want answer by using vba. Regards, Kapil Gupta On Thursday, May 1, 2014 11:40:05 AM UTC+5:30, Vabz wrote: > > PFA > > Cheers!! > > > On Thu, May 1, 2014 at 3:38 AM, kapil Gupta > > wrote: > >> >> >> Hi, >> >>Please Unique name requirement using macro but without usin

Re: $$Excel-Macros$$ Macro to look for x in Columns and paste data in worksheet in various folders

2014-05-03 Thread prkhan56
Hello Vaibhav When I run the macro I get this error: Run time 1004 Microsoft Excel cannot access the file C:\Test\Macro\Folder 5….*.I don’t know how Folder 5 is coming here please* The following gets highlighted .SaveAs "C:\Test\Macro\" & FolderName & "\" _ & c.Value &

Re: $$Excel-Macros$$ Conditional formatting for color cell

2014-05-03 Thread Vaibhav Joshi
Hi I guess this is what you are looking for. Cheers!! On Fri, May 2, 2014 at 6:44 PM, amar takale wrote: > > > -- > 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/discusse