$$Excel-Macros$$ Fwd: Macro to select particular record based on criteria.

Dear all, Wit reference to my previous mail, i have developed the small code (furnished below). However, what is the flaw in the code is that it overwrites my previous data in sheet 2. Is there any way i could make updation only for fresh data updated today in sheet1 . Thanks in Advance. Regard

Re: $$Excel-Macros$$ Open Internet Explorer automatically from Excel

Thanks, I am trying to fill info into a web form in IE On Mon, Dec 6, 2010 at 9:49 AM, Ken Roedel wrote: > This is most important question to ask: What are you trying to do with IE > from Excel? > > -Ken > > > On Sun, Dec 5, 2010 at 3:28 PM, kanwal_no1 wrote: > >> Hi All, >> >> I am using the

Re: $$Excel-Macros$$ EXCEL SHEET IN SEPARATE TOOL BAR

Dear Expert Can you tell me that what is work of This functions Please. On Sun, Dec 5, 2010 at 11:16 AM, ashish koul wrote: > try this addin save it on your dektop and double click it. > > > On Sun, Dec 5, 2010 at 12:46 AM, ChilExcel wrote: > >> yes >> >> yes, download this application .

$$Excel-Macros$$ Macro to select particular record based on criteria.

Dear All, I have to maintain two excel file/sheet: 1. For outstanding from Customer :It records sale by various office and collection from customer . It has 12 column (Sr.No.1 to 12) and around 3500 rows.The same is updated periodically. 2. Cheque collection File: This file contains selected rec

Re: $$Excel-Macros$$ Sort

Try this Sheet1.Columns(2).Specialcells(xlBlanks).Delete On Sun, Dec 5, 2010 at 6:36 PM, robert peloquin wrote: > Sorry for the multiple post, trying to send an attachment, not sure how to > go about this. > I have a strange sort question. In column B there is information > every > 7 rows.

Re: $$Excel-Macros$$ Open Internet Explorer automatically from Excel

This is most important question to ask: What are you trying to do with IE from Excel? -Ken On Sun, Dec 5, 2010 at 3:28 PM, kanwal_no1 wrote: > Hi All, > > I am using the following portion of a code to open the Internet > Explorer from Excel > > Sub OpenIE() > Dim IE As Object > Dim frmT As Obj

$$Excel-Macros$$ Sort

Sorry for the multiple post, trying to send an attachment, not sure how to go about this. I have a strange sort question. In column B there is information every 7 rows. Then you skip 1 row (Blank) Then there is the same information but with different dates in the next 7 rows and so on. Is it p

$$Excel-Macros$$ Open Internet Explorer automatically from Excel

Hi All, I am using the following portion of a code to open the Internet Explorer from Excel Sub OpenIE() Dim IE As Object Dim frmT As Object Dim doc As Object Dim opt As Object Dim ws1 As Worksheet Dim drop As Integer Set ws1 = Worksheets("Check") Set IE = CreateObject("InternetExplorer.

$$Excel-Macros$$ Re: VVIMP Interview help

Hi Hanumant, Are you going for an EXCEL VBA JOB INTERVIEW? Ya, then how can you miss these two useful links: 1. 3 Things to remember before you go for Excel VBA Job Interview http://www.excelitems.com/2010/12/excel-vba-job-interview-questions.html 2. 50 Excel VBA Oral Interview Questions http://w

$$Excel-Macros$$ Are you going for EXCEL VBA JOB INTERVIEW?

Hi Friends, Are you or your friend is going for an EXCEL VBA JOB INTERVIEW? Yes, then how can you miss these two useful links: 1. 3 Things to remember before you go for Excel VBA Job Interview http://www.excelitems.com/2010/12/excel-vba-job-interview-questions.html 2. 50 Excel VBA Oral Interview

$$Excel-Macros$$ VVIMP Interview help

hey guys i have interview on tue. can somebody pls help me. 1. how can i get to know if specific cell has formula of normal value? 2. can we unzip folder or file using excel maco? i am awake till 4 pls it wud b great if i get the reply b4 that. pls reply soon thanks in advance -- -

Re: $$Excel-Macros$$ Sort

Thanks for your help. File is John Lathe.xls On Dec 4, 9:00 pm, in.vaib...@gmail.com wrote: > Pl send your excel sheet. > > Rgds > > Vaibhav J > Sent on my BlackBerry® from Vodafone > > > > -Original Message- > From: Dick > > Sender: excel-macros@googlegroups.com > Date: Sat, 4 Dec 2010 1

Re: $$Excel-Macros$$ Sort

Thanks for your help. File is John Lathe.xls On Dec 4, 10:14 pm, ashish koul wrote: > can you attach sample sheet.. > > > > > > On Sun, Dec 5, 2010 at 8:11 AM, Dick wrote: > > I have a strange sort question. In column B there is information > > every > > 7 rows. Then you skip 1 row (Blank) Then

Re: $$Excel-Macros$$ Sort

This is my first time uploading files here, I hope I uploaded it to the correct place. File name John Lathe.xls Thanks so much for your help! On Dec 5, 4:24 am, Sanjoy Nath wrote: > pls send your excel sheet. I can prepare the tool for you. > > > > > > On Sun, Dec 5, 2010 at 10:30 AM, wrote: > >

Re: $$Excel-Macros$$ EXCEL SHEET IN SEPARATE TOOL BAR

Hi Ashish, Thanks For sending Sheetnames excel sheet..Great help.. Regards nikhil On Sun, Dec 5, 2010 at 11:16 AM, ashish koul wrote: > try this addin save it on your dektop and double click it. > > On Sun, Dec 5, 2010 at 12:46 AM, ChilExcel wrote: > >> yes >> >> yes, download this applicatio

$$Excel-Macros$$ Search array for value and return into a another array

Hi I have VBA problem I hope you can help me with. I have a two arrays and for each value I want to search in the other array, and then copy the value from the second column in the second array into my first array. I need to fill in column B in Sheet 1 with the corresponding name, leaving it blank

Re: $$Excel-Macros$$ Re: Ctrl + Tilde

Hi Sreedhar, Check whether the buttons are working properly (Cntrl & Tilde buttons) --- Ms.Exl.Learner --- On Fri, Dec 3, 2010 at 10:28 PM, Shreedar Pandurangaiah < shreedar.panduranga...@gmail.com> wrote: > Any help on this would really great. > > Thank

Re: $$Excel-Macros$$ Sort

pls send your excel sheet. I can prepare the tool for you. On Sun, Dec 5, 2010 at 10:30 AM, wrote: > Pl send your excel sheet. > > Rgds > > Vaibhav J > Sent on my BlackBerry® from Vodafone > > -Original Message- > From: Dick > Sender: excel-macros@googlegroups.com > Date: Sat, 4 Dec 2

RE: $$Excel-Macros$$ EXCEL SHEET IN SEPARATE TOOL BAR

really excellent tools, thanks! Tom From: excel-macros@googlegroups.com [mailto:excel-mac...@googlegroups.com] On Behalf Of Nikhil Shah Sent: Sunday, December 05, 2010 5:46 AM To: excel-macros@googlegroups.com Subject: Re: $$Excel-Macros$$ EXCEL SHEET IN SEPARATE TOOL BAR Chilexcel Hi..E

$$Excel-Macros$$ error in macro

Hi Experts, How to solve my problem regarding run time error Sub Go2sheet() myShts = ActiveWorkbook.Sheets.Count For i = 1 To myShts myList = myList & i & " - " & ActiveWorkbook.Sheets(i).Name & " " & vbCr Next i Dim mySht As Single mySht = InputBox("Select sheet no to copy data for report." & vb

Re: $$Excel-Macros$$ Sort

Pl send your excel sheet. Rgds Vaibhav J Sent on my BlackBerry® from Vodafone -Original Message- From: Dick Sender: excel-macros@googlegroups.com Date: Sat, 4 Dec 2010 18:41:13 To: MS EXCEL AND VBA MACROS Reply-To: excel-macros@googlegroups.com Subject: $$Excel-Macros$$ Sort I have a

Re: $$Excel-Macros$$ EXCEL SHEET IN SEPARATE TOOL BAR

Chilexcel Hi..Excellent Tools..it save my time.. Great Utility Regards Nikhil On Sun, Dec 5, 2010 at 12:46 AM, ChilExcel wrote: > yes > > yes, download this application . > http://www.todoexcel.com/office-tabs/ > > > also you can do with "Navigator Toolbar for Workbook Sheets" > http://ww