$$Excel-Macros$$ Re: Sort Table as per the order of records in another Table

2009-03-24 Thread Maddy
eadsheet (especially FYI tab) completely and carefully. Hope you can solve my issue. Maddy On Mar 23, 12:12 pm, Harmeet Singh wrote: > Hi Maddy, > > Attched file is updated by Sort function. > > Trust me for one thing. > > Formulas are lot more difficult then VBA , When it comes

$$Excel-Macros$$ Re: Sort Table as per the order of records in another Table

2009-03-24 Thread Maddy
, Dilip Pandey wrote: > Rightly said Harmeet..!! > > -- > DILIP KUMAR PANDEY >   MBA-HR,B COM(Hons.),BCA > Mobile: +91 9810929744 > dilipan...@gmail.com > dilipan...@yahoo.com > New Delhi - 110062 > > On Mon, Mar 23, 2009 at 12:42 PM, Harmeet Singh > wrote: >

$$Excel-Macros$$ Re: Sort Table as per the order of records in another Table

2009-03-22 Thread Maddy
equirements formulas would be better as compare to VBA. > > Feel free to contact for further clarifications or requirements. > > On 3/21/09, Mathan Kumar wrote: > > > > > > > Sorry... Missed to attach the spreadsheet... Here you go...!!! > > > Maddy - ma

$$Excel-Macros$$ Sort Table as per the order of records in another Table

2009-03-21 Thread Maddy
w should be inserted and the Name & ID from sheet PV should be created. I have created a sample spreadsheet and included the instructions too. Hope someone will come up with an excellent code. Looking for that... Thanks in advance for your time and efforts. Mad

$$Excel-Macros$$ Re: COLOR CELLS BY % PERCENTAGE 33% Color one cell 33% , another cell 33%, another cell 34%

2009-03-13 Thread Maddy
t; tab and Select Grey color > Click OK Now, You are done This solution is available with Excel 2003. Reply us, if you have any other questions. Regards, Maddy On Mar 12, 4:51 pm, ExcelUser777 wrote: > HI > > basically i'd like to only show coloring in part of a cell > s

$$Excel-Macros$$ Re: Creating balance sheet from Trial balance

2009-02-23 Thread Maddy
If you could provide us a sample file (spreadsheet) with the sample data that would be great to help you Maddy ma10ku...@gmail.com On Feb 22, 6:50 pm, Sudha wrote: > Hi All, > > I need to create balance sheet from trial balance. Though I know the > logic of doing it, I am

$$Excel-Macros$$ Re: Value in Merged Cells

2009-02-13 Thread Maddy
Try... Merge_Value = Sheets("P2").Range("E2:M2").Value (Assuming the Cells from E2 to M2 are merged) Best Regards, Maddy On Feb 10, 4:04 am, MLT wrote: > I am trying to access the contents in the merged cells E2:M2. > > This works: > Merge_Value= Sheets("P

$$Excel-Macros$$ Re: Mail merge activity from excel to Outlook!!! URGENT!!!!!

2009-01-13 Thread Maddy
If you are aware of basics of VBA coding, please visit the below site: http://www.rondebruin.nl/sendmail.htm Definitely, you will be getting more than what you want... ;) Maddy... On Jan 5, 10:13 am, "shay shay" wrote: > Hello All, > >              I have an excel sh

$$Excel-Macros$$ Re: Hide Formula or data in column

2009-01-13 Thread Maddy
You can apply the background color of the cell (white in general) to the font color and check the hide option from Format > Cells > Protection tab. Now, if you protect the sheet, no one can see those data... Will this work for you? Maddy... On Jan 6, 1:38 pm, "Keyur Shah" wro

$$Excel-Macros$$ Re: Request to help me on the attached file query

2009-01-01 Thread Maddy
Hai, Here is a method to solve your issue. Please check with the below workbook and let me know if you have any other query. http://groups.google.com/group/excel-macros/web/Smart_LookUp.xls?hl=en Happy New Year 2009. Maddy LIFE = IF(Rand()*100<

$$Excel-Macros$$ Re: FIND MACRO

2009-01-01 Thread Maddy
You can get it done with the help of pivot table. Please refer to our earlier thread in the below link: http://groups.google.com/group/excel-macros/t/abb778320b48ea8a?hl=en Still, if you have any queries, please post them. Happy New Year 2009 !!! Maddy On Jan 1, 2:41 pm, Galway wrote