$$Excel-Macros$$ Please Help.................

Dear Experts, How can Hide only workbook but userform should be visilble and work as it, when we click on "*Eng In out Report*" button. Please see attached sheet.. Thanks in Advance -- Thanks & regards, Noorain Ansari -- Thanks & regards, Noorain Ansari -- -

$$Excel-Macros$$ Re: Multiple file Formatting

What format are your report files in? On Apr 26, 11:46 am, "Chidurala, Shrinivas " wrote: > Please help. > > Regards, > Shrinivas > Citi(r) Global Transaction Services - India > UB City, Canberra Block, # 24, Vittal Mallya Road, > Bangalore - 56 00 01. > Ph    - +91-80-4144 6339 / 6340 > Email -

Re: $$Excel-Macros$$ RE: Multiple file Formatting

Hi Srinivas, if all the files are under same folder than u can write an macro which opens each file automatically and then which runs your macro for formatting. You can use fso file object and then you can open each file in the folder using the for next where u can call ur macros Hope this might

Re: $$Excel-Macros$$ help

two vlookup is used to extract data from 2 different data sets first to extract the department based on roll number and then to extract the lecturer name from department data set On Tue, Apr 26, 2011 at 9:19 AM, vijayajith VA wrote: > Thanks > > > Hai > > just i want to know y used VLOOKUP(VLOOKU

RE: $$Excel-Macros$$ Help on Macro

Try, Hello, Try : Sub Import() Dim Enrgt As String, lgRow As Long, Tabl, inCol As Integer Dim inCalculationMode As Integer Application.ScreenUpdating = False inCalculationMode = Application.Calculation Application.Calculation = xlCalculationManual Sheets.Add Close #1 Open "d:\donnees\

Re: $$Excel-Macros$$ Fwd: Data Chart

Hi Kumar, Frankly, the dataset you have, coal accounts for 90% of the total cost..thats the reason you will see only effect of coal. I think considering two charts one with coal vs total cost and the other excluding coal. Krishna On Fri, Apr 8, 2011 at 5:42 AM, C.G.Kumar wrote: > > HI ALL, > >

$$Excel-Macros$$ RE: Multiple file Formatting

Please help. Regards, Shrinivas Citi(r) Global Transaction Services - India UB City, Canberra Block, # 24, Vittal Mallya Road, Bangalore - 56 00 01. Ph- +91-80-4144 6339 / 6340 Email - shrinivas.chidur...@citi.com -Original Message- From: Chidurala, Shrinivas [ICG-GTS] Sent: Monday,

$$Excel-Macros$$ Re: Re: HELP SOS

HI Ashish, I need any Macro or any formula for this. Appreciate you help. Regards, Surendra Singh On Tue, 26 Apr 2011 15:56:41 +0530 wrote > > Waiting for Reply... > > > > Regards, > > Surendra Singh > +91 8982448213 > On Fri, 18 Feb 2011 16:03:51 +0530 wrote > >HI Team, > > > > >

Re: $$Excel-Macros$$ HELP SOS

> > see if this helps > > On Fri, Feb 18, 2011 at 4:03 PM, Surendra wrote: > >> HI Team, >> >> >> >> Please help. >> >> >> Regards, >> >> surendra >> >> Regards, >> >> Surendra Singh >> 9301334795 >> >>

Re: $$Excel-Macros$$ help

Thanks Hai just i want to know y used VLOOKUP(VLOOKUP is used one Vlookup is enough rit? On Mon, Apr 25, 2011 at 9:13 PM, ashish koul wrote: > see if it helps > > name:- =VLOOKUP(A25,A4:$C$8,2,0) > > lecture =VLOOKUP(VLOOKUP(A25,$A$3:$C$8,3,0),$A$13:$C$16,3,0) > > > > >

$$Excel-Macros$$ Re: HELP SOS

Waiting for Reply... Regards, Surendra Singh +91 8982448213 On Fri, 18 Feb 2011 16:03:51 +0530 wrote >HI Team, > > > > Please help. > > > Regards, > > surendra Regards, > > Surendra Singh > 9301334795 Regards, Surendra Singh 9301334795 --

RE: $$Excel-Macros$$ macro to add fill color to a column of selected range

You're welcome. Regards - Dave > Date: Mon, 25 Apr 2011 17:29:30 -0700 > Subject: Re: $$Excel-Macros$$ macro to add fill color to a column of selected > range > From: cje...@yahoo.com > To: excel-macros@googlegroups.com > > > That's excellent Dave. Exactly what I was looking for. > Thanks!! >

Re: $$Excel-Macros$$ Conversion of PDF Data To Excel Sheet

HI BADAL YOU CAN USE ABLE2EXTRACT SOFTWARE TO CONVERT PDF TO WORD/ EXCEL ETC. VIKAS GUPTA 09311334683 On Tue, Apr 26, 2011 at 12:01 PM, BADAL SINGH wrote: > Dear Excel Gurus, > > Please provide me to solve Data from PDF to Excel format with same > Collumns & Rows. > > -- > *BADAL SINGH* > *09631

Re: $$Excel-Macros$$ Need Help

Thank you very much Ashish Ji, very sorry for late reply Redgs ROHAN On Thu, Apr 21, 2011 at 4:00 PM, ashish koul wrote: > rohan > > try this > > =IF(ABS(C3-B3)<=0.1,B3,C3) > > > > > > On Thu, Apr 21, 2011 at 1:49 PM, Rohan Young wrote: > >> Dear Ashish, >> >> please sought it out my problem

$$Excel-Macros$$ Please Complete this Calculator

Hi All, -- -- Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links : http://twitter.com/exceldailytip 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310 3. Exce

Re: $$Excel-Macros$$ Abridged summary of excel-macros@googlegroups.com - 17 Messages in 11 Topics

Sorry Renuka, Not TRIM use Clean Formula. =Clean(A1) TRIM formula use to clean unnecessary space from the text. On Tue, Apr 26, 2011 at 11:12 AM, renuka chari wrote: > thanks to all here i am attaching one sheet here how to remove this > kind of special characters help me plz > > -- > > -

Re: $$Excel-Macros$$ Abridged summary of excel-macros@googlegroups.com - 17 Messages in 11 Topics

Hi Renuka, You can use TRIM formula. Like =TRIM(A1) Thanks and Regards Yogesh Gohil On Tue, Apr 26, 2011 at 11:12 AM, renuka chari wrote: > thanks to all here i am attaching one sheet here how to remove this > kind of special characters help me plz > > -- > > --

Re: $$Excel-Macros$$ Abridged summary of excel-macros@googlegroups.com - 17 Messages in 11 Topics

press ctrl h in find what type *) replace with keep it blank press replace all On Tue, Apr 26, 2011 at 11:12 AM, renuka chari wrote: > thanks to all here i am attaching one sheet here how to remove this > kind of special characters help me plz > > -- > >

$$Excel-Macros$$ Conversion of PDF Data To Excel Sheet

Dear Excel Gurus, Please provide me to solve Data from PDF to Excel format with same Collumns & Rows. -- *BADAL SINGH* *09631444534* -- -- Some important links for excel users: 1. Follow us on TWITTER for tips tri

Re: $$Excel-Macros$$ A VBA Challenge.. (Arrays)

Thnanks alot dear.. it works.. :-) On Mon, Apr 25, 2011 at 12:34 PM, STDEV(i) wrote: > when you say it is a challenge; then you have to have your own good > answer. > > Sub Time_Test_Array2() > > Dim DatRng As Range, LastRow As Long > Dim r As Long, i As Long > > Application.ScreenUpdating = Fal

Re: $$Excel-Macros$$ Abridged summary of excel-macros@googlegroups.com - 17 Messages in 11 Topics

thanks to all here i am attaching one sheet here how to remove this kind of special characters help me plz -- -- Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links : http://twitte