$$Excel-Macros$$ Re: Unable to Manipulate tab delimited data

2015-03-30 Thread Mandeep Baluja
dont type -- manually just copy it and replace otherwise replace will not work. On Tuesday, March 31, 2015 at 12:22:54 AM UTC+5:30, Bill Q wrote: > > Thanks, but I must be doing something wrong - becuase it isn;t working for > me. > > On Sunday, 29 March 2015 17:37:58 UTC-4, Bill Q wrote: >> >>

$$Excel-Macros$$ Re: Unable to Manipulate tab delimited data

2015-03-30 Thread Mandeep Baluja
Copy your double code in replace box don't type it it will get easily replaced. On Tuesday, March 31, 2015 at 12:22:54 AM UTC+5:30, Bill Q wrote: > > Thanks, but I must be doing something wrong - becuase it isn;t working for > me. > > On Sunday, 29 March 2015 17:37:58 UTC-4, Bill Q wrote: >> >>

Re: $$Excel-Macros$$ How to show VBA code in *.xlsm format file

2015-03-30 Thread Pramod Singh
Hi There is not vba code. This is just made by custom UI editor. ..there is control by made in Custom UI editor. Pramod On 31 Mar 2015 11:02, "Ashish Bhalara" wrote: > Dear experts, > > I have downloaded some files with macro to editing in ribbon for learning > purpose, but I can't see coding i

$$Excel-Macros$$ How to show VBA code in *.xlsm format file

2015-03-30 Thread Ashish Bhalara
Dear experts, I have downloaded some files with macro to editing in ribbon for learning purpose, but I can't see coding in file. Could you guide me how to show VBA code in attached file. Kindly also know me some books of VBA coding about editing in Excel Ribbon. Thanks in advance Regards. Ashis

$$Excel-Macros$$ How to check a field and change highlight color if the cell value changes

2015-03-30 Thread Bob Engler

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

2015-03-30 Thread bobengler
I could use your expertise again if you are available. I have an excel sheet like below | field 1 | field 2 | field 3 | field 4 | | 1 |

Re: $$Excel-Macros$$ Re: How can I match two different data, where only a reference number and amount are common.

2015-03-30 Thread Faisal Pk
Hi, It can be achieved through pivot table by changing one source amount to negative and another to positive. Attached is a sample which may help you to understand. Regards, Faisal PK On Mon, Mar 30, 2015 at 3:58 PM, Sandeep Chhajer wrote: > Hi, > > You can use VLOOKUP. For more how to use VL

$$Excel-Macros$$ Re: Unable to Manipulate tab delimited data

2015-03-30 Thread Bill Q
Thanks, but I must be doing something wrong - becuase it isn;t working for me. On Sunday, 29 March 2015 17:37:58 UTC-4, Bill Q wrote: > > Attached is a very small sample of a much larger data set. I need to > separate the data - in this case in 3 different and separate columns. For > whatever

$$Excel-Macros$$ Hiring-Facets Developer (Application Support) @Denver,CO [Please send resumes to r...@technotalent.com]

2015-03-30 Thread Rene Mickey
Hi, Hope you are doing great... I come across your profile on Dice Please let me know your interest for below position along with your updated resume (If you are not available please refer this Position) [Please send resumes to r...@technotalent.com] *Position* *Technology:* *Facets

Re: $$Excel-Macros$$ Re: How can I match two different data, where only a reference number and amount are common.

2015-03-30 Thread Sandeep Chhajer
Hi,You can use VLOOKUP. For more how to use VLOOKUP check..Microsoft office help.Sandeep.

$$Excel-Macros$$ Re: How can I match two different data, where only a reference number and amount are common.

2015-03-30 Thread Saddam Ali
sorry i forgot to attach, this is the attachement On Monday, March 30, 2015 at 3:49:00 PM UTC+3, Saddam Ali wrote: > > Kindly find the attached excel work book and possibly assist. i need to > match all the data of the first sheet to the outstanding in the second sheet > > On Monday, March 30, 20

$$Excel-Macros$$ Re: How can I match two different data, where only a reference number and amount are common.

2015-03-30 Thread Saddam Ali
Kindly find the attached excel work book and possibly assist. i need to match all the data of the first sheet to the outstanding in the second sheet On Monday, March 30, 2015 at 12:37:28 PM UTC+3, Saddam Ali wrote: > > My name is Baricha, from Kenya. I work in a bank and so i cannot upload > the

$$Excel-Macros$$ Re: How can I match two different data, where only a reference number and amount are common.

2015-03-30 Thread Maciej Piotrowicz
Hello In both sources add column where you join ref nb and amount like=A1&b1 (where for example in A is ref nb and B ammount) . Then you can use vlookup cos the possibility, I suppose, to non unique values are very small. Do not matter what is the result of given formula, the only witch matters

RE: $$Excel-Macros$$ Begin a Group in vba custom toolbar

2015-03-30 Thread dwbowyer15
Many thanks for the input _ From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com] On Behalf Of Vaibhav Joshi Sent: 30 March 2015 09:21 To: excel-macros@googlegroups.com Subject: Re: $$Excel-Macros$$ Begin a Group in vba custom toolbar Check this for help..

$$Excel-Macros$$ How can I match two different data, where only a reference number and amount are common.

2015-03-30 Thread Saddam Ali
My name is Baricha, from Kenya. I work in a bank and so i cannot upload the data because Its sensitive and also a breach of contract. I normally receive data from two different sources, and i am required to match the two data, the only common features between the 2 data, are the amount and a

Re: $$Excel-Macros$$ Begin a Group in vba custom toolbar

2015-03-30 Thread Vaibhav Joshi
Check this for help.. http://www.vbaexpress.com/kb/getarticle.php?kb_id=427 On Sun, Mar 22, 2015 at 4:33 PM, Don Bowyer wrote: > In Excel 2003 on Windows 7 I have created a custom toolbar using VBA. > > The toolbar has about 7 buttons each of which activates a separate macro. > > This is the

Re: $$Excel-Macros$$ Retrieve data thru VBA Macro..

2015-03-30 Thread Vaibhav Joshi
Hi There are many ways to do it, few are: http://excel.tips.net/T003005_Condensing_Multiple_Worksheets_Into_One.html http://support.microsoft.com/en-us/kb/214270 http://www.bighungrygeek.com/merge-worksheets-in-excel/ http://www.rondebruin.nl/win/addins/rdbmerge.htm Cheers!! On Mon, Mar 30

Re: $$Excel-Macros$$ Copy Data from another application to excel.

2015-03-30 Thread Vaibhav Joshi
hi without any application in front coding can not be set for 3rd party app.. On Fri, Mar 27, 2015 at 2:17 AM, Avinash wrote: > Hi Experts, > > i want a macro which can copy data from another application to excel. > > below is the code which i am trying to use. i dont have any workbook to > ex

Re: $$Excel-Macros$$ Re: Do you want to marry? View Similar Profiles.

2015-03-30 Thread Vaibhav Joshi
Hi This is pertaining to Group "Important Jobs & Walkin Updates", i haven't recd any such emails from Excel VBA Group.. On Mon, Mar 30, 2015 at 1:09 PM, Prabhu Pinky wrote: > Why this kind of mails in this group??? > On 30-Mar-2015 1:00 PM, "Sajini" wrote: > >> * Do you want to marry? View S

$$Excel-Macros$$ Re: Do you want to marry? View Similar Profiles.

2015-03-30 Thread Prabhu Pinky
Why this kind of mails in this group??? On 30-Mar-2015 1:00 PM, "Sajini" wrote: > * Do you want to marry? View Similar Profiles. > * > > > > -- > You received this message because you are subscribed to the Google Groups > "Importan