Re: $$Excel-Macros$$ Offset Formula

Hi Priyanka.. Offset Function The OFFSET function is used to return the address of a cell or a range of cell through the use of a reference cell. If we know the cell or range beforehand, we are unlikely to use it at all. It is very useful in our spreadsheets when we do not know the cell or the ra

Re: $$Excel-Macros$$ Offset Formula

Kindly let know the usage of Offcet and indirect formual For which purpose we are using the same And how we can use large formula with sum (to get sum from sheet2 to sheet1 for highest 5 amounts ) On Thu, Feb 9, 2012 at 11:06 PM, NOORAIN ANSARI wrote: > Hi Maansi, > > you are welcome in Excel-M

Re: $$Excel-Macros$$ Amazing... Excel Menu Bar... Try it... you will like it

Dear Noorain, Thanks for your support!! 2012/2/7 NOORAIN ANSARI > Add-In Excel 2003 Version > > > On Thu, Feb 2, 2012 at 5:24 PM, NOORAIN ANSARI > wrote: > >> Dear Darwin/ Bé Trần Văn, >> >> Recently it will available in Excel Version 2003. >> >> >> >> >> On Thu, Feb 2, 2012 at 5:18 PM, Bé Trầ

RE: $$Excel-Macros$$ Attachments getting deleted in Outlook while replying emails

Many thanks Asa for your reply. Regards, Kaushik On Feb 10, 2012 10:57 AM, "Asa Rossoff" wrote: > Does the attachment gets deleted from the original email in your Inbox? I > have not heard of that before. > > If you mean your reply email does not include the attachment that was sent > to you:

RE: $$Excel-Macros$$ Attachments getting deleted in Outlook while replying emails

Does the attachment gets deleted from the original email in your Inbox? I have not heard of that before. If you mean your reply email does not include the attachment that was sent to you: that is normal. If you reply in HTML or Rich Text (only use Rich Text for Outlook to Outlook emails) format

Re: $$Excel-Macros$$ Offset Formula

Dear Mr.Sam & Mr.Noorain... Many Thanks for this wonderful examples & advise :-) I will go throug it and if i find dificulty, will revert with the problem. Have a great day!! Maansi On Thu, Feb 9, 2012 at 11:03 PM, Sam Mathai Chacko wrote: > http://support.microsoft.com/kb/324991 (OFFSET) >

Re: $$Excel-Macros$$ Index and Match

Dear Noorain, Sorry for the late reply. What is the use of *small function* and *row function* here? How could they use together to get the desired results? Thanks so much for explanation in advance!! 2012/2/7 NOORAIN ANSARI > Dear Darwin, > > Actually, It was query of one of our group member

Re: $$Excel-Macros$$ split the value in two part

Hi Here is my take on this In B2 =TRIM(SUBSTITUTE(SUBSTITUTE(A2,C2,""),CHAR(160),CHAR(32))) In C2 =TRIM(RIGHT(SUBSTITUTE(TRIM(SUBSTITUTE(A2,CHAR(160),CHAR(32))),CHAR(32),REPT(CHAR(32),100)),100)) Kris -- FORUM RULES (986+ members already BANNED for violation) 1) Use concise, accura

$$Excel-Macros$$ Attachments getting deleted in Outlook while replying emails

Hi, Good Morning I am facing problem in MS Outlook. I am receiving emails with attachments but when I reply to that email attachments gets deleted. Please sugegst me the corrective action. Many thanks in anticipation of your assistance. Regards, Kaushik Savla -- FORUM RULES (986+ members alre

Re: $$Excel-Macros$$ Offset Formula

Hi All, Its nice staff do you have this in English it looks great but I don't get a word from it :) Regards, Pawel From: NOORAIN ANSARI To: excel-macros@googlegroups.com Sent: Thursday, February 9, 2012 5:36 PM Subject: Re: $$Excel-Macros$$ Offset Formula

$$Excel-Macros$$ scheduler123

Hi All, I have the question if any of you were using scheduler123 for production planing is based on excel and macros so if yes can you let me know is useful? or maybe anyone of you have such demo, I'll be appreciated of any your thoughts . Regards, Pawel -- FORUM RULES (986+ members alread

$$Excel-Macros$$ rekha siri wants to chat

I've been using Google Talk and thought you might like to try it out. We can use it to call each other for free over the internet. Here's an invitation to download Google Talk. Give it a try! --- rekha siri wants to stay in bette

Re: $$Excel-Macros$$ DASHBOARD FOR STOCK MARKET REVIEW

Its just historical stock market information for the Ghana stock exchange and major mkt indicators. But its the idea behind in tht u can picture any report you want to generate and design it along side Sent from my BlackBerry® smartphone from Airtel Ghana -Original Message- From: Liyakat

Re: $$Excel-Macros$$ split the value in two part

Or, even simpler without loop by changing mine to Sub TTC_SAS_Improved() Columns("A").TextToColumns Destination:=Range("B1"), _ DataType:=xlFixedWidth, FieldInfo:= _ Array(Array(0, 1), Array(30, 1)) Columns("b:c").AutoFit Columns("b:c").Replace Chr(32), "" Columns("c").HorizontalAlignment = xlRi

RE: $$Excel-Macros$$ Capture Image using VBA

P.S. You may also want to see: Windows Image Aquisition Automation Layer (MSDN Reference) Getting Started with Samples (MSDN) & Shared Samples (MSDN)

RE: $$Excel-Macros$$ Capture Image using VBA

Hello Prakash, I believe you can use the Windows Image Acquisition 2.0 library. http://www.microsoft.com/download/en/details.aspx?DisplayLang=en &id=18287 It includes a help file and samples in VB6 and VBScript. VB6

Re: $$Excel-Macros$$ Capture Image using VBA

working with images !!! please, see ; http://www.youtube.com/watch?v=B1qUrTKsnGo&context=C3697427ADOEgsToPDskKiaWsIL-0TfBoVlGZ-qD8u add ins by chilexcel, Hyperlink to do with "ListFolder" in this group 2012/2/9 Prakash Gusain > You can use any excel file. I just want to trigger the we

Re: $$Excel-Macros$$ Offset Formula

http://support.microsoft.com/kb/324991 (OFFSET) Description Returns a reference to a range that is a specified number of rows and columns from a cell or range of cells. The reference that is returned can be a single cell or a range of cells. You can specify the number of rows and the number of co

Re: $$Excel-Macros$$ Next Working date

the standard =WORKDAY() function calculates the next working day from a given date. it also allows you to list holidays to be skipped. So, if you put the date you're starting from in A1, and a list of Holidays in A4:A20 you can use: =WORKDAY(A1,1,A4:A20)  and it will give you the NEXT working d

Re: $$Excel-Macros$$ Re: VBA Macro development PDF

2012/2/9 Maries > Hi, > ** > *Check this link:* > ** > *http://search.4shared.com/q/CCAD/1/excel+vba* > ** > Regards, > > MARIES > > > > On Thu, Feb 9, 2012 at 2:40 PM, PrIyAnKa wrote: > >> EXCEL 2007 VBA MACRO PROGRAMMING > > > -- > FORUM RULES (986+ members already BANNED for violation) > > 1

Re: $$Excel-Macros$$ split the value in two part

The macro splits it in to three columns a probable solution would be Sub Spliter() Dim rng As Range Columns("A").TextToColumns Destination:=Range("B1"), _ DataType:=2, OtherChar:=" ", _ FieldInfo:=Array(Array(0, 2), Array(31, 1)), _ Tra

Re: $$Excel-Macros$$ How to protect cells or formulas in excel sheets

Hi Veeru, Could you send us the excel sheet. On 2/8/12, Veeru TOC wrote: > Dear Team > > in excel file i know protect sheets but i need particular > Cells put the code or protect how it possible > > VBA code also no problem > -- > > > > > > *Thanks&Regards* > > * * > > *

Re: $$Excel-Macros$$ Sum Product

Thanks a lot.. On 2/8/12, NOORAIN ANSARI wrote: > *Learn:* > >- Introduction to SUMPRODUCT > Formula >- Advanced SUMPRODUCT Formula > Examples >- Introduction

Re: $$Excel-Macros$$ split the value in two part

Hi, Please find the attached samplet which is splited. In the excel sheet go to DATA tab and in this go to Text colum and changed it. used fixed. On 2/9/12, Sanjib Chatterjee wrote: > Dear Sir / Madam, > > Please see the attached excel sheet. I like to split the name in one cell > (i.e. in B

Re: $$Excel-Macros$$ Next Working date

Hi Srinivas, You can try this formula: =IF(WEEKDAY($A$1)=7,A1+DAY(2),IF(WEEKDAY($A$1)=6,A1+DAY(3),A1+DAY(1))) On 2/9/12, Chidurala, Shrinivas wrote: > Dear Group, > > Please suggest any formula to pick next working date, but Saturday and > Sunday should not include. > > Working day Next

$$Excel-Macros$$ Offset Formula

Dear Team, Good Morning... I would like to thank one and all for excellent tips, advise & timely help on excell really proud to be part of this learning team!! I had joined for MIS Team recently and would like to learn much on excel so joined this group recently - special thanks to Mr. Noora

Re: $$Excel-Macros$$ DASHBOARD FOR STOCK MARKET REVIEW

Hi bro, It was very superb, Could you please explain me basic information about same. Thanks Liyakath Ali Khan Mob:09844577212 On 2/9/12, hilary lomotey wrote: > DA > > I just completed a dashboard for stock market review and wanted to share it > to the group,( i got a lot of inputs from this

Re: $$Excel-Macros$$ split the value in two part

If you do not want to use AB as your criteria Name =SUBSTITUTE(TRIM(SUBSTITUTE(A2,CHAR(160)," "))," "&E2,"") Reg.No =MID(TRIM(SUBSTITUTE(A2,CHAR(160)," ")),FIND("?",SUBSTITUTE(TRIM(SUBSTITUTE(A2,CHAR(160)," "))," ","?",LEN(TRIM(SUBSTITUTE(A2,CHAR(160)," ")))-LEN(SUBSTITUTE(TRIM(SUBSTITUTE(A2,CHAR

Re: $$Excel-Macros$$ split the value in two part

Noorain, if you are using AB as your search criteria to split the cells, why do you need such a long formula Use Name =TRIM(SUBSTITUTE(SUBSTITUTE(A2,MID(A2,FIND("AB",A2),9),""),CHAR(160),"")) Reg.No =SUBSTITUTE(MID(A2,FIND("AB",A2),9),CHAR(160),"") Regards, Sam Mathai Chacko On Thu, Feb 9, 20

Re: $$Excel-Macros$$ Cstr function

TTC =”Text to columns” Don Guillett SalesAid Software dguille...@gmail.com From: Darwin Chan Sent: Thursday, February 09, 2012 9:31 AM To: excel-macros@googlegroups.com Subject: Re: $$Excel-Macros$$ Cstr function THANKS DON~~!!! I have used the code and it works? by the way, may i know what i

Re: $$Excel-Macros$$ Help on INDIRECT ARRAY Formula

The easiest way is to uncheck the show zeroes in the Excel option. Regards, Sam Mathai Chacko On Thu, Feb 9, 2012 at 6:31 PM, Shaik Waheed wrote: > Thanks noorain > > thats wonderful, > > On Thu, Feb 9, 2012 at 6:12 PM, NOORAIN ANSARI > wrote: > >> Dear waheed, >> >> It is also possible witho

Re: $$Excel-Macros$$ Pick data from one workbook to another workbook

Show a sample of how the final output would look like. Your attachment only shows a blank table. Sam On Thu, Feb 9, 2012 at 5:22 PM, Karan Singh wrote: > Dear all, > > I need your help in vba. I have to pick data from one work to another > workbook's sheets. I'v attached format & the sample wor

Re: $$Excel-Macros$$ Get Text From A llWbs to sheet

Sub GetTextFromAllWbs() Dim fs As Object, fol As Object, fls As Object, f As Object, s As Object Dim fpath As String fpath = "F:\ExcelFox\Wigi" 'use filedialog to select a folder Set fs = CreateObject("scripting.filesystemobject") Set fol = fs.getfolder(fpath) Set fls = f

Re: $$Excel-Macros$$ split the value in two part

Try this Sub TTC_SAS() Columns("A").TextToColumns Destination:=Range("B1"), _ DataType:=xlFixedWidth, FieldInfo:=Array(Array(0, 1), _ Array(5, 1), Array(30, 1)) Columns("C:D").AutoFit Columns("D").HorizontalAlignment = xlRight End Sub Don Guillett SalesAid Software dguille...@gmail.com From: Shai

$$Excel-Macros$$ Re: Pick data from one workbook to another workbook

Hi Can you explain which data you want to put where? Or do you want take all the details and paste in other sheet as it is? On Feb 9, 4:52 pm, Karan Singh wrote: > Dear all, > > I need your help in vba. I have to pick data from one work to another > workbook's sheets. I'v attached format & the sa

Re: $$Excel-Macros$$ Help on INDIRECT ARRAY Formula

Thanks noorain thats wonderful, On Thu, Feb 9, 2012 at 6:12 PM, NOORAIN ANSARI wrote: > Dear waheed, > > It is also possible without Indirect function.. > > =IF(ISBLANK(EMP.DATA),"",EMP.DATA) > > With ctrl+shift+Enter > > On Thu, Feb 9, 2012 at 6:00 PM, Shaik Waheed wrote: > >> Thank you Maris

Re: $$Excel-Macros$$ Help on INDIRECT ARRAY Formula

Dear waheed, It is also possible without Indirect function.. =IF(ISBLANK(EMP.DATA),"",EMP.DATA) With ctrl+shift+Enter On Thu, Feb 9, 2012 at 6:00 PM, Shaik Waheed wrote: > Thank you Maris for ur reply.its working fine. > > > On Thu, Feb 9, 2012 at 5:18 PM, Maries wrote: > >> Hi, >>

Re: $$Excel-Macros$$ Help on INDIRECT ARRAY Formula

Thank you Maris for ur reply.its working fine. On Thu, Feb 9, 2012 at 5:18 PM, Maries wrote: > Hi, > > Use this formula with CSE. > > *=IF(INDIRECT("EMP.DATA")="","",INDIRECT("EMP.DATA"))* > > Regards, > > MARIES. > > On Thu, Feb 9, 2012 at 3:42 PM, Shaik Waheed wrote: > >> Hi Experts

Re: $$Excel-Macros$$ Help on INDIRECT ARRAY Formula

Hi, Use this formula with CSE. *=IF(INDIRECT("EMP.DATA")="","",INDIRECT("EMP.DATA"))* Regards, MARIES. On Thu, Feb 9, 2012 at 3:42 PM, Shaik Waheed wrote: > Hi Experts, > > I have an excel sheet with defined named ranges. When I am using Indirect > array formula to capture the named range it

Re: $$Excel-Macros$$ excel macros - Sunil B.N

Dear Sunil, Please use.. For 2007+ =AVERAGEIF(F1:F10,">0") For 2003 =SUMPRODUCT((F1:F10>0)*(F1:F10))/COUNTIF(F1:F10,"<>0") On Thu, Feb 9, 2012 at 4:49 PM, sunil bn wrote: > Hi Expert, > > > > Please find the attached file. > > > > 1. I need “average formula” which includes 0 value. > > --

$$Excel-Macros$$ Help on INDIRECT ARRAY Formula

Hi Experts, I have an excel sheet with defined named ranges. When I am using Indirect array formula to capture the named range it is showing zeros (0's) in place of blanks that are available in my named range. Is there any way to get only blanks as result because i dont want zeros. Please find th

Re: $$Excel-Macros$$ excel macros - Sunil B.N

Thank u maries Regards Sunil B.N ®Sent From Android Mobile© On 9 Feb 2012 17:02, "Maries" wrote: > Hi, > > Find the below formulas, > > =SUM(F1:F10)/COUNTIF(F1:F10,">0") > > =SUM(F1:F10) / (COUNT(F1:F10) - COUNTIF(F1:F10,0)) > > =SUMIF(F1:F10,">0")/COUNTIF(F1:F10,">0") > > =SUM(F1:F10)/(SUMPROD

Re: $$Excel-Macros$$ excel macros - Sunil B.N

Also Try, *=AVERAGEIF(F1:F10,">0") * On Thu, Feb 9, 2012 at 3:33 PM, Lakshman Prasad wrote: > Sorry, > > =AVERAGE(F2:F11) > > *From:* sunil bn > *To:* excel-macros@googlegroups.com > *Sent:* Thursday, 9 February 2012 4:49 PM > *Subject:* $$Excel-Macros$$ excel macros - Sunil B.N > > Hi Expert

Re: $$Excel-Macros$$ excel macros - Sunil B.N

Sorry,   =AVERAGE(F2:F11) From: sunil bn To: excel-macros@googlegroups.com Sent: Thursday, 9 February 2012 4:49 PM Subject: $$Excel-Macros$$ excel macros - Sunil B.N Hi Expert,   Please find the attached file.   1.  I need “average formula” which includes

Re: $$Excel-Macros$$ excel macros - Sunil B.N

Hi, Find the below formulas, =SUM(F1:F10)/COUNTIF(F1:F10,">0") =SUM(F1:F10) / (COUNT(F1:F10) - COUNTIF(F1:F10,0)) =SUMIF(F1:F10,">0")/COUNTIF(F1:F10,">0") =SUM(F1:F10)/(SUMPRODUCT((F1:F10<>0)*1)) Regards, MARIES. On Thu, Feb 9, 2012 at 3:19 PM, sunil bn wrote: > need “average formula” whi

Re: $$Excel-Macros$$ excel macros - Sunil B.N

Hello Mr. Sunil Use =AVERAGE(F2:F11,{1})     From: sunil bn To: excel-macros@googlegroups.com Sent: Thursday, 9 February 2012 4:49 PM Subject: $$Excel-Macros$$ excel macros - Sunil B.N Hi Expert,   Please find the attached file.   1.  I need “average

$$Excel-Macros$$ excel macros - Sunil B.N

Hi Expert, Please find the attached file. 1. I need “average formula” which includes 0 value. -- *Regards* **Sunil B.N *** -- FORUM RULES (986+ members already BANNED for violation) 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Fo

Re: $$Excel-Macros$$ Re: VBA Macro development PDF

Hi, ** *Check this link:* ** *http://search.4shared.com/q/CCAD/1/excel+vba* ** Regards, MARIES On Thu, Feb 9, 2012 at 2:40 PM, PrIyAnKa wrote: > EXCEL 2007 VBA MACRO PROGRAMMING -- FORUM RULES (986+ members already BANNED for violation) 1) Use concise, accurate thread titles. Poor thread t

$$Excel-Macros$$ Re: VBA Macro development PDF

Dear Team Does anyone have full PDF file with whole chapters for EXCEL 2007 VBA MACRO PROGRAMMING - RICHARD SHEPHERD Or anything PDF or PPT for the same (VBA development programming) Regards PrIyANkA On Thu, Feb 9, 2012 at 4:08 PM, PrIyAnKa wrote: > Dear Team > > Does anyone have full PDF fil

Re: $$Excel-Macros$$ Excel Help - using value of one procedure into other

Dear Amar, Use below code with little bit correction in red color This code has been modify as per Krish's solution. Hope it will help to you See attached sheet... Dim IFileName As Variant Dim SFileName As Variant Public Sub Lfile_Name() IFileName = Application.GetOpenFilename("Excel Files

Re: $$Excel-Macros$$ split the value in two part

Dear Sanjib, Please see attached sheet with Formula For Name =LEFT(TRIM(SUBSTITUTE(A2,CHAR(160),CHAR(32))),FIND("AB",TRIM(SUBSTITUTE(A2,CHAR(160),CHAR(32-1) For Registration no.. =RIGHT(TRIM(SUBSTITUTE(A2,CHAR(160),CHAR(32))),LEN(TRIM(SUBSTITUTE(A2,CHAR(160),CHAR(32-FIND("AB",TRIM(SUBSTIT

Re: $$Excel-Macros$$ Deletion of Posts

Dear Nitin, Please check it.. http://www.discussexcel.com/contact-me On Thu, Feb 9, 2012 at 1:06 PM, nitin arora wrote: > Hi, > > I sent few mails to this group which have excel file attched to them. I > request you to please delete all my posts on priority from the group. > > My email id is:

Re: $$Excel-Macros$$ Excel Help - using value of one procedure into other

Hi Kris, I don't have your code, Can you please forward? Thanks, Amar On 09/02/2012, Kris wrote: > Hi > > Have you tred mine ? > > > > -- > FORUM RULES (986+ members already BANNED for violation) > > 1) Use concise, accurate thread titles. Poor thread titles, like Please > Help, Urgent, Need He

$$Excel-Macros$$ Get Text From A llWbs to sheet

Dear Group i can use below vba code get txt from All wbk to 1 sheet , Excel wbk name into A Coulumn how its possible VBA Code:- Sub GetTextFromAllWbs() Dim fpath As String fpath = "C:\Users\VEERU\Desktop\dumps" 'use filedialog to select a folder Dim