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 2

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 requir

$$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 c

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 wrote: > Hi! > > I am Having one query i hope i can free at th

$$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 -- -

$$Excel-Macros$$ Re: Regarding Code

Hi Vebhav, Try using below code : Dim lastrow As Integer lastrow = ActiveSheet.Range("A1048576").End(xlUp).Row ActiveSheet.Range("$A$1:$E" & lastrow).AutoFilter Field:=2, Criteria1:=Array( "Account", "As of", "E", "T", "TBR/F", "="), Operator:=xlFilterValues I hope it helps. Let us know if an

$$Excel-Macros$$ how can i import the files in th same format in excel

Hi Experts when importing files i got different formated file, how i can get the data in the same format. Regards Rajesh Kainikkara -- -- Some important links for excel users: 1. Follow us on TWITTER for tips tricks

$$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 wrote: > hi > good evening to all experts > > currentely i am trubling in large ran

$$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", "="), Operator:=

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 wrote: > Hi i have posted this problem two times but got no reply

$$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!!! -- -- So

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

-- Forwarded message -- From: Rajiv Kumar 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 unlocked my excel sheet

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

Hello, Thank you for ur reply. If we right click mouse on the object we can edit the object. Please check it out. On Wed, Dec 22, 2010 at 8:06 PM, JsinSk wrote: > 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.

$$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 : http:/

Re: $$Excel-Macros$$ Recovery plz

send ur file On Tue, Dec 21, 2010 at 10:45 PM, SAJID MEMON wrote: > 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 project. > > sajid m