Re: $$Excel-Macros$$ Recovery plz

send ur file On Tue, Dec 21, 2010 at 10:45 PM, SAJID MEMON sajidwi...@hotmail.comwrote: Dear All, I had made a project in excel and some macro made but i had protected with password and forget the password. How can i recover my VBA password. please give me some tips to accomplish my

$$Excel-Macros$$

Dear sir how can sum with rupees simbol. It yes then please give me tips. Awating your positive replay… Raj -- -- Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links :

Fwd: $$Excel-Macros$$ unlock excel sheet

-- Forwarded message -- From: Rajiv Kumar xlraja...@gmail.com Date: Sat, 18 Dec 2010 19:28:25 +0530 Subject: $$Excel-Macros$$ unlock excel sheet To: excel-macros@googlegroups.com Dear sir, I forget my excel password and how can open my excel sheet so dear sir plz

$$Excel-Macros$$ Filter rows based on a list of values

Hi there, I need to filter rows in a sheet based on a columns matching a list of values. I've tried to play advanced filter but it doesn't seem to fit my needs... Any idea? Many thanks in advance anyway!!! -- --

Re: $$Excel-Macros$$ Is it a Challenge!!!!!

Hi i didnt mean to hurt anybody!! Thanx Daniel for ur friendly support!!! One thing i also want in this file that the calender should take current date time by itself. Thanx Deepak On Fri, Dec 17, 2010 at 10:27 AM, Deepak Rawat deepakexce...@gmail.comwrote: Hi i have posted this problem two

$$Excel-Macros$$ Regarding Code

Hi All, Please can you help me in updating the below code marked in a red color, where data keep varies, so want to have common code. Selection.AutoFilter ActiveSheet.Range($A$1:$E$500).AutoFilter Field:=2, Criteria1:=Array( _ Account, As of, E, T, TBR/F, =),

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

hi experts thanks for ur valuable replays i need more ans if any macros are there can u help me i am trubling this large data Actualy my data having names and codes cobination On Dec 22, 8:28 pm, renuka chari jva.ch...@gmail.com wrote: hi good evening to all experts currentely i am

$$Excel-Macros$$ Re: Query Excel File

Dear Upendra, Well, if your code is working fine to query excel fileYou can use Select distinct * from [RECEIVE$] to pull distinct data from the column. Not sure if it will help you. Write back in case you need something else. Best Regards, Ayush Jain Microsoft MVP --

Re: $$Excel-Macros$$ Critical Doubt

Dear ALL, I am From Ahmedabad.. Do you any expert of Macro and excel who can teach me Macro? (With charges) If any one knows that then please give details for same. Regards, Darshil Shah. On Wed, Dec 22, 2010 at 1:51 PM, Joseph rvijayanan...@gmail.com wrote: Hi! I am Having one query i

$$Excel-Macros$$ Re: Filter rows based on a list of values

Hi there, I need to filter rows in a sheet based on a columns matching a list of values. I've tried to play advanced filter but it doesn't seem to fit my needs... Any idea? Many thanks in advance anyway!!! I sorted it out using MATCH function. I copied my list of values in a column on

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

Hi, When you use filter excel only arranges the data according to the user specified criteria whereas the original data remains the same.When you do delete entire rows the original data gets effected and gets deleted.If you want to delete rows given by the filter after filtering select the

Re: $$Excel-Macros$$ Re: Query Excel File

Hi Ayush, This doesn't help. I've got the correct code: Select Distinct [Market] from [Sheet1$A1:D5000] or SELECT DISTINCT [Column Heading] FROM TableName ORDER BY [ColumnHeading];, (¨`·.·´¨) Keep `·.¸(¨`·.·´¨) Smiling !! (¨`·.·´¨)¸.·´ Upendra Singh `·.¸.·´9910227325 On 23 December 2010