Fwd: $$Excel-Macros$$ Values Against Max Values

Dear VJ, Please see attachment. Thanks, Noorain Ansari -- Forwarded message -- From: Vj Realsaggi realsa...@gmail.com Date: Tue, Dec 21, 2010 at 9:27 PM Subject: $$Excel-Macros$$ Values Against Max Values To: excel-macros@googlegroups.com Kindly Consider the Previous Mail --

$$Excel-Macros$$ Critical Doubt

Hi! I am Having one query i hope i can free at the end of the session. Please help me we are educational industry maintaining student attendance i am expecting report like this. now a days we are maintaining student attendance in excel 2007 when ever students comming in they are placed X mark

Fwd: $$Excel-Macros$$ Critical Doubt

Dear Joseph, Can u send sample excel sheet.. -- Thanks regards, Noorain Ansari -- Forwarded message -- From: Joseph rvijayanan...@gmail.com Date: Wed, Dec 22, 2010 at 12:21 AM Subject: $$Excel-Macros$$ Critical Doubt To: MS EXCEL AND VBA MACROS excel-macros@googlegroups.com

Re: Fwd: $$Excel-Macros$$ Values Against Max Values

Dear Noorani, Thanks for help, kindly go through my question, Its easy to retrieve Max value but i need Value againt the max value. On Dec 22, 1:18 pm, NOORAIN ANSARI noorain.ans...@gmail.com wrote: Dear VJ, Please see attachment. Thanks, Noorain Ansari -- Forwarded message

Fwd: $$Excel-Macros$$ Excel userform Vlookup List iteam help

-- Forwarded message -- From: vidyut more vidyutm...@gmail.com Date: Sun, Dec 19, 2010 at 10:46 AM Subject: $$Excel-Macros$$ Excel userform Vlookup List iteam help To: excel-macros@googlegroups.com Dear experts I want use userform and in that a list iwant to use iteam from that

$$Excel-Macros$$ how to use the macros in a closed book

Hi Experts Is it possible to use a macro in a workbook to another workbook when that book having the macro is closed.If possible pls let me know how to do it. Regards Rajesh Kainikkara -- -- Some important links

Re: Fwd: $$Excel-Macros$$ Values Against Max Values

Hi Saggi, Please see the attached solution which is now customized as per your need. Thanks. Best Regards, DILIPandey On Wed, Dec 22, 2010 at 3:52 PM, saggi realsa...@gmail.com wrote: Dear Noorani, Thanks for help, kindly go through my question, Its easy to retrieve Max value but i need

$$Excel-Macros$$ Re: Lock the Object

I believe you just need to set the locked object on your item (already done in your sheet), and then put protection on the sheet. (Tools| Protection|Protect Sheet) On Dec 22, 7:08 am, Chandra Shekar chandrashekarb@gmail.com wrote: Hello, How to lock the object? User should not edit the

Re: $$Excel-Macros$$ help required for large range of data filteration

Is it possible that there are some blank rows? Before turning on the autofilter, select the top-left box where the A-Z column heading and row numbers meet. (or hit ctrl-A) then turn on AutoFilter. By default, autofilter only selects the block of data until it reaches a blank row. hope this

Re: $$Excel-Macros$$ xlsb files

The Personal.xlsb Project is only an Excel workbook that is hidden. So.. no, the VBA EDITOR cannot create a new workbook. But you could write some VBA code that can create a new workbook and hide it. If you want to copy Modules from one workbook to another, there is vba code to export and import

Re: $$Excel-Macros$$ help required for large range of data filteration

Excel 2003:- You can see only 1000 records in the Autofilter Dropdown. Not more than that. Excel 2007/2010:- You can see 1 records in the Autofilter Dropdown. Not more than that. So try to use some helper column based on your data criteria use some formula in helper column like Istext,

$$Excel-Macros$$ Need to be able to find duplicates before a space

I have a excel spreadsheet that has model numbers on the start of a column and then a space and a description, what I need to do is be able to have excel find all the duplicate model numbers and highlight them, how should I go about doing this? --

$$Excel-Macros$$ new que - help required for large range of data filteration

hi Guys, have similar kinda que. sometimes when we filter on large data and simply select those rows and delete entire rows i.e. Alt+E+D+R data which is present in those filtered rows also get deleted. what is the reason behind this. From: Ms-Exl-Learner .