$$Excel-Macros$$ TEXT BETWEEN TWO CELL & DIFFERENCE IN THE THIRD CELL-SAMPLE FILE ATTACHED

Thanks But how this macro works I want the difference in Cell c1 = where it is difference between A1 -B1 the data is in all cells -- that is from A1 TO A15 & B1 TO B15 SO how to copy this formula which is C1 -- TO C2 TO C15. Tks On Thu, Jul 8, 2010 at 10:04 AM, Soni.Rajender wrote: > Hi >

Re: $$Excel-Macros$$ Interview questions

In 4.5 yr experience i don't think anyone going to judge ur excel skill by vlookup n pivot... they will check ur technique abt Data Manipulation n all...n how gud your in Report Automation. -- -- Some important links

$$Excel-Macros$$ Urgent Need help how used macro in excel

Dear All, I have urgent need Help how macro & VB programing use in excel. Kindly send primary level book ( How write Macro & VB Programing script, How compile & Run program & how remove Debug). Kindly guide me. Thanks, Prabhakar Thakur New Delhi +919953736776 -- --

$$Excel-Macros$$ Re: Dynamic Ranges with Vlookup

Hi Ramesh, I have just sent an email with an example of how this can be done. Thanks Alvin Fong On Jul 9, 7:56 pm, Ramesh-Hyderabad wrote: > Hello Gurus, > > 1. Attached is the sample data what we get from the Server > > 2. The raw data might not have all the LEVELS, where as our report > tem

$$Excel-Macros$$ how can I control IE8 tabs from VBA?

I have the need to work with IE8 and TABs. I have found out how to open a new tab, but how can I control which tab I am working with? Thanks -- -- Some important links for excel users: 1. Follow us on TWITTER for t

$$Excel-Macros$$ Run time error 1004

The following macro should activate worksheet Matrix Table then print out some text and then print out the values in the Nstep_tran array. Since I don't have a row counter, I am in the process of working out the formula for the Else case. What follows Else is a place holder. I cannot get the init

$$Excel-Macros$$ Re: Want to convert on Text in each cell to rows

Hi Prashant, I would like to do it in 3 steps. 1. Run this code: Sub Macro1() ActiveWorkbook.SaveAs Filename:="D:\tmp\Book1.txt", FileFormat:=xlText, _ CreateBackup:=False End Sub (sure, you can change path "D:\tmp\Book1.txt" to your own) 2. Open "D:\tmp\Book1.txt" in text edi

$$Excel-Macros$$ Re: Worksheet/workbook events not being triggered

Hi fromeo, So your spreadsheet pulls in data from SQL Server correctly, then populates a sheet "Data" correctly, but doesn't refresh sheet "Pivot" ? Please tell me are you able to refresh "Pivot" sheet manually by pressing Shift+F9 after your sheet "Data" is ready? If yes, all you need is to ad

$$Excel-Macros$$ mortgage calculator

Hi Dears, Can you please tell me how to prepare mortgage calucator macros Regards Sumit Kumar -- -- Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links : http://twitter.com/ex

$$Excel-Macros$$ Re: Required Help

Hi somasekhar, you can use my macros code, it works for me if columns in text file are separate by tab. Change path "D:\Work\090710_1\sample.txt" to your full path. Please report whether it works for you. Sub Macro1() Workbooks.OpenText Filename:="D:\Work\090710_1\sample.txt", Origin:=866, _

Re: $$Excel-Macros$$ Re: WAV FILES DURATION FINDER

See if this helps you http://www.webandmacros.net/excel-macro-list-files.htm Regards Ashish koul http://akoul.blogspot.com On Fri, Jul 9, 2010 at 6:26 PM, Bhasker wrote: > Hi >> >> I am a medical transcriptionist by profession, I am in requirement of one >> tool where i can find the duration

Re: $$Excel-Macros$$ Interview questions

Hi All, Thanks for reply Saggi:- I have 4.5 Yrs experience in MIS and I am going to apply for Sr.\ TL MIS position. Regards, Vijay Kumar Aggarwal On Thu, Jul 8, 2010 at 8:43 PM, saggi wrote: > > I m not sure how many year experience you have in MIS > If its executive level interview

Re: $$Excel-Macros$$ Interview questions

this would help http://www.coolinterview.com/type.asp?iType=220 Warm Regards, Harmeet Singh IT Analyst McKinsey & Company http://www.facebook.com/Harmeeet On Fri, Jul 9, 2010 at 5:09 PM, Soni.Rajender wrote: > Hi > > Questions depends from com

RE: $$Excel-Macros$$ Want to convert on Text in each cell to rows

Hi Prashant, Please give an example of the converted cells Regards - Dave. > Date: Fri, 9 Jul 2010 18:06:07 +0530 > Subject: $$Excel-Macros$$ Want to convert on Text in each cell to rows > From: prashant...@gmail.com > To: excel-macros@googlegroups.com > > Hi all > I want to convert on Text i

$$Excel-Macros$$ Re: WAV FILES DURATION FINDER

> > Hi > > I am a medical transcriptionist by profession, I am in requirement of one > tool where i can find the duration of a set of files, the dictation files > can be in wav, dss, and mp3 format, can anybody help in this regard, I have > a tool it does generate list only for dss and wav not for

$$Excel-Macros$$ Want to convert on Text in each cell to rows

Hi all I want to convert on Text in each cell to rows ? In each Cell has 50 + numbers one below one. e.g. 09:51:18 09:51:31 09:52:04 There are five such columns. Can any one help me to convert to rows? Regards. prashant -- -

Re: $$Excel-Macros$$ Interview questions

Hi Questions depends from company to company, however normally asked topics are: vlookup, date, if condition, pivot table Regards Rajender Soni On Jul 9, 11:27 am, ALAM wrote: > hi! > >          starting from into.. > >   then 1.         Lookup (a,b,c) >        2.         validations >

$$Excel-Macros$$ Dynamic Ranges with Vlookup

Hello Gurus, 1. Attached is the sample data what we get from the Server 2. The raw data might not have all the LEVELS, where as our report template in Sheet2 has all the levels 3. Now, I need to pull the data from Raw Tables to Sheet2 4. Here the range may change whenever we refresh the data fo

$$Excel-Macros$$ Dynamic Ranges with Vlookup

Hello Gurus, 1. Attached is the sample data what we get from the Server 2. The raw data might not have all the LEVELS, where as our report template in Sheet2 has all the levels 3. Now, I need to pull the data from Raw Tables to Sheet2 4. Here the range may change whenever we refresh the data fo

RE: $$Excel-Macros$$ Need code for Sort & Sub-totals

Hi Srinivas, Sample workbook please. Regards - Dave. Date: Fri, 9 Jul 2010 15:11:12 +0530 Subject: Re: $$Excel-Macros$$ Need code for Sort & Sub-totals From: rsrinivasu...@gmail.com To: excel-macros@googlegroups.com Hi all, Can anyone please provide me an update on the below query at the

Re: $$Excel-Macros$$ Need code for Sort & Sub-totals

Hi all, Can anyone please provide me an update on the below query at the earliest. Thanks, Srinivas On Tue, Jul 6, 2010 at 7:45 PM, srinivasulu R wrote: > Hi all, > > Need your help!!! > > I need a code for sorting & sub-totals for the data which keeps > (range) changing every day. > > Could yo

Re: $$Excel-Macros$$ Interview questions

hi! starting from into.. then 1. Lookup (a,b,c) 2. validations 3. More VBA 4. Reports sheets (day/wk/month/year) 5. filter 6. list 7. subtotal AFTAB ALI On 7/9/10, saggi wrote

$$Excel-Macros$$ How to chenge Form Stlye in VBA

hi Group, Can any one help me, to know that how can we chenge Form Stlye in Excel VBA. Currentaly it show a classical look. can i convert it into any onather look (like std or window look). Sample file attech for refrence Pls help -- Pankaj Pandey Bhopal --