Re: $$Excel-Macros$$ Help Required!

try this macro Sub t() Dim i, j, k As Long For ww = 1 To Worksheets.Count Sheets(ww).Activate For j = 2 To Sheets(ww).Range("a1").End(xlDown).Row If Sheets(ww).Cells(j, 4).Value - DateSerial(Year(Now), Month(Now), Day(Now)) >= 1 Then MsgBox Sheets(ww).Cells(j, 1).Value & " Will Expire in "

Re: $$Excel-Macros$$ Help Required!

Hi Andred, see for example in sheet1 UPS 28-Apr-12 Battery 28-Jul-11 SMPS 2-Jan-11 then i want the meassage box should display message when we open the file --like "ur UPS product will expire in 1 year 0r 365 da

Re: $$Excel-Macros$$ Help Required!

Hello Syed, Let me understand... You have in Sheet1 - UPS, Battery and SMPS Sheet2 - Phone, Data Card, Lenser Sheet3 - Keyboard, Mouse and Monitor You want when the file open, a message like: Ur product UPS will expire in X days Ur product Battery will e

Re: $$Excel-Macros$$ Help in making the list

Dear Sir, Please give me any update. Regards, Ankit On Wed, Apr 27, 2011 at 6:07 PM, Ankit Agrawal wrote: > Dear All, > > I really appriciate your valuable help.you all are really ameging peson. > > I have two different sheets.First is used for giving the PO/SOW(Statement > of Work)no. where I

Re: $$Excel-Macros$$ help

thanks muni On Wed, Apr 27, 2011 at 2:02 AM, Muni wrote: > 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

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

Dear Daniel, Many thanks , its working fine Regards, Prashant -Original Message- From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com] On Behalf Of Daniel Sent: 26 April, 2011 10:23 PM To: excel-macros@googlegroups.com Subject: RE: $$Excel-Macros$$ Help on Macro

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

Re: $$Excel-Macros$$ help

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) On Mon, Apr 25, 2011 at 6:36 PM, vijayajith VA wrote: > hai > > > Please see the attched exl file.. > > i need your help > > thanks > > -- > > -

Re: $$Excel-Macros$$ Help me in this

e the time significantly. > Regards - Dave. > > -- > Date: Sun, 24 Apr 2011 09:03:05 +0530 > Subject: Re: $$Excel-Macros$$ Help me in this > From: yashr...@gmail.com > To: excel-macros@googlegroups.com > > Thanks Dave, for your suggestion. but problem is that i wa

Re: $$Excel-Macros$$ help..

That spreadsheet is proprietary document and password cant be shared to others. :( On Fri, Apr 22, 2011 at 9:44 PM, STDEV(i) wrote: > then you have to ask to the author of the spreadsheet > > > > On Fri, Apr 22, 2011 at 10:19 PM, vamsi varma > wrote: > >> dear friends, >> >> i need some help..

RE: $$Excel-Macros$$ Help me in this

formula: eg: =COUNTIFS(DB_Sheet!$D1:$D30,$A16,DB_Sheet!$E1:$E30,K$2,DB_Sheet!$B1:$B30,$A$74) This MAY reduce the time significantly. Regards - Dave. Date: Sun, 24 Apr 2011 09:03:05 +0530 Subject: Re: $$Excel-Macros$$ Help me in this From: yashr...@gmail.com To: excel-macros

Re: $$Excel-Macros$$ Help me in this

Thanks Dave, for your suggestion. but problem is that i want to update all sheets on daily basis. If i'll do this, it also be take same time. If you have any other idea please share with me. I am also working on it if i will get any solution then i will tell you. Thanks & Regards Yogesh Gohil On

RE: $$Excel-Macros$$ Help me in this

Hi Yogesh, At first glance, I'd say that you just have too many formulas in the workbook, and that most of the calculations should probably be done by VBA rather than worksheet functions. There appear to be some UDF's, but the VBA is protected, so I can't examine them, or make any decision on h

Re: $$Excel-Macros$$ help..

then you have to ask to the author of the spreadsheet On Fri, Apr 22, 2011 at 10:19 PM, vamsi varma wrote: > dear friends, > > i need some help.. > > i need to cal the macro in another spreadsheet. But unfortunately that > spreadsheet is locked. I dont know the name of the macro to cal. > only

RE: $$Excel-Macros$$ Help with micro

Hi, Try : Private Sub CommandButton1_Click() Dim rg As Range If [B5].HasFormula Then Exit Sub Dim inCalculationMode As Integer Application.ScreenUpdating = False inCalculationMode = Application.Calculation Application.Calculation = xlCalculationManual Set rg

Re: $$Excel-Macros$$ Help needed to Protect cells

Sheet is protected and certain cells are unlocked. (The ones you can get to are unlocked). The sheet must be protected or the locked and unlockj feature will not work. On Sat, Apr 9, 2011 at 8:14 AM, Rambabu Mudiraj wrote: > > Dear Friends, > > Help needed in Cells Protection can any one tell me

Re: $$Excel-Macros$$ Help needed to Protect cells

check out this link http://www.techonthenet.com/excel/cells/protect.php On Sat, Apr 9, 2011 at 6:44 PM, Rambabu Mudiraj wrote: > > Dear Friends, > > Help needed in Cells Protection can any one tell me that i cant able to put > cursor in some cells how it is possible i want to know the option > -

Re: $$Excel-Macros$$ Help required in merging two attendance sheets

Hi All, Still waiting for your help... - Original Message - From: Jaideep Panchal To: excel-macros@googlegroups.com Sent: Sunday, April 03, 2011 8:33 PM Subject: $$Excel-Macros$$ Help required in merging two attendance sheets Hi Group, I joined this group few months ag

Re: $$Excel-Macros$$ Help required in merging two attendance sheets

Please attach file, so see what you need I answer for what you need 2011/4/3 Jaideep Panchal > Hi Group, > > I joined this group few months ago and I find it very helpful, I would like > to thank its group Mgr. > > In my org, attendance cycle is 21th to 20th of next month but we need MTD > atte

Re: $$Excel-Macros$$ Help : Formula Required

=IF(OR(HOUR(M14)<7,HOUR(M14)>21),"Yes","No") Rajan On Wed, Mar 30, 2011 at 5:23 PM, wrote: > Hi All, > > I need formula to update column C, value if the time is between 7:00 AM to > 9:00 PM "YES" else "NO" > Find attached for the same. > > Column AColumn BColumn C > DateTim

Re: $$Excel-Macros$$ Help : Formula Required

here is the formula =IF(B2<=(7/24),"Yes",IF(B2>=(21/24),"Yes","No")) On Wed, Mar 30, 2011 at 5:23 PM, wrote: > Hi All, > > I need formula to update column C, value if the time is between 7:00 AM to > 9:00 PM "YES" else "NO" > Find attached for the same. > > Column AColumn BColu

Re: $$Excel-Macros$$ Help in formula to find the top 10 values

Thank for the same -- -- 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=1871

Re: $$Excel-Macros$$ Help : Formula Required

so... make it simplest =IF((B2>=7/24)*(B2<=*21*/24),"NO","YES") On Thu, Mar 31, 2011 at 12:23 AM, JsinSk wrote: > On my response I screwed up the 24 hour time format! Should be 21:00 > instead of 17:00. > > On Mar 30, 1:17 pm, "STDEV(i)" wrote: > > Try this formula > > > > *=IF((B2>=7/24)*(B2

Re: $$Excel-Macros$$ Help : Formula Required

On my response I screwed up the 24 hour time format! Should be 21:00 instead of 17:00. On Mar 30, 1:17 pm, "STDEV(i)" wrote: > Try this formula > > =IF((B2>=7/24)*(B2<=9/24),"NO","YES") > > On Wed, Mar 30, 2011 at 6:53 PM, wrote: > > Hi All, > > > I need formula to update column C,  value if the

Re: $$Excel-Macros$$ Help : Formula Required

Try this formula =IF((B2>=7/24)*(B2<=9/24),"NO","YES") On Wed, Mar 30, 2011 at 6:53 PM, wrote: > Hi All, > > I need formula to update column C, value if the time is between 7:00 AM to > 9:00 PM "YES" else "NO" > Find attached for the same. > > Column AColumn BColumn C > Date

Re: $$Excel-Macros$$ Help in formula to find the top 10 values

Select ten cells starting from B2 to B11, starting from B2. Press F2, and paste =LARGE(VALUE(RIGHT(B2:B886,8)),ROW(B2:B11)-1) and hit CTRL+SHIFT+ENTER Sam On Mon, Mar 28, 2011 at 4:29 PM, Bhushan Sabbani wrote: > Dear All, > > I am facing the problem in the formula of the large to find the top 1

Re: $$Excel-Macros$$ Help on condition and return value

Both ways worked perfectly, but in =MID(B2,2,SEARCH(" ",B2)-2) i had to put =MID(B2,1,SEARCH(" ",B2)-1) in order to give me full word. Thank you both, very much for your help. :), excel-lent as always! 2011/3/24 Ms-Exl-Learner . > Try this… > > > =IF(ISNUMBER(FIND(" ",TRIM(B2))),LEFT(TRIM(B2),F

Re: $$Excel-Macros$$ Help on a simple question

Yes but isn´t that available only to office2010? i use office2007 at work i think it´s retro compatible but only in view form right? Anyway, i have to do a different way now, they decided they what 3 separate files, a database for each report, and my problems now are different, i´m dealing with pr

Re: $$Excel-Macros$$ Help in formula to find the top 10 values

Hi, You can use custom sort option to sort... Regards, Raghunandan M N... 9880379034 On Mon, Mar 28, 2011 at 4:29 PM, Bhushan Sabbani wrote: > Dear All, > > I am facing the problem in the formula of the large to find the top 10. > > Here i am attaching the sample file for the reference. > > Tha

Re: $$Excel-Macros$$ Help in formula to find the top 10 values

your data in B columns are TEXT data, not time data / numbers data so you can pass into LARGE function please try this array formula =TEXT(LARGE(TIMEVALUE(RIGHT(B2:B886,8)),ROW(1:10)),"[hhh]:mm:ss") array formula written on one_column (10 cells) at once !! On Mon, Mar 28, 2011 at 5:59 PM, Bhus

RE: $$Excel-Macros$$ Help on a simple question

You could try Power Pivot to merge and sort your various files into one pivot table or chart. ~Susan From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com] On Behalf Of Jorge Marques Sent: Thursday, March 10, 2011 5:02 AM To: excel-macros@googlegroups.com Subject: $$Exce

Re: $$Excel-Macros$$ Help with replacing Application.FileSearch in macro

File search has been removed after 2003 Version..you may use Dir() for same task.. On Fri, Mar 25, 2011 at 2:34 AM, Dave wrote: > Hi Gurus,, > > I have the following macro that has been working fine for ages in > Excel 2003 and now is giving me "run time error 445 Object doesn't > support this

RE: $$Excel-Macros$$ Help with replacing Application.FileSearch in macro

Hi, Use the following code : Public f As Object, d As Object, i As Long Sub Main() Dim Fso As Object Set Fso = CreateObject("Scripting.FileSystemObject") 'RootFolder is the main folder Set RootFolder = Fso.getfolder("c:\temp\vba") FolderRead RootFolder End Sub Su

Re: $$Excel-Macros$$ Help with replacing Application.FileSearch in macro

Ok , I added Microsoft Scripting Runtime in the refrence, its #5 in the Priority list , but the macro is still not picking up sub-directories. thanks again -- -- Some important links for excel users: 1. Follo

Re: $$Excel-Macros$$ Help with replacing Application.FileSearch in macro

How do i add Microsoft scripting run time reference to this file? thnaks -- -- Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links : http://twitter.com/exceldailytip 2. Join our

Re: $$Excel-Macros$$ Help with replacing Application.FileSearch in macro

I changed the ftdpath as below my production files are on a server so have to put in the address as below, macro runs but does not traverse the sub directories Under the pdf directory below I have directories for years and than months and days. Files are in days folder. ftdpth = \\codebase1

Re: $$Excel-Macros$$ Help with replacing Application.FileSearch in macro

is it giving any errors try this code . i haven't tried it on server. always on my local desktop Sub withsubfolder() Dim fldpth As String fldpth = "ftdpth = \\codebase1\docs\pdf\" Dim r As Long ListFilesInFolder fldpth, True End Sub Sub ListFilesInFolder(SourceFolderName As Strin

Re: $$Excel-Macros$$ Help with replacing Application.FileSearch in macro

press alt f11 goto tool -> references-> select Microsoft scripting run time reference On Fri, Mar 25, 2011 at 10:33 PM, Dave wrote: > How do i add Microsoft scripting run time reference to this file? > > thnaks > -- *Regards* * * *Ashish Koul* *akoul*.*blogspot*.com

Re: $$Excel-Macros$$ Help with replacing Application.FileSearch in macro

please add Microsoft scripting run time reference in the workbook also is it working on the local desktop On Fri, Mar 25, 2011 at 10:20 PM, Dave wrote: > I changed the ftdpath as below my production files are on a server so have > to put in the address as below, macro runs but does not traverse

Re: $$Excel-Macros$$ Help with replacing Application.FileSearch in macro

try the attached macro change fldpth = "D:\my latest data\" this as per ur requirement if you copy the code of( withsubfolder) to other workbook add Microsoft scripting run time reference in that workbook On Fri, Mar 25, 2011 at 6:13 PM, Dave wrote: > Ashish, > > Thanks It works great, can y

Re: $$Excel-Macros$$ Help with replacing Application.FileSearch in macro

Ashish, Thanks It works great, can you please make one change for me I want the macro to start searching from c:\temp\vba always and traverse sub-directories and not ask the operator any questions. thanks, Dave -- ---

Re: $$Excel-Macros$$ Help on condition and return value

Try this… =IF(ISNUMBER(FIND(" ",TRIM(B2))),LEFT(TRIM(B2),FIND(" ",TRIM(B2))),IF(LEN(TRIM(B2))<>0,B2,"")) --- Ms.Exl.Learner --- On Thu, Mar 24, 2011 at 4:20 AM, Jorge Marques wrote: > Hi guys, is there any way i can do to for example if a cell B2 has th

Re: $$Excel-Macros$$ Help on condition and return value

Hi Jorge, You can use the following formula to get the desired output:- =MID(B2,2,SEARCH(" ",B2)-2) Best Regards, DILIPandey On 3/24/11, Jorge Marques wrote: > Hi guys, is there any way i can do to for example if a cell B2 has the > following text "phillips LCD 32"" it returns philips to cell B

Re: $$Excel-Macros$$ Help on TL Recital Snapshot

an *array formula* =IFERROR(INDIRECT(C3)," ") is written in a range C5:H20 at once !! about array formula: http://www.cpearson.com/excel/ArrayFormulas.aspx http://office.microsoft.com/en-us/excel-help/introducing-array-formulas-in-excel-HA001087290.aspx but before you do it, you have to define

Re: $$Excel-Macros$$ Help on TL Recital Snapshot

Hi Noorain, This is a Very good Solution. But i am unable to edit this array. can you pls tell me if i want to use this same concept of array in any other file so how can do this. please give me some more detail about using array formula in excel. On Fri, Mar 18, 2011 at 10:51 AM, NOORAIN ANSAR

Re: $$Excel-Macros$$ Help on TL Recital Snapshot

Dear Lucky, Please see attached sheet.. Rgds, Noorain Ansari On Thu, Mar 17, 2011 at 3:48 PM, lucky singh wrote: > > Hi Team, > > need your help on the attached file on sheet one.. > > > need a summary TL wise on sheet one... > > > Thanx & Regards, > Lucky > > -- > > --

Re: $$Excel-Macros$$ Help on a simple question

Thousands sorry ashish koul, this was a draft mail i sent by mistake, it was previous to "$$Excel-Macros$$ Help on merging certain sheets to final workbook" > can you send the sample file of three reports with headers and final > output > > > > On Thu, Mar 10, 2011 at 6:32 PM, Jorge Marques wrote

Re: $$Excel-Macros$$ Help on a simple question

can you send the sample file of three reports with headers and final output On Thu, Mar 10, 2011 at 6:32 PM, Jorge Marques wrote: > I have a doubt dear friends, i have 3 reports i receive each month, so > every month i have to to an overall report of the 3 like a database, but the > format of

Re: $$Excel-Macros$$ Help on pivot table

hi jorge try this created a macro which will merge data from first 3 shees like in all data sheet you have to add the headers manually and run the macro also added pivot in last sheet see if that helps On Fri, Mar 11, 2011 at 2:23 AM, Jorge Marques wrote: > Hi, is it possible to do a pivot

Re: $$Excel-Macros$$ Help in Excel

find the file it is done On Wed, Mar 9, 2011 at 4:04 PM, Rajiv Kumar wrote: > > > -- > *Thanks & Regards > > * > *Rajiv Kumar > * > *Mawana Sugar Works, Mawana > * > *Mo.No: 09027414899* > > > -- > > -- > Some import

Re: $$Excel-Macros$$ Help in Excel

Hi this link will help u http://office.microsoft.com/en-us/excel-help/how-to-look-up-a-value-in-a-list-and-return-multiple-corresponding-values-HA001226038.aspx On Wed, Mar 9, 2011 at 4:07 PM, Rajiv Kumar wrote: > > Dear Sir. > > > Please Experts I have duplicates data from one column so how

Re: $$Excel-Macros$$ Help on merging certain sheets to final workbook

can you attach the source and output sheet On Mon, Mar 7, 2011 at 6:13 PM, Jorge Marques wrote: > Ah, how can i stop a macro from copying a sheet to another if the > difference there´s more than 3 blank cells in a row? > > 2011/3/7 Jorge Marques > > Hi, i need your help friends, >> in a earlie

Re: $$Excel-Macros$$ Help on merging certain sheets to final workbook

Ah, how can i stop a macro from copying a sheet to another if the difference there´s more than 3 blank cells in a row? 2011/3/7 Jorge Marques > Hi, i need your help friends, > in a earlier post we defined a merge from differents books to a single > workbook, it excellent, i have a doubt, i have

Re: $$Excel-Macros$$ help with formating

thanks Chilexcel From: ChilExcel To: excel-macros@googlegroups.com Sent: Fri, March 4, 2011 11:53:45 PM Subject: Re: $$Excel-Macros$$ help with formating with conditional formatting you just have to change% for conditions 1,2,3 chilexcel 2011/3/4

Re: $$Excel-Macros$$ Help needed - Extract data by customer name

Hi Pawel, Thanks for your hlep. But this is not exactly what I wanted. The extracted data should automatically updated when I enter new data in sheet1. I think it can be done using pivot table but i would like to implement this using vba. Regards, San On Sat, Mar 5, 2011 at 12:11 PM, pawel lup

Re: $$Excel-Macros$$ Help needed - Extract data by customer name

Hi Mate, See attachement I've done it in two ways. First by PIVOT TABLE, second by function. Try if it helps. Regards, Pawel From: San Pat To: excel-macros Sent: Sat, March 5, 2011 2:28:42 AM Subject: $$Excel-Macros$$ Help needed - Extract data by customer

Re: $$Excel-Macros$$ Help needed - Extract data by customer name

Yes, but I am trying implement this by macro not pivot table. Regards, San On Sat, Mar 5, 2011 at 4:52 AM, Jorge Marques wrote: > You want to pass the values to sheet2 like it is in there right A Total > etc and then each time there´s a new costumer besides the one that are > there already th

RE: $$Excel-Macros$$ help needed

@googlegroups.com Subject: Re: $$Excel-Macros$$ help needed I have macros to consolidate or merge Excel worksheets and workbooks if anyone needs them let me know but it is better to know the tools of Excel, then use macros chilexcel 2011/3/3 ChilExcel Please see attachment and tell me

Re: $$Excel-Macros$$ Help needed - Extract data by customer name

You want to pass the values to sheet2 like it is in there right A Total etc and then each time there´s a new costumer besides the one that are there already there, it automatically inserts the new costumer in sheet2 with same criterias? 2011/3/5 San Pat > Hi Friends, > > I have row data in th

Re: $$Excel-Macros$$ help with formating

with conditional formatting you just have to change% for conditions 1,2,3 chilexcel 2011/3/4 pawel lupinski > Hi All, > I realy need your help with formating of the cells. see inside. > Thanks > Pawel > > -- > > ---

Re: $$Excel-Macros$$ help with formating

Thanks Mate, its great From: STDEV(i) To: excel-macros@googlegroups.com Cc: pawel lupinski Sent: Fri, March 4, 2011 6:31:35 PM Subject: Re: $$Excel-Macros$$ help with formating see inside if it help On Fri, Mar 4, 2011 at 8:33 PM, pawel lupinski wrote

Re: $$Excel-Macros$$ Help in Data validation

Hi find the attachment and revert if it is not what you want. -- *Thanks & Regards Thamu * On Wed, Mar 2, 2011 at 11:54 AM, naresh v wrote: > Hi Rambabu, > > please find the solution.. > > > Regards, > Naresh V, > Analyst > Hyderabad. > > On Wed, Mar 2, 2011 at 3:08 AM, Vino

Re: $$Excel-Macros$$ help needed

I have macros to consolidate or merge Excel worksheets and workbooks if anyone needs them let me know but it is better to know the tools of Excel, then use macros chilexcel 2011/3/3 ChilExcel > Please see attachment and tell me ... > > chilexcel > > > > > 2011/3/3 ChilExcel > >> hi >> >>

Re: $$Excel-Macros$$ help needed

if you need separate sheet or day must use "consolidate" on an individual basis sheet or day should not selecting all the sheets chilexcel 2011/3/3 ChilExcel > hi > > you must use "consolidate" > look at this link > > > http://www.techrepublic.com/article/create-a-summary-report-in-exce

Re: $$Excel-Macros$$ Help in Data validation

Hi Rambabu, please find the solution.. Regards, Naresh V, Analyst Hyderabad. On Wed, Mar 2, 2011 at 3:08 AM, Vinod N wrote: > Hi Rambabu, > I was able to derive the result using formula but was unable to do the same > through validation. PFA the stop-gap solution. > Hope the 

Re: $$Excel-Macros$$ Help in Data validation

Hi Rambabu, I was able to derive the result using formula but was unable to do the same through validation. PFA the stop-gap solution. Hope the solution is of some help to you... :) Thanks Vinod On Tue, Mar 1, 2011 at 5:31 PM, Rambabu Mudiraj wrote: > Dear All, > > Can anybody help me on this

Re: $$Excel-Macros$$ Help, please, with debugging a function

Dave, I use a version of this code to examine the "white space" in a file to see if it is empty- if empty, I delete that range, and reduce file size. So if the code locates a cell that is populated either with a number or formula, it moves the cell pointer to that cell so I can determine if that ce

Re: $$Excel-Macros$$Help me with positioning of graphics MACRO.

Thanks Daniel for helping me solve my problem. Hector 2011/2/22 Daniel > To place the top left part of the chart in , say, D15 : > > > > ActiveChart.Parent.Top = Range("D15").Top > > ActiveChart.Parent.Left = Range("D15").Left > > > > HTH > > Daniel > > > > *De :* excel-macros@googlegroups.com

RE: $$Excel-Macros$$Help me with positioning of graphics MACRO.

To place the top left part of the chart in , say, D15 : ActiveChart.Parent.Top = Range("D15").Top ActiveChart.Parent.Left = Range("D15").Left HTH Daniel De : excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com] De la part de Hector Ruiz Envoyé : lundi 21 février 2011 2

Re: $$Excel-Macros$$ Help needed to extract data by MM/Year

Thanks this is what I was looking for! On Fri, Feb 18, 2011 at 11:36 PM, ashish koul wrote: > > see if it helps > > On Sat, Feb 19, 2011 at 11:13 AM, San Pat wrote: > >> Hi Group, >> >> I need a urgent help to extract data by given MM/Year from a raw data. >> >> Basically, I am looking for a ma

Re: $$Excel-Macros$$ Help required in excel

Hi Jitender, it's done without using vba coding just change CODE On Mon, Feb 21, 2011 at 8:50 PM, Jitender kumar wrote: > > > On 21 February 2011 10:25, anil panchal wrote: > >> please send sample file. >> >> >> On Sun, Feb 20, 2011 at 10:05 PM, jaibeersingh panwar < >> panwar.jaibeersi...@gma

Re: $$Excel-Macros$$ Help required in excel

On 21 February 2011 10:25, anil panchal wrote: > please send sample file. > > > On Sun, Feb 20, 2011 at 10:05 PM, jaibeersingh panwar < > panwar.jaibeersi...@gmail.com> wrote: > >> Hi Jitendra, >> >> If you have that excel sheet forward it to us.. empty one will do.. >> Regards, >> Jaibeer >> >>

Re: $$Excel-Macros$$ Help required in excel

please send sample file. On Sun, Feb 20, 2011 at 10:05 PM, jaibeersingh panwar < panwar.jaibeersi...@gmail.com> wrote: > Hi Jitendra, > > If you have that excel sheet forward it to us.. empty one will do.. > Regards, > Jaibeer > > > On Sun, Feb 20, 2011 at 4:38 PM, Jitender kumar > wrote: > >>

Re: $$Excel-Macros$$ Help required in excel

Hi Jitendra, If you have that excel sheet forward it to us.. empty one will do.. Regards, Jaibeer On Sun, Feb 20, 2011 at 4:38 PM, Jitender kumar wrote: > Dear Excel Guru, > > 1. I have address book in Excel in following format. How to print 15 > address label in A4 paper Sticker using excel.Pl

Re: $$Excel-Macros$$ Help required in excel

DEAR TEAM /EXCEL EXPERTS PLZ HELP ME REGARDS JITENDER On 20 February 2011 16:38, Jitender kumar wrote: > Dear Excel Guru, > > 1. I have address book in Excel in following format. How to print 15 > address label in A4 paper Sticker using excel.Pl attach a sample sheet(if > uses VBA or else) >

Re: $$Excel-Macros$$ Help required in excel

DEAR TEAM PLZ HELP ME THANKS JITENDER On 20 February 2011 16:38, Jitender kumar wrote: > Dear Excel Guru, > > 1. I have address book in Excel in following format. How to print 15 > address label in A4 paper Sticker using excel.Pl attach a sample sheet(if > uses VBA or else) > > S.no

Re: $$Excel-Macros$$ Help needed to extract data by MM/Year

see if it helps On Sat, Feb 19, 2011 at 11:13 AM, San Pat wrote: > Hi Group, > > I need a urgent help to extract data by given MM/Year from a raw data. > > Basically, I am looking for a macro which will extract data from the raw > data for a given MM/Year. See the attached reference sheet. > > Re

RE: $$Excel-Macros$$ Help, please, with debugging a function

Hi, The logic appears to be a bit weird: If Not IsEmpty(rCell) Or HasDependents(rCell) = True Then Range(rCell.Address).Select Exit Sub End If If the first cell in the selected range is not empty, or has dependents, then that cell is selected, and the sub exits. What do you actually want the ma

Re: $$Excel-Macros$$ HELP SOS

see if this helps or you want to do it by macro 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 SOS

Just a little piece of advice: A subject line of: HELP SOS does nothing to get the right person to look at your problem. Some people are experts in Pivot Tables, Some, know a lot about Date issues. Others read in Text files, or report from external databases. MANY are very busy and only open quest

Re: $$Excel-Macros$$ help pls : find first non empty row in range

thanks!!! From: danial mansoor To: excel-macros@googlegroups.com Sent: Wed, February 9, 2011 4:02:58 AM Subject: RE: $$Excel-Macros$$ help pls : find first non empty row in range use this formula with NOT ONLY PRESS ENTER,PRESS CONTROL+SHIFT+ENTER its an

Re: $$Excel-Macros$$ help pls : find first non empty row in range

thanks a lot!!! superb From: ashish koul To: excel-macros@googlegroups.com Sent: Wed, February 9, 2011 5:33:44 AM Subject: Re: $$Excel-Macros$$ help pls : find first non empty row in range check the attachment On Wed, Feb 9, 2011 at 8:32 AM, danial

Re: $$Excel-Macros$$ help pls : find first non empty row in range

check the attachment On Wed, Feb 9, 2011 at 8:32 AM, danial mansoor wrote: > use this formula with NOT ONLY PRESS ENTER,PRESS CONTROL+SHIFT+ENTER its an > array formula it ll give u 7 answer.u > > =MAX(IF(E17:E26>0,E17:E26)) > > > > > > > > Date: Tue, 8 Feb 2011 17:05:33 -0800 > > Subject: $$Ex

RE: $$Excel-Macros$$ help pls : find first non empty row in range

use this formula with NOT ONLY PRESS ENTER,PRESS CONTROL+SHIFT+ENTER its an array formula it ll give u 7 answer.u =MAX(IF(E17:E26>0,E17:E26)) > Date: Tue, 8 Feb 2011 17:05:33 -0800 > Subject: $$Excel-Macros$$ help pls : find first non empty row in range > From: lupins...@yahoo.com > To: e

Re: $$Excel-Macros$$Help with macros automatic formulas.

Thank you Umesh for helping me with the solution ... I use Excel 2007 in Spanish. Regards Hector Ruiz 2011/2/3 Umesh Dev > Hi Hector, > > Change the formula to IF(ISBLANK(D2),(B2-A2)*24,(D2-B2)*24) in the vba you > have mentioned is esblanco > > > Regards > Umesh Dev > > On Thu, Feb 3, 20

Re: $$Excel-Macros$$Help with macros automatic formulas.

Hi Hector, Change the formula to IF(ISBLANK(D2),(B2-A2)*24,(D2-B2)*24) in the vba you have mentioned is esblanco Regards Umesh Dev On Thu, Feb 3, 2011 at 2:01 AM, Hector Ruiz wrote: > Hi all, I made a macro to do a consultation with automatic cell ranges, > with letters running but when t

Re: $$Excel-Macros$$Help with macros automatic formulas.

Hi, Coild the problem be the fact that the calculation option is on manual? Greets Peter 2011/2/2 Hector Ruiz > Hi all, I made a macro to do a consultation with automatic cell ranges, > with letters running but when the result is number does not work, I have > to double click to run the Forumu

Re: $$Excel-Macros$$ Help With UserForms

Thu, 27 January, 2011 11:36:44 PM *Subject:* Re: $$Excel-Macros$$ Help With UserForms I am amazed at what you have accomplished very simply but I do not understand where you are storing the information in the Combobox1 and combobox2 for the drop down selection process Please help - I really th

Re: $$Excel-Macros$$ Help With UserForms

and it or not. i am sleepy going to bed :) From: BJthebear To: MS EXCEL AND VBA MACROS Sent: Thu, 27 January, 2011 11:36:44 PM Subject: Re: $$Excel-Macros$$ Help With UserForms I am amazed at what you have accomplished very simply but I do not understand where

Re: $$Excel-Macros$$ Help with nested Vlookup

I'm having a TERRIBLE time attempting to send my test file to anyone or this group. My company email client won't allow it to go through. SO...I'll attempt to show an example of my request within this posting. WITH PRINCIPAL Dates Match Dates Do Not Match STATUS E

Re: $$Excel-Macros$$ Help With UserForms

Hello Hanumant Thanks a lot for your efforts. As always, this group has once again helped me to quickly solve my problems within the shortest possible time. Yes, I agree that many data validations are yet to be done. However, ideas are bouncing off me as I progress. Hopefully, ideas at a late

Re: $$Excel-Macros$$ Help With UserForms

Hello Brian In fact, I was similarly looking for the drop down selection process in the Combobox1 and Combobox2 to understand it better myself. I too, was unable to decipher the code suitably. But to be honest, I have not looked at the code in detail. I was rather hoping to do it over the wee

Re: $$Excel-Macros$$ Help With UserForms

this macro is adding the data to combo box before you make form visible if you check sheet1 cell d23 , d24, etc or a23, a24 its having values these values are added to combobox1 Sub OpenDetails() Dim i As Long For i = 23 To Sheets(1).Range("d23").End(xlDown).Row With OrderForm.ComboBox1 .AddIt

Re: $$Excel-Macros$$ Help with nested Vlookup

>From your email client just send an email to excel-macros@googlegroups.comwith the same subject line mentioned in this mail. We all will receive it in the group! Best Regards! Prakash Singh Gusain *Please visit my blog (**click here **)* On Thu, Jan 27, 2011

Re: $$Excel-Macros$$ Help With UserForms

I am amazed at what you have accomplished very simply but I do not understand where you are storing the information in the Combobox1 and combobox2 for the drop down selection process Please help - I really think I would benefit in my programming by utilising Userforms but I have always shied away

Re: $$Excel-Macros$$ Help with nested Vlookup

I'm using Excel 2007 and would use EITHER excel function or VBA! :o) On Jan 27, 11:55 am, Paul Schreiner wrote: > What version of Excel are you using (Excel 2007 has some additional options) > > Are you hoping for a "Excel Function" solution or a VBA solution? > > Paul > > __

RE: $$Excel-Macros$$ Help with nested Vlookup

Using Excel 07, but will use ANY suggestion, including VBA!! From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com] On Behalf Of Paul Schreiner Sent: Thursday, January 27, 2011 11:56 AM To: excel-macros@googlegroups.com Subject: Re: $$Excel-Macros$$ Help with nested Vlookup

<    5   6   7   8   9   10   11   12   13   14   >