*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
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.
>
>
>
>
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
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 nasirsa...@gmail.com 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.
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 rockerna...@gmail.com wrote:
Yes it works, Thanks for the same we can considered this issue is
resolved. But one thing
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
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
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 =
On Wed, Mar 18, 2015 at 5:31 PM, saravanan R sarva0...@gmail.com 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
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, Mandeep
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 Criteria
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 michaelvino...@gmail.com
wrote:
Hi Ashish,
Please find the attached macro
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 display,
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 rockerna...@gmail.com
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
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:RT) or
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.
Thanks in
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 advance
--
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
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 = True
End
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
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,
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, it has
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
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 dguille...@gmail.com wrote:
On Friday, September 28, 2012 7:24:58 AM UTC-5, Aamir Shahzad wrote:
Dear
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 generate C7,
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
FORUM
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
@googlegroups.com
Date: Fri, 13 Jul 2012 18:24:57
To: excel-macros@googlegroups.com
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
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 noorain.ans...@gmail.com wrote:
Dear Shashi,
Please see attached sheet if it help to u...
On Thu, Sep 1,
Dear Shasi,
You are Welcome...
*Best Regards,*
*Venkat *
*Chennai*
*My Linked in profile http://in.linkedin.com/pub/venkatesan-c/21/492/a71*
On Sun, Sep 4, 2011 at 8:37 AM, Shashi Ranjan shashi2...@gmail.com wrote:
Dear Venkat Noorain Sir
I am very thankful to you for sharing your precipus
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 shashi2...@gmail.com wrote:
Dear Excel Guru's
I want
*
*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 ankurpande...@gmail.com wrote:
*hi ashish sir
may this help u ...
*Have A Nice Time Enjoy Life
Regards:
CMA Ankur Pandey
Thanks Ashish
Thanks Ankur
On Thu, Jul 7, 2011 at 11:51 AM, ankur ankurpande...@gmail.com 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 ankurpande...@gmail.com
On Wed, Jul 6, 2011 at 4:56 PM, Kal xcel kalx...@gmail.com 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:
*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 koul.ash...@gmail.com wrote:
On Wed, Jul 6, 2011 at 4:56 PM, Kal xcel kalx...@gmail.com
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
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
--
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
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 @
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 realsa...@gmail.com wrote:
Dear Nikhil,
Use Data Validation for reflect the error
--
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
Hellow friends
I am awaiting your reply for this my query.
Thanks
On Fri, Oct 16, 2009 at 3:36 PM, big smile bigsmile...@gmail.com 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
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
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 upendrasinghsen...@gmail.com
wrote:
Hi Himadri,
You should multiply new client with customer per client.
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 bigsmile...@gmail.com 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
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, You
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 mayur2...@gmail.com wrote:
Hi Dilip,
Thanks a lot.
I
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
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 ankursat...@gmail.com wrote:
How to put zero ('0')
@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...
On Jul
]
*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 elaborate
further on that. Also need to know what you mean by if i want to add more
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 aquas...@gmail.com wrote:
Please find the file attached….
Let me know if you have any doubts
Regards
Ajit
*From:* excel-macros@googlegroups.com
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
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:
Hi Big Smile
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 bigsmile...@gmail.com wrote:
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 bigsmile...@gmail.com wrote:
Respected friends,
I am new this
Thanks a lot
Mrs. Jayshree Shah
On Sat, Jul 25, 2009 at 8:07 PM, Upendra Singh upendrasinghsen...@gmail.com
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
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 amit.aur...@gmail.com 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 ;
---
---
Hi,
However, Gmail, Yahoo and Hotmail automatically does this task. So
Solution
Great solution
On Tue, Feb 24, 2009 at 6:34 PM, Naga iamsa...@gmail.com 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 amit.aur...@gmail.com wrote:
Dear All
I have excel file with 10,000
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
Hi Naga,
Here is the short cut.
pls. see the file attached.
regds.,
Johnson
On Tue, Feb 24, 2009 at 6:34 PM, Naga iamsa...@gmail.com 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
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
63 matches
Mail list logo