$$Excel-Macros$$ Re: Query Question with Excel Stock File

*I forget to attach the file which I'm doing now.* On Saturday, February 15, 2020 at 3:04:56 PM UTC-5, Mike C. wrote: > > I am working on creating an Excel file that will pull data from > barcharts.com for stocks listed in this Excel file and what I'm trying to > have it do is automatically show

$$Excel-Macros$$ Re: Query !!!

Thank You so Much, It's Working Perfect :) On Tuesday, August 16, 2016 at 2:10:13 PM UTC+5:30, सचिन शर्मा wrote: > > Dear All, > > > Please help to resolve below query. > > > Share the function to get the same result which in yellow cells > > ** without any supporting columns. > > > >

$$Excel-Macros$$ Re: Query

Hi Soumyendu Paul I'm not exactly sure what you want. So here's my understanding "If user makes any changes in the file he/she has to click the Send mail button before closing the file and you have code for sending the mail " A simple way is to use activex control button instead of the shape you

Re: $$Excel-Macros$$ Re: Query to retreive data

you dont need access, you can continue using excel & thru DAO you can retrieve data from closed workbook too.. On Wed, Apr 29, 2015 at 10:35 AM, Nasir Saikh wrote: > r8 Pramod access is very easy and taking very less time than excel on huge > data you can use it till 2 GB data. > > On Tuesday, A

$$Excel-Macros$$ Re: Query to retreive data

r8 Pramod access is very easy and taking very less time than excel on huge data you can use it till 2 GB data. On Tuesday, April 28, 2015 at 11:34:45 AM UTC+5:30, Mandeep Baluja wrote: > My mmaster file is large and i just want to do lookup on my sheet from > master file without opening my mast

Re: $$Excel-Macros$$ Re: Query to retreive data

you can, To all the people you can, As long as ever you can.” - John Wesley - From: Mandeep Baluja To: excel-macros@googlegroups.com Sent: Tuesday, April 28, 2015 6:11 AM Subject: $$Excel-Macros$$ Re: Query to retreive data Yes it works, Thanks

Re: $$Excel-Macros$$ Re: Query to retreive data

Why not you are using MS Access. It's pretty cool and can we use easy.. this is best for if some one have to work in large data Pramod On 28 Apr 2015 15:41, "Mandeep Baluja" wrote: > Yes it works, Thanks for the same we can considered this issue is > resolved. But one thing Excel is not usef

$$Excel-Macros$$ Re: Query to retreive data

Yes it works, Thanks for the same we can considered this issue is resolved. But one thing Excel is not useful for large files On Daily basis I got files of 350 mb having data of 2-3 lakh rows and I am unable to combine the same jjust because excel not responds. On Tuesday, April 28, 2015 at

$$Excel-Macros$$ Re: Query to retreive data

Hi Mandeep As per my suggestion you can use table link vloopup as I am using and it is working fine. Example is given below. Sub LoopUp() Dim iRow As Integer Dim MaxRow As Long MaxRow = ActiveSheet.Range("A" & Rows.Count).End(xlUp).Row Range("B2").FormulaR1C1 = "=VLOOKUP(RC[-1],'C:\Users\n025

Re: $$Excel-Macros$$ Re: Query Regarding Duplicate and Update Status

On Wed, Mar 18, 2015 at 5:31 PM, saravanan R wrote: > Hi Mandeep, > > Thanks a Million. > > I have one more query related to the same file, is it possible to split > the file based on "Status" OK wrt to each Coleague. > and file name should be QueryDup-FK & QueryDup-BD (colleague name will be > d

Re: $$Excel-Macros$$ Re: Query Regarding Duplicate and Update Status

Hi Mandeep, Thanks a Million. I have one more query related to the same file, is it possible to split the file based on "Status" OK wrt to each Coleague. and file name should be QueryDup-FK & QueryDup-BD (colleague name will be dyanmic) thanks in advance. On Wed, Mar 18, 2015 at 5:25 PM, Mande

$$Excel-Macros$$ Re: Query Regarding Duplicate and Update Status

Try this .. Regards, MandeepBaluja Learningzmypassion. https://www.facebook.com/VBAEXCELSQL?ref=hl https://www.linkedin.com/profile/view?id=312532939 On Wednesday, 18 March 2015 16:59:17 UTC+5:30, saravanan R wrote: > > Hello Team, > > I have an Query regarding Duplicate check for certain Crite

$$Excel-Macros$$ Re: Query for autofit columns.

got to know autofit not works for merge cells was doing the issue tried this code it works. Sub Hidealternatecolumns() Dim first As Double Dim last As Double first = 4 last = 65 For i = first To last If Cells(1, i).Column Mod 2 = 0 Then Cells(1, i).EntireColumn.Hidden = True

Re: $$Excel-Macros$$ Re: Query in IF formula on sheet deactivation event

Thanks Mr.Michael, it's work. Regards. Ashish Bhalara 9624111822 P*Please do not print this email unless it is absolutely necessary. Spread environmental üawareness.♣♣♣* On Sun, Mar 1, 2015 at 11:08 PM, michael vinoth wrote: > Hi Ashish, > > Please find the attached macro file. > > Regards, >

$$Excel-Macros$$ Re: Query in IF formula on sheet deactivation event

Hi Ashish, Please find the attached macro file. Regards, MV On Saturday, February 28, 2015 at 5:04:35 PM UTC+5:30, Ashish_Bhalara wrote: > > Dear expert, > > I need help in attached file in which if cheque amount is greater than > zero and date & cheque number field Blank then msgbox should dis

Re: $$Excel-Macros$$ Re: Query on count

Thank you all. It's really helped me a lot. Thanks in once again On Thu, Nov 13, 2014 at 6:24 PM, Mandeep Baluja wrote: > Hey Kalyan, > > check this array formula and the > sheet. > =COUNT(C4:R4)-COUNTIF(C4:R4,"<=0")-SUM(IF(ISNUMBER(SEARCH(".",C4:R4)),1,0)) > > Regards, > Mandeep Baluja > > On

$$Excel-Macros$$ Re: Query on count

Hey Kalyan, check this array formula and the sheet. =COUNT(C4:R4)-COUNTIF(C4:R4,"<=0")-SUM(IF(ISNUMBER(SEARCH(".",C4:R4)),1,0)) Regards, Mandeep Baluja On Thursday, November 13, 2014 5:12:11 PM UTC+5:30, Kal xcel wrote: > > Dear Experts, > > Please help me to solve my query. > > Thanks in adv

$$Excel-Macros$$ Re: Query on count

Hey Kalyan, check this formula and the sheet . =COUNT(C4:R4)-COUNTIF(C4:R4,"<=0")-SUM(IF(ISNUMBER(SEARCH(".",C4:R4)),1,0)) Ctrl+shift+Enter Regards Mandeep Baluja On Thursday, November 13, 2014 5:12:11 PM UTC+5:30, Kal xcel wrote: > > Dear Experts, > > Please help me to solve my query. > > T

$$Excel-Macros$$ Re: Query on count

Hi, PFA Solution, Regards Sanjai Kumar On Thursday, November 13, 2014 5:12:11 PM UTC+5:30, Kal xcel wrote: > > Dear Experts, > > Please help me to solve my query. > > Thanks in advance > > -- > *Kalyan Chattopadhyay* > > > *Executive Corporate MIS* > > *Joy Cosmetics* > -- Are you =EXP(E:

Re: $$Excel-Macros$$ Re: Query on Text to Columns function

Try this code Sub Macro1() Dim Data As Range Application.DisplayAlerts = False Set Data = Range("C2", Range("C2").End(xlDown).Address) Data.TextToColumns Data.Offset(, 1), OtherChar:=".", FieldInfo:=Array(Array(1, 2), Array(2, 2), Array(3, 2)) Application.DisplayAlerts = Tru

$$Excel-Macros$$ Re: Query on Text to Columns function

Thanks Lalit for the solution, though the solution to my query is quite simpler..while using text to column on the very next step choose text for each column within text to column window. Regards Pooja Sharma Sent from my iPad On Aug 29, 2013, at 2:09 PM, Lalit Mohan Pandey wrote: > Tr

$$Excel-Macros$$ Re: Query in For Each Next

No , It Is not refering each cell in the * Range("A1:D5") *.For getting each cell you have to change the code like *Sub Upper_()* *For Each x In Range("A1:D5").cells* *x.Value = UCase(x.Value)* *Next* * * *Regards* *Prince* On Wednesday, 3 July 2013 10:41:21 UTC+5:30, Prafull Jadhav w

$$Excel-Macros$$ Re: Query

I LOOKED at the provided file and gave proper answers including the "homework" question about sumproduct. On Friday, September 28, 2012 7:24:58 AM UTC-5, Aamir Shahzad wrote: > > Dear Group, > > When I mannualy enter the "C7" into the following formula, i

$$Excel-Macros$$ Re: Query

Hi You getting error because you are multiplying array with not value of Cell C2 but just text C2. Rgds//Vabs On Friday, September 28, 2012 5:54:58 PM UTC+5:30, Aamir Shahzad wrote: > > Dear Group, > > When I mannualy enter the "C7" into the following formula, it has no > problem, > > =S

$$Excel-Macros$$ Re: Query

what is wrong with what I posted much earlier INDEX(C:C,MATCH($H12,$H:$H)) instead of this =INDEX(C2,MATCH($H12,$H$2:$H$9,0)) if you insist on sumproduct, this will do just fine. =SUMPRODUCT(($H$2:$H$9=$H12)*C$2:C$9) On Friday, September 28, 2012 7:24:58 AM UTC-5, Aamir Shahzad wrote: > > Dear G

$$Excel-Macros$$ Re: Query

Why bother when I gave you the PROPER formula. On Friday, September 28, 2012 7:24:58 AM UTC-5, Aamir Shahzad wrote: > > Dear Group, > > When I mannualy enter the "C7" into the following formula, it has no > problem, > > =SUMPRODUCT(($H$2:$H$9=$H13)*(*C7*)) > > but when I am trying to gene

Re: $$Excel-Macros$$ Re: Query

yes you are right but I am not understanding why formula generating error, I want to know the reason? can you investigate. Aamir Shahzad On Fri, Sep 28, 2012 at 5:41 PM, Don Guillett wrote: > > > On Friday, September 28, 2012 7:24:58 AM UTC-5, Aamir Shahzad wrote: >> >> Dear Group, >> >> When I

$$Excel-Macros$$ Re: Query

On Friday, September 28, 2012 7:24:58 AM UTC-5, Aamir Shahzad wrote: > > Dear Group, > > When I mannualy enter the "C7" into the following formula, it has no > problem, > > =SUMPRODUCT(($H$2:$H$9=$H13)*(*C7*)) > > but when I am trying to generate C7, it's given me #value error, however >

$$Excel-Macros$$ Re: Query - Circle Invalid...

Means ?? regards prince On Thursday, September 13, 2012 7:40:41 PM UTC+5:30, Hemant wrote: > > Hi Group, > > > I want to know how Circle Invalid function works in excel and vba. > > > Regards, > Hemant. > > -- Join official facebook page of this forum @ https://www.facebook.com/discussexcel

Re: $$Excel-Macros$$ Re: Query- Global Variable

ooglegroups.com Date: Fri, 13 Jul 2012 18:24:57 To: Reply-To: excel-macros@googlegroups.com Subject: $$Excel-Macros$$ Re: Query- Global Variable Hi Group, Is it good practise to declare a global variable. But, when i use global variable in loop it performs better. Regards, excelv

$$Excel-Macros$$ Re: Query- Global Variable

Hi Group, Is it good practise to declare a global variable. But, when i use global variable in loop it performs better. Regards, excelvba.lear...@gmail.com

$$Excel-Macros$$ Re: Query - AutoNumber

Hi Hemant, Please see this sub, i hope this will help you. Sub Autonumber() Dim rng As Range Dim intNext As Integer With ThisWorkbook.Worksheets("Sheet1") Set rng = .Range("A1:A" & .Range("A" & .Rows.Count).End(xlUp).Row) intNext = Application.Workshe

$$Excel-Macros$$ Re: Query from URL

Ok now it works. I dont why, but it works :-) -- FORUM RULES (934+ members already BANNED for violation) 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or may not be an

Re: $$Excel-Macros$$ Re: Query

Dear Shasi, You are Welcome... *Best Regards,* *Venkat * *Chennai* *My Linked in profile * On Sun, Sep 4, 2011 at 8:37 AM, Shashi Ranjan wrote: > Dear Venkat & Noorain Sir > > I am very thankful to you for sharing your precipus time helping m

Re: $$Excel-Macros$$ Re: Query

Dear Venkat & Noorain Sir I am very thankful to you for sharing your precipus time helping me solve this task. Thanks & Regards Shashi Ranjan On 1 September 2011 15:09, NOORAIN ANSARI wrote: > Dear Shashi, > > Please see attached sheet if it help to u... > > On Thu, Sep 1, 2011 at 2:22 PM, s

$$Excel-Macros$$ Re: Query

Dear Venkat I have second condtion that i want payout amount datewise. I want an urgent help on condition function. In this data i have the requirement of *Payout amount* for each branch in datewise without using On Aug 31, 10:15 pm, shashi wrote: > Dear Excel Guru's > > I want an urgent help on

Re: $$Excel-Macros$$ Re: Query

Thanks Ashish Thanks Ankur On Thu, Jul 7, 2011 at 11:51 AM, ankur wrote: > * > *Have A Nice Time & Enjoy Life > > Regards: > CMA Ankur Pandey > (Someone Different) > > I'm not the best but i'm not like the rest~~ > > > On Wed, Jul 6, 2011 at 6:05 PM, ankur wrote: > >> *hi ashish sir >> may t

Re: $$Excel-Macros$$ Re: Query

* *Have A Nice Time & Enjoy Life Regards: CMA Ankur Pandey (Someone Different) I'm not the best but i'm not like the rest~~ On Wed, Jul 6, 2011 at 6:05 PM, ankur wrote: > *hi ashish sir > may this help u ... > *Have A Nice Time & Enjoy Life > > Regards: > CMA Ankur Pandey > (Someone Different

Re: $$Excel-Macros$$ Re: Query

*hi ashish sir may this help u ... *Have A Nice Time & Enjoy Life Regards: CMA Ankur Pandey (Someone Different) I'm not the best but i'm not like the rest~~ On Wed, Jul 6, 2011 at 5:30 PM, ashish koul wrote: > > > On Wed, Jul 6, 2011 at 4:56 PM, Kal xcel wrote: > >> Dear Experts, >> >> For t

$$Excel-Macros$$ Re: Query

On Wed, Jul 6, 2011 at 4:56 PM, Kal xcel wrote: > Dear Experts, > > For this chart > > 3001-5000 = 30 > 5001-6000 = 40 > 6001-7000 = 45 > 7001-8000 = 50 > 8001-9000 = 50 > 9001-15000 = 110 > 15001-25000 = 130 > 25001-4 = 150 > 40001>= =200 > > I use this formula: > > > > =IF(AND(D16>=

Re: $$Excel-Macros$$ Re: query for a solution

hi Prakash Singh Gusain and others experts thanks for your supportu all provide very helpful solution. thnks again Have A Nice Time & Enjoy Life Regards: CMA Ankur Pandey (Someone Different) I'm not the best but i'm not like the rest~~ On Thu, Feb 10, 2011 at 3:53 PM, Prakash Gusain

Re: $$Excel-Macros$$ Re: Query Excel File

Hi Ayush, This doesn't help. I've got the correct code: "Select Distinct [Market] from [Sheet1$A1:D5000]" or "SELECT DISTINCT [Column Heading] FROM TableName ORDER BY [ColumnHeading];", (¨`·.·´¨) Keep `·.¸(¨`·.·´¨) Smiling !! (¨`·.·´¨)¸.·´ Upendra Singh `·.¸.·´9910227325 On 23 December 2010 2

$$Excel-Macros$$ Re: Query Excel File

Dear Upendra, Well, if your code is working fine to query excel fileYou can use "Select distinct * from [RECEIVE$] " to pull distinct data from the column. Not sure if it will help you. Write back in case you need something else. Best Regards, Ayush Jain Microsoft MVP -- -

Re: $$Excel-Macros$$ Re: Query - Date Formula

Dear Friend Thanks For Help.I have Found Data Validation Function. My Excel Sheet is now working find.. against Thanks Regards Nikhil Shah On Sat, Jul 10, 2010 at 4:51 PM, saggi wrote: > > Dear Nikhil, > > Use Data Validation for reflect the error > > -- > >

$$Excel-Macros$$ Re: Query - Date Formula

Dear Nikhil, Use Data Validation for reflect the error -- -- 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 @

$$Excel-Macros$$ Re: Query!!!!

Hi, U r right, see i need to deduct the cumulative customers...plz find attached sheet for ur reference On Tue, Oct 20, 2009 at 2:12 PM, Anubhav Somani wrote: > Hi Himadri, > > I m not sure if i hv understood the query correctly, pls clarify... > U are unable to give the effect of customer re

$$Excel-Macros$$ Re: Query!!!!

Hi Himadri, I m not sure if i hv understood the query correctly, pls clarify... U are unable to give the effect of customer reduction once a client leaves. I assume that wn a client leaves, all customers linked to that client also go off?? right?? If i m right, do you have any data (or summary) of

$$Excel-Macros$$ Re: Query!!!!

Hi Upendra, Thanks for your reply but each client is adding customers every month, in that case i think it wont work, plz help me On Tue, Oct 20, 2009 at 5:11 PM, Upendra Singh wrote: > Hi Himadri, > > > > > > You should multiply new client with customer per client. > > > > > > Thanks and Re

$$Excel-Macros$$ Re: QUERY NO.4- CUSTOM VIEW - NAME LIST [ F5] - AUTOMATICALLY RUN

Hi, Regarding point no. 2:- > Try hiding one sheet among three available sheets and after that protect Workbook not worksheet. As I have Excel 2003, I am not into the position to explain further in relation to Excel 2007. Best Regards, -- DILIP KUMAR PANDEY MBA-HR,B COM(Hons.),BCA Mobile: +91

$$Excel-Macros$$ Re: Query!!!!

Hi Himadri, You should multiply new client with customer per client. Thanks and Regards, Upendra Singh +91-9910227325 From: excel-macros@googlegroups.com [mailto:excel-mac...@googlegroups.com] On Behalf Of Himadri Roy Sent: Monday, October 19, 2009 9:50 PM To: excel-macros@go

$$Excel-Macros$$ Re: Query no.3 - SUMMARISED DATA & SUBTOTAL ON ANOTHER SHEET.

Hellow friends I am awaiting your reply for this my query. Thanks On Fri, Oct 16, 2009 at 3:36 PM, big smile wrote: > HAPPY DIWALI & NEW YEAR TO ALL OUR EXCEL GURU’S & FRIENDS > > > > > > Attached please find the Excel –tips –Query No.3 File > > > > In Sheet 1 – All the details

$$Excel-Macros$$ Re: QUERY NO.4- CUSTOM VIEW - NAME LIST [ F5] - AUTOMATICALLY RUN

Hellow Sir / Friends, - & Dilip Pandeyji Thanks for giving the answer to my query. & advice for keep smiling, I will be grateful to you if i get the answer to this query by keeping excel 2007 version as there are lot of difference to excel 2003 version. [ if possible ] 1] in Excel 2007- in F

$$Excel-Macros$$ Re: QUERY NO.4- CUSTOM VIEW - NAME LIST [ F5] - AUTOMATICALLY RUN

Hi BigSmile - Keep Smiling:- Below are the answers to your queries (using Excel 2003):- 1) Yes, you can delete that name. Go to Insert ->Name-> select the name and press delete. Change of name is not allowed, but Yes you can make a copy of that name and rename that as per your choice 2) Yes, Yo

$$Excel-Macros$$ Re: QUERY NO.4- CUSTOM VIEW - NAME LIST [ F5] - AUTOMATICALLY RUN

Hellow Friends, Please guide me all this query particular to Excel 2007 Version. Thanks On Sat, Oct 17, 2009 at 4:22 PM, big smile wrote: > Hellow all excel guru's & friends. > > I have some query -- or i want to know the shortcuts. > > 1] Can we delete the name given to particular ce

$$Excel-Macros$$ Re: QUERY NO.4- CUSTOM VIEW - NAME LIST [ F5] - AUTOMATICALLY RUN

On the menu select Insert - Name - Define. You can add, change or delete range names from there. On Oct 17, 6:52 am, big smile wrote: > Hellow all excel guru's  & friends. > > I have some query -- or i want to know the shortcuts. > > 1]  Can we delete the name given to particular cell in name bo

$$Excel-Macros$$ Re: Query in excel:)

You are welcome!! Let the "group" know, if you face any challenge. Thanks -- DILIP KUMAR PANDEY MBA-HR,B COM(Hons.),BCA Mobile: +91 9810929744 dilipan...@gmail.com dilipan...@yahoo.com New Delhi - 110062 On 9/21/09, Manoj Lambhate wrote: > > Hi Dilip, > > Thanks a lot. > I have taken a

$$Excel-Macros$$ Re: Query

Hi Ankur, Follow below steps:- 1. point out the mouse in between the data. 2. Ctrl + * 3. F5 4. Alt + S 5. k 6. Enter Zero 7. Ctrl + Enter done best Regards, -- DILIP KUMAR PANDEY MBA-HR,B COM(Hons.),BCA Mobile: +91 9810929744 dilipan...@gmail.com dilipan...@yahoo.com New Delhi - 110062

$$Excel-Macros$$ Re: Query

Hi Ankur, Use Ctrl+H, and replace blank with 0. this will solve ur problem, Rgds, Mahender Bisht On Tue, Sep 8, 2009 at 3:10 PM, Ankur Satija wrote: > How to put zero ('0') in Blank Cells scattered in a table? > >> - >> Ankur Satija, Consultant >> > > > > -- With Love, Mahesh Bisht --~-

$$Excel-Macros$$ Re: Query

Follow below steps: 1. *Select table where blank cells exist.* 2. *Press "F5"* 3. *Click on "Special" and then "Blanks".* 4. *Enter "0" and press "Ctrl"+"Enter" simultaneously.* U r done. On Tue, Sep 8, 2009 at 3:10 PM, Ankur Satija wrote: > How to put zero ('0') in Blank

$$Excel-Macros$$ Re: Query concerning Option/Radio Buttons and their captions

@googlegroups.com [mailto:excel-mac...@googlegroups.com] On Behalf Of Yptrumpet Sent: Monday, August 03, 2009 8:13 PM To: MS EXCEL AND VBA MACROS Subject: $$Excel-Macros$$ Re: Query concerning Option/Radio Buttons and their captions Anyone out there? Help please! I'm sure it's a simple question.

$$Excel-Macros$$ Re: Query concerning Option/Radio Buttons and their captions

Anyone out there? Help please! I'm sure it's a simple question... On Jul 30, 12:56 pm, Yptrumpet wrote: > Hello, everyone. This is my first post. I've looked high and low for > an answer to this problem. > > I'm making a form in Excel to easily input data. I want to operate it > with the keyboar

$$Excel-Macros$$ Re: QUERY NO. 3 - EXCEL - thanks a lot

g smile [mailto:bigsmile...@gmail.com] > *Sent:* Wednesday, July 29, 2009 5:44 PM > *To:* Ajit Navre > > *Subject:* Re: $$Excel-Macros$$ Re: QUERY NO. 3 - EXCEL > > > > Thanks for the reply sir, > > I am not clear about the *1.4. 07 to 31.3. 2008* thing. Can you elab

$$Excel-Macros$$ Re: QUERY NO. 3 - EXCEL

Thanks Ajitji u have given good solution to my query. i want to elorbrate more on the same sheet --- that suppose if i made wrongly clik the duplicate then it macro -- ctrl Z - undo does not work.. --- ok i can physically delete the raw -- correct the pending coulmn But suppose that raw t

$$Excel-Macros$$ Re: QUERY NO. 3 - EXCEL

Thank you very much -- I will check the function -- & let you know. Ms. J. Shah On Mon, Jul 27, 2009 at 3:26 PM, Ajit Navre wrote: > Please find the file attached…. > > > > Let me know if you have any doubts > > > > Regards > > > > Ajit > > > > *From:* excel-macros@googlegroups.com [m

$$Excel-Macros$$ Re: QUERY ON EXCEL

Thanks a lot Mrs. Jayshree Shah On Sat, Jul 25, 2009 at 8:07 PM, Upendra Singh wrote: > Use Index-Match > > > > =INDEX($A$3:$G$12,MATCH(C$17,$A$3:$A$12,0),MATCH($B18,$A$3:$G$3,1)) > > > > Regards, > > > > Upendra Singh > > +91-9910227325, +91-9310760597 > > > > > ---

$$Excel-Macros$$ Re: QUERY ON EXCEL

Hi The query is not very clear can u please explain what you want Thanks and Regards, Vivek Agrawal Skype ID - vivek.agrawal83 GoogleMoonlight.com - Saving energy-Save Earth On Sat, Jul 25, 2009 at 5:43 PM, big smile wrote: > Respected friends, > > I am new this group. > > Attached p

$$Excel-Macros$$ Re: QUERY ON EXCEL

Hi Keep Smiling..!! Your problem is solved and attached with this email. Thanks, DILipandey -- DILIP KUMAR PANDEY MBA-HR,B COM(Hons.),BCA Mobile: +91 9810929744 dilipan...@gmail.com dilipan...@yahoo.com New Delhi - 110062 On 7/25/09, big smile wrote: > Respected friends, > > I am new this g

$$Excel-Macros$$ Re: QUERY ON EXCEL

Use Index-Match =INDEX($A$3:$G$12,MATCH(C$17,$A$3:$A$12,0),MATCH($B18,$A$3:$G$3,1)) Regards, Upendra Singh +91-9910227325, +91-9310760597 - There are 10 kinds of people: Th

$$Excel-Macros$$ Re: Query

Dear Amit, If U want to send one email to all 10,000 mail id's. Then U have to type a mail in MS - Word using mail merge option. For sending it, it does not require , or ; or anything else. You has to select existing list . then open the excel file. select the sheet & Click on OK. U has to do pre

$$Excel-Macros$$ Re: Query

The solution suggested by Mr. Johnson is the easiest for a layman. I fail to understand why people make simple things complicated. N.Shivkumar Office : +914027685423 Mobile : +919866533180 Res : +914040035774 Alternate Email : shiv1...@yahoo.com --~--~-~--~~~---~

$$Excel-Macros$$ Re: Query

Hi Naga, Here is the short cut. pls. see the file attached. regds., Johnson On Tue, Feb 24, 2009 at 6:34 PM, Naga wrote: > Dear Amit, > > The easiest way of sending an email for 1 IDs is doing mail merge using > MS Word. > > On Tue, Feb 24, 2009 at 6:23 PM, amit arora wrote: > >> Dear

$$Excel-Macros$$ Re: Query

suppose you have email id in A column starting from A2 in B2 type =B2 and in B3 type = B2 & ", " & A3 Then drag it till the cell where you have email addresses. in the last cell you will get emailid1, emailid2 and so on. copy text in last cell and paste in notepad or use copy paste value op

$$Excel-Macros$$ Re: Query

Great solution On Tue, Feb 24, 2009 at 6:34 PM, Naga wrote: > Dear Amit, > > The easiest way of sending an email for 1 IDs is doing mail merge using > MS Word. > > On Tue, Feb 24, 2009 at 6:23 PM, amit arora wrote: > >> Dear All >> >> I have excel file with 10,000 email id in one column. I

$$Excel-Macros$$ Re: Query

--- --- Hi, However, Gmail, Yahoo and Hotmail automatically does this task. So Solution

$$Excel-Macros$$ Re: Query

Dear Amit, The easiest way of sending an email for 1 IDs is doing mail merge using MS Word. On Tue, Feb 24, 2009 at 6:23 PM, amit arora wrote: > Dear All > > I have excel file with 10,000 email id in one column. I want to send mail > to all of these. i have to put , or ; at every email id s