Re: $$Excel-Macros$$ == Need help on the sheet

2012-03-30 Thread seema mba
Hi, Your trade ID is not unique. So how do you decide, which in detailed sheet row you need to compare with which row in summary sheet. Example if your trade id is TD20120325, there are multiple rows in detailed sheet with this trade id, so which row do you take as reference for comparision?

Re: $$Excel-Macros$$ Help required for a formula

2011-11-25 Thread seema mba
Hi, PFA. Query Solved. Regards, Seema On Fri, Nov 25, 2011 at 7:02 PM, Kenil Gala keni...@yahoo.com wrote: Hi group, I have a small doubt for writing a formula and require for help for it. i have mentioned my doubt as a comment in the attached file. Thanks Regards -- FORUM RULES

Re: $$Excel-Macros$$ Ayush Jain – Microsoft MVP 20 10

2010-10-05 Thread seema mba
Hi Ayush! You really deserve that title... Regards, Seema On Tue, Oct 5, 2010 at 9:26 AM, Aindril De aind...@gmail.com wrote: Hey Ayush!! You haven't responded to Neil's email Where is the Treat Man!!!? [?][?] Cheers, Andy On Mon, Oct 4, 2010 at 9:17 PM, krishna mummina

Re: $$Excel-Macros$$ Need help in function

2010-04-06 Thread seema mba
Hi, I have attached your sheet with formula for finding the difference in minutes. I have used the formula CONVERT. If the CONVERT function is not available, install and load the Analysis ToolPak add-in. On the Tools menu, click Add-Ins. In the Add-Ins available list, select the Analysis ToolPak

Re: $$Excel-Macros$$ Request Help to make code more efficient.

2010-04-06 Thread seema mba
HI, Try out the following: Sub trial() Dim rng As Range Dim what(9) As String what(1) = FD what(2) = EX what(3) = NA what(4) = NB what(5) = NC what(6) = HN what(7) = CLD what(8) = Location what(9) = of For i = 1 To 9 Do Set rng =

$$Excel-Macros$$ Track changes macro

2010-03-31 Thread seema mba
Hello Master, I have got a macro to track changes made in excel sheet. But the changes are tracked in sheet1 of the same work book. I want a macro which keeps the track of changes, in a different workbook and not the same workbook. In short instead of keeping the log of changes in sheet1 of the