Hi Friends..
I am Michael Vinoth.. I have 5 years experience in developing the excel vba
macros.. I love what I am doing.. Excel is my passion.. I hope I will learn
many things from you all and I will share what I know..
Thanks
MV
VBA Developer
--
Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in
I need a database that can pull data from multiple Excel pages, and then be
used to populate sections of a financial report in Word.
I can provide samples of the typical Excel files and financial report.
Database will be used to create multiple reports monthly and potentially
have widespread de
I have a potential buyer of a program that she wants to create Reserve Fund
Study Reports.
It would mean an interface where she could enter data that would complete
an Excel spreadsheet or sheets. Subsequently that would populate the
corresponding sections of a Word doc.
The software must hav
Hi to ALL,
Can we search ALL excel extension files through vba in a computer(All
Drives) through VBA? Transfer to any other location. Priority is excel
I want to shift all excel files from one computer to another because
company is replacing systems and only ms office files needs to transfer as
p
Hi Rohit,
Check this :-
http://answers.microsoft.com/en-us/office/forum/office_2010-excel/has-anyone-come-across-an-the-help-viewer-has/45771784-b014-414d-b872-8304e1b99dae
Regards,
MV
On Thursday, June 11, 2015 at 2:41:44 PM UTC+5:30, Rohit Jadhav wrote:
> Hi
> I'm not able to access any hel
>
>
>
>
>
>
> *From:* excel-...@googlegroups.com [mailto:
> excel-...@googlegroups.com ] *On Behalf Of *Michael Vinoth
> *Sent:* Friday, May 15, 2015 6:45 PM
> *To:* excel-...@googlegroups.com
> *Cc:* polkar...@gmail.com
> *Subject:* Re: $$Ex
a.
>
>
>
>
>
> Thanks again!!!
>
>
>
>
>
> Regards
>
>
>
> PJ
>
>
>
>
>
> *From:* excel-...@googlegroups.com [mailto:
> excel-...@googlegroups.com ] *On Behalf Of *Michael Vinoth
> *Sent:* Thursday, May 14, 20
Hi Pankaj Sharma ,
Please find the attached macro file.
kindly let me know if you have any queries.
Regards,
MV
On Saturday, May 9, 2015 at 3:01:04 PM UTC+5:30, Pankaj Sharma wrote:
> i recd 20-30 Mobile Bills in PDF format every month, which i need to copy
> in Excel with different sheets.
>
Welcome... ;-)
On Friday, April 24, 2015 at 11:41:22 PM UTC+5:30, hilary lomotey wrote:
>
> Solid Boss,
>
> thanks exactly what i needed
>
> On Thu, Apr 23, 2015 at 9:08 PM, Michael Vinoth > wrote:
>
>> [image: Boxbe] <https://www.boxbe.com/overview> This m
Hi Hilary Lomotey,
Please find the attached macro file.
Kindly let me know if you any queries.
Regards,
MV
On Tuesday, April 21, 2015 at 9:26:43 PM UTC+5:30, hilary lomotey wrote:
> Hello Experts,
>
> i have attached an excel sheet which copies a portion of an excel
> worksheet and attaches i
Hi Nasir Saikh,
Try this:-
https://support.office.com/en-ca/article/Use-a-shared--workbook-to-collaborate-b8207fe9-a613-483f-b804-0ca4658b0c61?ui=en-US&rs=en-CA&ad=CA
Regards,
MV
> On 18-Mar-2015, at 3:51 pm, Nasir Saikh wrote:
>
> Anybody Can help me out on this
>
>> On Wednesday, March 18,
Hi André D'Avila,
Please try this formula "=INDEX(C2:I2,MATCH(1,INDEX(ISNUMBER(C2:I2)+0,0),0))"
in cell J2 and also find the attached file.
Regards,
MV
On Fri, Mar 13, 2015 at 8:04 PM, André D'Avila
wrote:
> Dear experts,
>
> I can't figure out how to create a fórmula to this problem.
>
> In t
Hi Ashish,
Please find the attached macro file.
Regards,
MV
On Thursday, March 12, 2015 at 3:34:33 PM UTC+5:30, Ashish_Bhalara wrote:
> Dear experts,
>
> I need function to sum only closing value of particular date, pls see
> attached file for example.
>
> Regards.
> Ashish Bhalara
> 96241118
Very Nice... Mr.Vabz
On Wednesday, March 11, 2015 at 6:33:10 PM UTC+5:30, Vabz wrote:
> Suppose you have value in cell A1 then type follo. formula in A2 & dont
> press enter & press F9, you will get result in curly bracket, after = sign
> enter CONCATENATE( & press enter to get result
>
>
> =T
Hi Smith,
Can you send the model of excel file for more clarity.
Regards,
MV
On Mon, Mar 9, 2015 at 6:59 PM, Iain Smith wrote:
> Hi. If anyone can assist.
>
> I have a map of the world in individual shapes per country, each named.
> I have a sales spreadsheet which, through Pivot Tables, conve
Nice.. Nikanth Raval...
On Tuesday, March 3, 2015 at 8:03:45 AM UTC+5:30, Nilkanth Raval wrote:
> Hi Friends,
>
> Find attached some examples of VBA Macro
>
> *Thanks,*
> *Nilkanth Raval*
> *+91 900 428 0 428*
> *+91 808 000 1620*
> *Think Before You Print.Consider ENVIRONMENT.*
> *“SAVE TREES,
Hi David,
Please find the attached macro file.
Regards,
MV
On Monday, March 9, 2015 at 10:05:03 AM UTC+5:30, sush@gmail.com wrote:
>
>
>
--
Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s
=TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @
https://
macro.
Have a nice day.
Regards,
MV
On Mon, Mar 2, 2015 at 12:24 AM, michael vinoth
wrote:
> Hi Dhaval Shah,
>
> Please find the attached macro file.
>
> Regards,
> MV
>
> On Saturday, February 28, 2015 at 2:41:50 PM UTC+5:30, Dhaval Shah wrote:
>>
>>
Hi Dhaval Shah,
Please find the attached macro file.
Regards,
MV
On Saturday, February 28, 2015 at 2:41:50 PM UTC+5:30, Dhaval Shah wrote:
>
> Dear Friends
>
> Pls find attached file of my work
>
> In sheet two sheets one is main sheet & another is daily data
>
> in main sheet yellow mark is
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
Welcome... :)
On Thursday, February 26, 2015 at 2:25:08 PM UTC+5:30, Sal Sal wrote:
>
> no words!
> this is exactly wath i need.
> Tks for all.
>
> 2015-02-26 6:28 GMT+01:00 Vaibhav Joshi >:
>
>> This is superb MV
>>
>> Cheers!!
>>
>> On
Thankl You Vabz... :)
On Thursday, February 26, 2015 at 10:59:17 AM UTC+5:30, Vabz wrote:
>
> This is superb MV
>
> Cheers!!
>
> On Wed, Feb 25, 2015 at 7:25 PM, michael vinoth > wrote:
>
>> Hi Sal Sal ,
>>
>> Please find the attached updated macro fil
Welcome Chandru.. :)
On Wednesday, February 25, 2015 at 11:53:57 AM UTC+5:30, Chandru wrote:
>
> Hello Michael,
>
> Thanks for the solution.
>
> Regards,
>
> Chandru
>
> On Tue, Feb 24, 2015 at 11:35 PM, michael vinoth > wrote:
>
>> Hi Chandru,
n other case
>
> 2015-02-23 22:36 GMT+01:00 michael vinoth >:
>
>> *Hi Sal Sal,*
>>
>> Please find the attached macro file.
>>
>> Regards,
>> MV
>>
>>
>> On Monday, February 23, 2015 at 10:32:27 PM UTC+5:30, Sal Sal wrote:
>>
>&
Hi Harpreet Singh,
Please find the attached macro file.
Regards,
MV
On Saturday, February 21, 2015 at 1:35:35 PM UTC+5:30, Harpreet Singh wrote:
> First of all let me tell you all that i am totally new to Excel. I never
> used it before.. I am in a little trouble, so i need help of your guyz..
Hi Chandru,
Please find the attached macro files for Removing Duplicates within the
cell.
Kindly let me know, if you have any queries.
Regards,
MV
On Tuesday, February 24, 2015 at 3:47:00 PM UTC+5:30, Chandru wrote:
> Hello,
>
> How to remove duplicates within a cell using VBA?
>
> Please
*Hi Sal Sal,*
Please find the attached macro file.
Regards,
MV
On Monday, February 23, 2015 at 10:32:27 PM UTC+5:30, Sal Sal wrote:
> Possible to show a toltiptext on mouse over on each items of combobox?
>
> Note:
> combobox is on a vba useform
>
--
Are you =EXP(E:RT) or =NOT(EXP(E:RT))
Thank you... :)
On Wednesday, February 18, 2015 at 10:06:47 AM UTC+5:30, Mandeep baluja
wrote:
>
> awesome looping thanks :) i will apply it on a huge data by changing the
> parametres.
>
> On Tuesday, 17 February 2015 16:10:37 UTC+5:30, Mandeep Baluja wrote:
>>
>> help required !!
>>
>
--
A
Welcome Abdulgani...
On Saturday, February 14, 2015 at 9:54:44 AM UTC+5:30, ITP Abdulgani wrote:
>
> Thanks Michael, I will go through it and will update.
>
> On Sat, Feb 14, 2015 at 1:38 AM, michael vinoth > wrote:
>
>> Hi Abdulgani,
>>
>> Please check this..
Hi Mandeep,
Please find the attached macro file.
kindly check and let me know, if you have any questions or queries.
Regards,
MV
On Tuesday, February 17, 2015 at 4:10:37 PM UTC+5:30, Mandeep Baluja wrote:
> help required !!
>
--
Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wan
Hi Abdulgani,
Please check this..
http://www.asap-utilities.com/excel-tips-detail.php?categorie=9&m=85
On Friday, February 13, 2015 at 11:51:05 AM UTC+5:30, ITP Abdulgani wrote:
> I want to disable copy, cut & paste in the attached file.
>
> And I also request
>
> If Copy, cut paste is dis
Welcome Christos...
On Tuesday, February 10, 2015 at 4:52:30 PM UTC+5:30, Christos Alekopoulos
wrote:
>
> Hi Michael,
>
> That works perfect thank you!!!
>
> Cheers,
> Christos
>
--
Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s
=T
Hi Christos,
Try this code...
Sub Button1_Click()
Dim WS As Worksheet
Dim Search As String
Dim Replacement As String
Dim Prompt As String
Dim Title As String
Dim ID As String
Dim mu As String
Dim temp As Long
Dim R As Long
Dim C As Long
Dim MatchCase As Boolean
Prompt = "What is the risk ID?"
Ti
Thank You Ashish..
On Thursday, February 5, 2015 at 8:34:27 PM UTC+5:30, Ashish Kumar wrote:
>
> HI MV,
>
> Check this :
>
>
> http://education-portal.com/microsoft_office_specialist_certification_online.html
>
>
>
>
> Regards
> Ashish
>
--
Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do
Hi All,
I would like to go for a MOS Certificate in excel 2007. I need some support
for the following queries.
how to approach on this exam?
What would be the syllabus?
Is there any fees details available?
Please share your thoughts and comments.
Wish you all a Great day.
Thank you
MV
--
A
Thank u... Paul... & Vabz...
On Thursday, February 5, 2015 at 1:25:18 AM UTC+5:30, michael vinoth wrote:
>
> Dear All,
>
> I have a doubt.
>
> How to convert PDF file to Excel file using excel vba?
>
> It is very useful to me.
>
> Thanks in advance...
>
--
Hi,
Sub CommandButton_Click()
Dim i As Long
For i = 1 To Range("K65000").End(xlUp).Row
If Trim(Range("K" & i).Text) = Empty Then
Range("L" & i).Cut
Range("P" & i).Select
ActiveSheet.Paste
End If
Next I
End Sub
On Saturday, January 10, 2015 at 2:00:54 PM UTC+5:30
Dear All,
I have a doubt.
How to convert PDF file to Excel file using excel vba?
It is very useful to me.
Thanks in advance...
--
Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s
=TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @
https://www.facebook.
in and I tried to delete the if statements that were driving the error
checker. But that didnt change when the checker is ran. *
*You are the man Paul! Where are you from? *
*Thanks again!*
On Thursday, June 12, 2014 2:55:36 PM UTC-7, Michael Kohl wrote:
>
>
> Paul,
>
> Th
.
Paul
-
“Do all the good you can,
By all the means you can,
In all the ways you can,
In all the places you can,
At all the times you can,
To all the people you can,
As long as ever you can.” - John Wesley
-
Fro
uot;).End(xlToLeft).Column + 1
> With ThisWorkbook.Sheets(1)
> .Cells(1, i).Value = Left(wkb.Name, InStr(wkb.Name, ".") - 1)
> .Range(.Cells(2, i), .Cells(5, i)).Value =
> wkb.Sheets(1).Range("J6:j9").Value
> End With
> wkb.Close , False
> End Sub
>
>
&g
).Column + 1
> With ThisWorkbook.Sheets(1)
> .Cells(1, i).Value = Left(wkb.Name, InStr(wkb.Name, ".") - 1)
> .Range(.Cells(2, i), .Cells(5, i)).Value =
> wkb.Sheets(1).Range("J6:j9").Value
> End With
> wkb.Close , False
> End Sub
>
>
>
&
t wkb = Workbooks.Open(filename)
> i = ThisWorkbook.Sheets(1).Range("xfd1").End(xlToLeft).Column + 1
> With ThisWorkbook.Sheets(1)
> .Cells(1, i).Value = Left(wkb.Name, InStr(wkb.Name, ".") - 1)
> .Range(.Cells(2, i), .Cells(5, i)).Value =
> wkb.Sheets(1).R
Student_Master Table1
Grammar 0% 0% 0%
Reading / Writing 0% 0% 0%
Vocabulary 0% 0% 0%
Speaking / Listening 0% 0% 0%
As you can see it added some data but just zeros and also that
"Student_Master Table1"
On Sunday, June 1, 2014 11:55:15 AM UTC+8, Michael Lovin wrote:
>
>
office 2010
On Sunday, June 1, 2014 2:53:01 PM UTC+8, ashish wrote:
>
> are you using 2003
>
>
>
> On Sun, Jun 1, 2014 at 12:18 PM, Michael Lovin > wrote:
>
>> Wellit appears that it is doing something. (i see as if files open
>> but just for a s
Also I did chck that the files were *.xls and not *.xlsx... even tried
that in the VB to see if it worked...but also failed
On Sunday, June 1, 2014 11:55:15 AM UTC+8, Michael Lovin wrote:
>
> I am sure this has been asked many times but I cannot find a thread that
> answers my
he path to ...
Sub merge_data()
Dim filenm As String, folderpath As String
folderpath =
"C:\Users\Michael\Desktop\ESL_Consulting\Students\Student_Test\" ' change
folder here
filenm = Dir(folderpath)
Application.DisplayAlerts = False
Application.ScreenUpdating = False
While (filen
, ashish wrote:
>
> do you want data to be pasted in same column ? Can you share a sample
> input files and output yo like to see?
>
>
> On Sun, Jun 1, 2014 at 9:25 AM, Michael Lovin > wrote:
>
>> I am sure this has been asked many times but I cannot find a thread
Users\Michael\Desktop\ESL_Consulting\Students\Student_Test\)")
Do While Len(MyFile) > 0
If MyFile = "Student_Master.xlsm" Then
Exit Sub
End If
Workbooks.Open (Filepath & MyFile)
Range("J6:J9").Copy
ActiveWorkbook.Close
erow = Sheet1.Cells(Rows.Count, 1).End(xlU
Ashish - You are a very talented star! The code works perfectly. Thank
you so much. Michael
On Sat, Mar 29, 2014 at 12:47 PM, ashish koul wrote:
> Sub test()
> Dim filenm As String, folderpath As String
> folderpath = "C:\Documents and Settings\Ashish Koul\Desktop\
Ashish,
The code works great!!! How could it be modified to create a new Excel
document for each Word table discovered? Kindly advise. Thank you,
Michael
On Wednesday, October 2, 2013 1:09:44 AM UTC-4, ashish wrote:
>
> try this
>
> Sub import_word_ta
Add these codes:
[code]
Private Sub UserForm_Activate()
Dim AlphaInSlNo As String
Dim NumInSlNo As String
Dim LenSLNo As Integer
Dim NewSlNo As String
Sheets("VolunteerList").Select
LastRecNum = Cells(Rows.Count, "a").End(xlUp).Row 'to go to last data cell
inspite of blank cells
Range("A" &
(MIDASQ12013.UN_2010) AS KUN10, Sum(MIDASQ12013.UN_2011) AS KUN11,
Sum(MIDASQ12013.UN_2012) AS KUN12, Sum(MIDASQ12013.UN_2013) AS KUN13
FROM MIDASQ12013
GROUP BY MIDASQ12013.ATC3_COD, MIDASQ12013.PAIS
HAVING (((MIDASQ12013.PAIS)="brazil retail"))
ORDER BY Sum(MIDASQ12013.EUR_2013) DESC;
Regards,
UN10,
Sum(MIDASQ12013.UN_2011) AS KUN11, Sum(MIDASQ12013.UN_2012) AS KUN12,
Sum(MIDASQ12013.UN_2013) AS KUN13
FROM MIDASQ12013
GROUP BY MIDASQ12013.PAIS, MIDASQ12013.ATC3_COD
HAVING (((MIDASQ12013.PAIS)="BRAZIL RETAIL"))
ORDER BY Sum(MIDASQ12013.EUR_2013))
ORDER BY MIDASQ12013.COUNTRY DESC
y VBA code.
Thanks and Regards,
*Michael*
Em segunda-feira, 16 de setembro de 2013 22h44min29s UTC-3, Enrique Martin
escreveu:
>
> Make a query as "Select Top 20 From " in case you need a
> 20th record without changing your records order.
>
> but if you want the 20t
I was recently upgraded from Windows XP to Windows 7. When I was running
XP I had a number of Excel (2007) macros that I would use to connect to
Attachmate Reflection (IBM 3270 emulator). I am not sure which version of
Reflection is was. The VBA line that would make the connection from Excel
it run locally but not remotely, have you tried passing it your Username
and Password,
Also did you verify that all path's are absolute and present on the remote
machine as well
On Tuesday, January 10, 2012 10:06:54 PM UTC-7, The Muns wrote:
>
> I'm calling a bat file using psExec from one 200
http://sandwelltraining.com/ufnthho.php
--
Join official Facebook page of this forum @
https://www.facebook.com/discussexcel
FORUM RULES
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
Hi
c
Michael Cho
--
Join official Facebook page of this forum @
https://www.facebook.com/discussexcel
FORUM RULES
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
this is crazy you should check the out
http://www.business15canews.net/work/?read=5074813
--
FORUM RULES (986+ 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
this is intense you should check this out
http://www.business15nanews.net/biz/?page=0655543
--
FORUM RULES (986+ 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 Advic
I am working on a spreadsheet that contains several columns with due dates.
I have conditional formatting rules that change the cell color as a due
date gets closer to today's date.
<15 days = yellow
<10 days = orange
<5 days = red
Once an activity has been completed, the user formats the date
Happy birthday...!!
Best Regards.
Mr Michael Brumby
Diese Email und samtliche beigefugten Anhange sind vertraulich zu behandeln und
sind vor Veroffentlichung geschutzt. Informieren Sie den Absender bitte
umgehend und loschen Sie diese Nachricht mit allen beigefugten Anhangen, falls
Sie
Thank you Asa, I to needed this information, most kind.
Best Regards.
Mr Michael Brumby
Diese Email und samtliche beigefugten Anhange sind vertraulich zu behandeln und
sind vor Veroffentlichung geschutzt. Informieren Sie den Absender bitte
umgehend und loschen Sie diese Nachricht mit
r t(k).
Although the above equation is for the probabilities for the lowest
value, I'm guessing substituting "max" for "min" and "<" for ">" will
get the right equation. The question then is, can you solve the
equation in excel? And how difficult is
Rajan,
A most excel-ant game, thank you for sharing.
Kind Regards.
Michael Brumby
Diese Email und samtliche beigefugten Anhange sind vertraulich zu behandeln und
sind vor Veroffentlichung geschutzt. Informieren Sie den Absender bitte
umgehend
und loschen Sie diese Nachricht mit allen
When I do web queries and create pivot tables in Excel 2007, I really
dislike the automatic column width formattingthe columns are often
so narrow that my data is unreadable...is there a way to turn off the
auto column format function?
--
I just downloaded the Excel 2007 Web Data Add-in...I have two general
questions:
1. I cant seem to get a web page from a secure server (https) to
load...are there any issues here?
2. I have gotten data from a page like Yahoo finance, but once the
data is imported it is static...how do you keep the
I found the issue. Plain copy-control mistake. He changed the add-in default
directory on his copy to another location, so it was not accessing xla file.
Thanks for the response though. Really appreciate it.
Mike
On Wed, Jan 12, 2011 at 9:22 PM, Paul Schreiner wrote:
> It's been a while since I
Hi Team:
So Attached I have a small table, I need to create columns where the headers
appear next to the data. Can anyone assist, please?
Pivot tables don't work because they don't refresh correctly when utilizing
macros.
Than
C P SAVLA
You don't need a macro for this, just make sure that the cell is selected
when you save the file and it will open in the same cell when you next open
the file...
Kind regards
Michael
UK
From: excel-macros@googlegroups.com [mailto:excel-mac...@googlegroups.co
Steve,
Lets assume that your columns are labeled A, B & C. meaning that cell
A2=2, B2=3, C2=5
put this formula in cell C2, =IF(B2="",A2+C1-A1,B2+A2)
Copy that formula down.
Michael
On Aug 28, 12:43 am, xsrossiter wrote:
> Hello,
>
> I am using Excel 2002 SP3 and hop
T
CLOSED",AQ$1),AO$1),AM$1),AK$1),AI$1),AG$1),AE$1)
and in cell BB3 I put this formula
=IF(AT3="NA",IF(AV3="NA",IF(AX3="NA","NOT CLOSED",AW$1),AU$1),AS$1)
Copy those formulas down your sheet
Then in Cell P3 I put this formula
=IF(MIN(AZ3:BB3)=0,"N
Alex,
This a "Text to Columns" function. Select the column, use the Text to
Columns/ delimited function with "space" as an indicator.
In Excel 2007 "Text to Columns" can be found on the Data tab.
On Aug 18, 4:51 am, Alexander Cargill
wrote:
> Hi all I was wondering if you could help. I have a
Kalyan
I think Pivot table is your required solution using BP Group as your
Pivot Table Report Filter.
On Aug 18, 6:18 am, Kal xcel wrote:
> Dear Experts,
>
> I am attaching a file where I have raw data of Depot, Customer group, Month
> and Sales data. There are 16 types of customer group. I nee
This is a simple exercise with pivot table.
On Aug 12, 3:42 am, HARI NAIR wrote:
> In the attached file I want to know three results, how many persons given 4
> marks, out of which how many females , how many males.Please help me. Thanks
> in advance.
>
> Regards,
>
> Hari
>
> Book1.xls
> 59KVi
& B3) the formula in cell
C5 will return "N/A". If there is an intersection, then cell C5 will
not be blank.
Michael Hayes
On Aug 5, 10:35 pm, anandydr wrote:
> @ Michael Hayes
>
> Dear Michael,
>
> I went through the solution you sent for Mr Sudhir. Using his
> spr
ble)
Then in cell C6 enter this formula =IF(C5="N/A","N/A",+B2-((B2-C2)*(C5-
B4))) copy that formula over to cells D6 and E6
That formula will tell you your Y axis coordinate where the graphs
intersect (if applicable)
Email directly if you need a copy of the edited spreadshee
Team,
I agree, come on team, we have enough members and it's a great idea
Kind regards to everyone in our group and don't forget to vote...
Michael Brumby
Kent, UK
From: excel-macros@googlegroups.com [mailto:excel-mac...@googlegroups.com]
On Behalf Of Vinod N
Sen
If you can copy everything to the new column, the rest of it can be
done easily with a pivot table.
On Jul 17, 12:31 am, Scott wrote:
> Hi,
> I'm trying to create a list of unique names from a list of names (some
> duplicates) that exist on 15 different sheets within a spreadsheet.
> So I want t
Team,
Send file to a friend who has 2007 and ask them to save it in 2003 format
but remember some of the effects will be lost as 2003 may not be able to do
everything that 2007 can.
Hope this helps.
Michael
From: excel-macros@googlegroups.com [mailto:excel-mac...@googlegroups.com]
On
All:
I have attached a micro chart utilizing a UDF from the website:
http://www.dailydoseofexcel.com/archives/2006/02/05/in-cell-charting/
Is there a way to make the graph more sensitive to the data? It just looks
like a straight line.
Thanks
Michael
Hameet,
Try the concatenate function
=CONCATENATE("I have "&B1&" hands and "&C1&" Eyes")
Notice the spaces for the text inside the quotation marks...you need
those spaces to format your sentence properly.
On Jun 15, 6:37 pm, Harmeet Singh wrote:
> this should help. see attached file
>
> Warm
rogram to do so with
clear knowledge of the potential liability associated with such acts.
And hey if they do steal my work again, I'll be flattered and then let
the attorneys handle everything.
Thanks for your input.
Michael Hayes
On Jun 14, 9:06 am, Dave Bonallack wrote:
> Hi Mich
Kavita,
Thank you. I have been using this book as a coaster: "Excel 2007 VBA
for Dummies"...looks like I'm going to have to read it now. I think
I'm going to need more coffee.
Michael Hayes
On Jun 13, 11:50 pm, kavita ahuja wrote:
> Hi Michael,
>
> You can us userf
thms within the
spreadsheet?
Any way to create a "splash screen" or some legal notice that pops up
whenever the program is opened? And the user cant continue without
acknowledging the notice?
Thanks
Michael Hayes
--
Thanks so much! I tried every other combination, except tab!
Huge time saver!
On May 7, 2:54 am, Sandeep Kumar Maurya wrote:
> When we write function in any excel cell, EXCEL 2007 shows us a list of
> functions available from the word or character we written in the cell.
>
> Mich
ay
formulas.
Thanks so much for yoour help in advance!
Michael
--
--
Some important links for excel users:
1. Follow us on TWITTER for tips tricks and links :
http://twitter.com/exceldailytip
2. Join our L
Dilip,
I hope you are well.
I think this is fraught with options and complications.
I think it best to limit to just two digits.
Thanks
Michael
From: Dilip Pandey [mailto:dilipan...@gmail.com]
Sent: 15 April 2010 12:25
To: excel-macros@googlegroups.com
Cc: Drayton, Michael E [ICG-GTS
It should tell you which cell contains the link. Go to it and delete
it. You will need to hard code the data.
On Mar 17, 3:31 pm, "~slacker~" wrote:
> I need help in breaking data links to other excel workbooks. The excel
> workbook I am using (excel 2007) has links to other workbooks that can
>
Has anyone heard of using excel to physically execute trades
automatically based on the model written? If so, which trading
software best supports it?
thanks
mike
--
--
Some important links for excel users:
1. Follo
Dashboard is just a fancy name for a spreadsheet that summarizes key
data in graphical format (ie: multiple graphs and charts).
Pivot tables are tools that are used to consolidate / manage large
amounts of data. see here http://en.wikipedia.org/wiki/Pivot_table
If you have data to manipulate, pos
Team,
Does anyone know how to export 'Name Groups' from a Nova (T1) database into
an Excel spreadsheet please?
Kind regards
Mike Brumby
<><><><><><><><><><><><><><><><><><><><><><><><><><><><><><><><><><><><><><>
<><><>><>
<><><><><><><>There is always a little m
. These are things we know that we know. There are
> known unknowns. That is to say, there are things that we know we don't know.
> But there are also unknown unknowns. There are things we don't know we don't
> know."
>
>
&g
Hi group,
I am new to this macro stuff and I was wondering if anyone would be
able to tell me how to write code that would check down 1 column of
data to see if (AND(the cell is empty, the next cell below it has data
in it),then pop up a message box that says "Blank space dedtedted",
else do nothi
Why does no one seem to use the [A1] notation in preferece to Range
("A1")?
[A1].Select seems easier than
Range("A1").Select
Thanks
Michael
--~--~-~--~~~---~--~~
-
Thanks Sir!
YOU ARE THE KING!!!
Thanks ---
regards,
Michael
From: Dilip Pandey [mailto:dilipan...@gmail.com]
Sent: 13 October 2009 16:10
To: excel-macros@googlegroups.com
Cc: Drayton, Michael E [ICG-GTS]
Subject: Re: $$Excel-Macros$$ Re: Name Matching In
eet 1 may have 5,000 names. By
adding this extra step, I can validate that the match reflects what I believe
is a correct match.
I hope I didn't confuse you more.
Highest Regards,
Michael Drayton
From: Dilip Pandey [mailto:dilipan...@gmail.com]
Sent:
Is there an easy way to reference all the cells in a 10x10 named range
on another sheet. I am imagining somethign like an array formula that
will just reference each cell in a named ranged. If the range is 1
dimentional it seems to work but only if you are in the same row or
collum as the named ra
Or simply use the SUMIF function as in the attached doc.
On 8/7/09, Dilip Pandey wrote:
> Hi Anil,
> Solved sheet is attached with this email. Thanks
> --
> DILIP KUMAR PANDEY
> MBA-HR,B COM(Hons.),BCA
> Mobile: +91 9810929744
> dilipan...@gmail.com
> dilipan...@yahoo.com
> New Delhi - 110062
1 - 100 of 108 matches
Mail list logo
