Re: $$Excel-Macros$$ 10 Ways to Use Magical INDIRECT Function

Sir, Could you plz explain how did you got the pic in worksheet 3 from worksheet 4 as the function yields to 0 when pasted in other area. Regards, C.G.Kumar On Mon, Nov 14, 2011 at 11:58 PM, NOORAIN ANSARI wrote: > Dear Group, > > Please find attached Sheet to use 10 Simple way to use Indire

$$Excel-Macros$$ Indirect formula

Hi, Any one please explain why these quotes are used in this formula =SUMIF(INDIRECT("'"&B$5&"'!A:A"),$A6,INDIRECT("'"&B$5&"'!I:I")) Regards Smitha -- FORUM RULES (934+ members already BANNED for violation) 1) Use concise, accurate thread titles. Poor thread titles, like Please

Fwd: $$Excel-Macros$$ Query on dd-mm & mm-yy format

Hello Friends, Following some additional clues I found to sort this issue & I think will need good macro to solve the problem. Step by step clues : 1) Identify the cells which have year 2000 & same cells should be converted into "mm-yy" TEXT format. 2) Identify the cells which have mm-dd-yy forma

Re: $$Excel-Macros$$ 10 Ways to Use Magical INDIRECT Function

Sorry I zsee I forgot my name   Thanks, David Lanne From: David Lanne To: "excel-macros@googlegroups.com" Sent: Tuesday, November 15, 2011 1:09 AM Subject: Re: $$Excel-Macros$$ 10 Ways to Use Magical INDIRECT Function Thanks for the guide, I'm trying to do some

Re: $$Excel-Macros$$ 10 Ways to Use Magical INDIRECT Function

Thanks for the guide, I'm trying to do something similiar to example 3 but I can't seem to get my =getphoto cell (C3) to be a picture. Result comes up 0. I can't seem to get my C3 to accept/format the pic.   My formula is =indirect("Logos!B"&match('newspaper headlines'!$F$3,Logos!$A$:$A$,0)) My

Re: $$Excel-Macros$$ 10 Ways to Use Magical INDIRECT Function

Thanks JP, Currently i m working on below mentioned formula with various live examples Thanks & regards, Noorain Ansari *http://excelmacroworld.blogspot.com/* *http://noorain-ansari.blogspot.com/* On Tue, Nov 15, 2011 at

$$Excel-Macros$$ Query on dd-mm & mm-yy format

Hello Friends, Find attached excel file for ref. I'm using one software which list out required material for structure in excel. Output of that excel file converts some length of "Ft-In" format in "mm-dd-yy or mm-yy" format. Ex: For Length 10-11, excel shows Nov-11 & For length 11-10, excel shows

Re: $$Excel-Macros$$ 10 Ways to Use Magical INDIRECT Function

Hey Noorain, Superb Job!!! When ever you find time & who ever knows on this can help us out on : Address, Index, Match,Offset, Rows & Columns formulas the same stuff as you did now!! Cheers JP. On Mon, Nov 14, 2011 at 11:58 PM, NOORAIN ANSARI wrote: > Dear Group, > > Please find attached She

Re: $$Excel-Macros$$ Need help on Micro Button!!!!!!!!!!!!!!!!!!!

Hey Thanks Sam It's working.. * * *Regards,* *Jocky* On Mon, Nov 14, 2011 at 8:30 PM, Sam Mathai Chacko wrote: > Use this code in Sheet1 VBA code module > > Private Sub CommandButton1_Click() > ActiveSheet.Range("B4:B32").EntireRow.Hidden = Not > ActiveSheet.Range("B4:B32").EntireRow

Re: $$Excel-Macros$$ 10 Ways to Use Magical INDIRECT Function

Dear Noorain Pl tell me following formula - Highlight ( Example 9 - Sheet ) =*_xlfn.* IFERROR(VLOOKUP($E$10,$AF$2:$AW$40,MATCH($A$26,$AF$1:$AW$1,0)+1,0),"0") again error in E10 , E14 , E16 , E18 . seems you have linked with another sheet. you have linked with Leave_calcualtor(1).xls with Exampl

Re: $$Excel-Macros$$ 10 Ways to Use Magical INDIRECT Function

That example is using an external file so the defined name shows ref Don Guillett SalesAid Software dguille...@gmail.com From: Nikhil Shah Sent: Monday, November 14, 2011 12:43 PM To: excel-macros@googlegroups.com Subject: Re: $$Excel-Macros$$ 10 Ways to Use Magical INDIRECT Function Dear Noor

Re: $$Excel-Macros$$ 10 Ways to Use Magical INDIRECT Function

Dear Noorain Excellent Help. Example 9 - Sheet is showing some error...Can you rectify ? I am using Office Excel 2003. Thanks in advance Nikhil On Mon, Nov 14, 2011 at 11:58 PM, NOORAIN ANSARI wrote: > Dear Group, > > Please find attached Sheet to use 10 Simple way to use Indirect Function

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

Here's a link that is on the same lines http://www.excelfox.com/forum/f2/excel-template-macro-sending-mails-attahment-thru-outlook-142/ Regards Sam Mathai Chacko On Mon, Nov 14, 2011 at 8:33 PM, NOORAIN ANSARI wrote: > Dear Sanju, > > Please see attached Sheet, I hope it will help to u. > > Su

Re: $$Excel-Macros$$ Open Worksheet if Filepath verified

And for that you could use ENVIRON$("USERNAME") Regards, Sam On Mon, Nov 14, 2011 at 6:58 PM, Paul Schreiner wrote: > If you want to tie it to the WORKSTATION, then here's what I'd suggest: > > First, send him a file that contains the macro: > > Sub auto_open() > If (Sheets(1).Range("A1").Va

Re: $$Excel-Macros$$ Open Worksheet if Filepath verified

If you want to tie it to the WORKSTATION, then here's what I'd suggest: First, send him a file that contains the macro: Sub auto_open()     If (Sheets(1).Range("A1").Value = "") Then Range("A1").Value = Environ$("computername") End Sub and have him save it and return it to you (that will give y

Re: $$Excel-Macros$$ Open Worksheet if Filepath verified

Be advised that this approach would only prevent "Aggies" or people who don't know how to use excel, from seeing all sheets even if protected with VERYhidden thru code. Suggest each have their own workbook and you get data as needed from it thru a macro. Don Guillett SalesAid Software dguill

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

Hi, Can anybody help me with macros for mass mailing from given list of email id's with select data from data sheet. Rgds Sanju Kanery On Mon, Nov 14, 2011 at 5:12 AM, wrote: > Today's Topic Summary > > Group: http://groups.google.com/group/excel-macros/topics > >- Listing name of works

$$Excel-Macros$$ Open Worksheet if Filepath verified

I have an excel file that I want to give to an employee that will only run if it is on their computer. I am looking for a macro that would show perhaps an introduction page and if the file name/path matches maybe a cell on the introduction page then it will unhide the (3 sheets) that the employees

Re: $$Excel-Macros$$ Excel VBA professional needed for a Project Work

Hi Satish Here is Divaker, you can contact to me on 9582060233. Divaker pandey On Mon, Oct 31, 2011 at 1:55 PM, satish wrote: > Dear Excel Gurus, > > I am free lance data analyst, I have set of excel templates to > calculate the Savings and Overcharges. I would like to auto-maize the > whole pr

Re: $$Excel-Macros$$ get all the datas or selected datas in different work sheets in to one sheet

You can also use this ‘=== option explicit Sub copyallsheetstoonesheet() Dim sc As Long Dim i As Long sc = Sheets.Count Sheets.Add after:=Sheets(sc) ActiveSheet.Name = "Summary" For i = 1 To k Sheets(i).UsedRange.Offset(1).Copy Cells(Rows.Count, 1).End(xlUp).Offset(1) Next i Columns.AutoFit End

$$Excel-Macros$$ !!!JOB!!

** *Experience:* 2 - 7 Years *Location:* Gurgaon *Education:* UG - Any Graduate - Any Specialization PG - Any PG Course - Any Specialization *Industry Type:* BPO/ITES *Role:* Associate/Sr. Associate -(NonTechnical) *Functional Area:* ITES/BPO/KPO, Customer Service, Ops. *Posted Date:* 1

Re: $$Excel-Macros$$ Calling multiple type subroutines

Thank you for the reply. I guess I do have a bit of a wrench in the whole system. It does in fact have a formula in B3 because it is pulling the answer from another worksheet. It is a simple IF THEN statement, but nonetheless, it is a formula. Is there a completely different approach I should be t

Re: $$Excel-Macros$$ Listing name of worksheet & renaming them

Amit, I do not know which file you are using it on, so I cannot be sure, but the code should work if you can MOVE the entire Sorter sheet from my attachment to your workbook, and ideally make it the very first sheet. If you are still not able to get it to work, you might have to share your actual w

Re: $$Excel-Macros$$ Need help on Micro Button!!!!!!!!!!!!!!!!!!!

Use this code in Sheet1 VBA code module Private Sub CommandButton1_Click() ActiveSheet.Range("B4:B32").EntireRow.Hidden = Not ActiveSheet.Range("B4:B32").EntireRow.Hidden End Sub Private Sub CommandButton2_Click() ActiveSheet.Range("B35:B50").EntireRow.Hidden = Not ActiveSheet.Range("B35:

$$Excel-Macros$$ Need help on Micro Button!!!!!!!!!!!!!!!!!!!

HI Team, I had created one sheet in which i made the Groups Now i want to link the Buttons which i created in the sheet (When i click the Button it should expand the group and wen again click the button it needs to be close). Please help me on this * * *Regards,* *Jocky* -- FORUM RULES (93

Re: $$Excel-Macros$$ get all the datas or selected datas in different work sheets in to one sheet

More detail and/or attach file(s) Don Guillett SalesAid Software dguille...@gmail.com From: smitha.kumari Sent: Monday, November 14, 2011 2:17 AM To: excel-macros@googlegroups.com Subject: $$Excel-Macros$$ get all the datas or selected datas in different work sheets in to one sheet I need hel

Re: $$Excel-Macros$$ Required Progres bar / Status bar while macro runinng....

Attach your file with a reply to this msg. Don Guillett SalesAid Software dguille...@gmail.com From: maulik desai Sent: Sunday, November 13, 2011 10:31 AM To: excel-macros@googlegroups.com Subject: $$Excel-Macros$$ Required Progres bar / Status bar while macro runinng Hi Team, I having 1

Re: $$Excel-Macros$$ How to embed an Outlook mail into excel

Well, I don't think you're on right way..If you'll look at the code which I'd posted earlier, you'll find it is very easy to do so... Previous Code.. Sheets("Sheet1").OLEObjects.Add(Filename:="C:\Sample.oft", DisplayAsIcon:=True, IconFileName:="packager.exe", IconIndex:=0, IconLabel:="Sample").Se

Re: $$Excel-Macros$$ How to embed an Outlook mail into excel

hi friend, i dont think that you can insert the outlook email icon while inserting it as an object, rather you can insert in the form of an object. for that follow these steps. Select Insert object Create from file . Check the box ' Display as icon' hope you would get

$$Excel-Macros$$ get all the datas or selected datas in different work sheets in to one sheet

Hi, I need help on: Want to get all the datas or selected datas in different work sheets in to one sheet in the same work book. Please suggest any formula. Regards Smitha -- FORUM RULES (934+ members already BANNED for violation) 1) Use concise, accurate thread titles. Poor th

$$Excel-Macros$$ Re: How to embed an Outlook mail into excel

Hi Prathap, You can use the following code to embedd emails in an excel worksheet as object... Sheets("Sheet1").OLEObjects.Add(Filename:="C:\Sample.oft", DisplayAsIcon:=True, IconFileName:="packager.exe", IconIndex:=0, IconLabel:="Sample").Select Regards Deepak On Nov 14, 2:59 pm, Prathap wrot

$$Excel-Macros$$ Re: Email Macro required for mail Boday

Hi Maulik, Below is the code that you're looking for... Insert a module in your workbook and paste the following code and run it... --- D

$$Excel-Macros$$ How to embed an Outlook mail into excel

HI All, I`m trying to embed the Outlook mail into a cell in Microsoft excel (2010) through Insert object. However after embedding, object is not showing the outlook icon rather than dispalying as blank object. Attached is the sample file. Best Regards, PRATHAP D -- FORUM RULES (934+ members

Re: $$Excel-Macros$$ Indirect Formula - Need Advise

Thanks Noorain, sorry i had missed out your response... for the first time i'm using this Indirect formula & with Adress or other criterian... will you advise me bit more about Indirect & Adress formulas usage ??with few exmples so that i can learn in detail ??? cheers JP On Fri, Nov 11, 2011

Re: $$Excel-Macros$$ Seeking help small letters to capital letters

=UPPER(A1) 2011/11/10 ♥.•:*¨¨*:•.♥.•:V.Kiran Kumar :•.♥.•:*¨¨*:•.♥ < vadnalaki...@gmail.com> > Hi > > Anybody can help me out > how to make small letter to capital letter in Ms excel > > V.Kiran > > > -- > FORUM RULES (934+ members already BANNED for violation) > > 1) Use concise, accurate thre

$$Excel-Macros$$ get all the datas or selected datas in different work sheets in to one sheet

I need help on: Want to get all the datas or selected datas in different work sheets in to one sheet in the same work book. Please suggest any formula. Regards Smitha -- FORUM RULES (934+ members already BANNED for violation) 1) Use concise, accurate thread titles. Poor thread titl