Dear Members
I want to know about the new advanced excel formulas and addins. Please send
me some useful links or files by which i can know about that by downloading
all that.Specially if those links also having finance related funcion or
addins that will great for me also.
Thanking you
Thank you all...
On Mon, Jul 11, 2011 at 1:37 PM, ankur ankurpande...@gmail.com wrote:
*hi kalyan
as per ur requirementfind the solution...tell me if it helps u ..
*Have A Nice Time Enjoy Life
Regards:
CMA Ankur Pandey
(Someone Different)
I'm not the best but i'm not like the
Hi,
Can anyone suggest which book will be the best ot learn Charts (Like Bullet
Chart and Doughnut chart with Indication). If anyone have ebook please post
it. Thanks!.
Regards,
Chandra Shekar B
--
--
Some
Here are some good books name which are free on internet ..
VBA and Macros Microsoft Excel 2010 (MrExcel Library)
VBA Beginner How To Computer Programming Concepts and Visual Basic
Excel_2007_VBA_Programming_for_Dummies
Excel Programming WIth VBA and .Net
Excel Programming Absalute
See the Mention Links
http://www.office-excel.com/
http://www.ozgrid.com/VBA/excel-add-in-create.htm
From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com]
On Behalf Of L.K. Modi
Sent: Wednesday, July 13, 2011 10:49 AM
To: excel-macros@googlegroups.com
Subject:
Hi All,
I would like to take delayed days from attached file. The formula should
like below.
Colum I - Colum J = Delayed Days
The date format need to be same for further analysis.
Thanks in advance for your support.
Best Regards
Nilesh
P please consider the
Please attach a sample file with more explaination..
From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com]
On Behalf Of Puneet Jain
Sent: Wednesday, July 13, 2011 12:45 PM
To: excel-macros@googlegroups.com
Subject: $$Excel-Macros$$ HELP urgent
Guys
Need Help.
Hey ankur,
I want to ask something
Sub test()
Sheet1.Range(A2:A15).Clear
Dim i, j As Long
Range(a1).Value = InputBox(put your value)
For i = 1 To Sheets(1).Cells(1, 1).Value
Cells(i + 1, 1).Value = i
Next i
End Sub
In this code what is i j ?
*
Kαяαη*
On Mon, Jul 11, 2011 at 1:37
Use this in K2
=-(DATE(LEFT(I2,4),MID(I2,5,2),RIGHT(I2,2))-DATE(LEFT(J2,4),MID(J2,5,2),RIGH
T(J2,2)))
From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com]
On Behalf Of Virkar,Nilesh
Sent: Wednesday, July 13, 2011 12:40 PM
To: excel-macros@googlegroups.com
Subject:
Try this.
Range(A Range(A65536).End(xlUp).Row +
1).Resize(ActiveSheet.UsedRange.Rows.Count,ActiveSheet.Columns.Count).ClearC
ontents
C = ActiveSheet.UsedRange.Columns.Count
R = ActiveSheet.UsedRange.Rows.Count
-Original Message-
From:
Thanks it's works.
From: excel-macros@googlegroups.com
[mailto:excel-macros@googlegroups.com] On Behalf Of Rajan_Verma
Sent: Wednesday, July 13, 2011 1:20 PM
To: excel-macros@googlegroups.com
Subject: RE: $$Excel-Macros$$ Delayed Days
Use this in K2
Hello group!
I'm doing an Excel spreadsheet in which I posed the following problem, I put a
sample of what I have and a sample of what you need to get.
Sheet1
A1: Subject
Format: Text
A2: Document Code
format:
AAA-BBB-99 999-L-1
AAA-BBB-99 999-F-1
AAA-BBB-99 999-T-1
AAA-BBB-99
I need book for learning chart itself. If anything is there pls send it to
me.
Thanks,
Chandra Shekar B
On Wed, Jul 13, 2011 at 9:28 AM, Rajan_Verma rajanverma1...@gmail.comwrote:
*Here are some good books name which are free on internet ..*
* *
*VBA and Macros Microsoft Excel 2010
if any one have pdf file pls send me
J.Mothilal
On Wed, Jul 13, 2011 at 2:56 PM, Chandra Shekar
chandrashekarb@gmail.com wrote:
I need book for learning chart itself. If anything is there pls send it to
me.
Thanks,
Chandra Shekar B
On Wed, Jul 13, 2011 at 9:28 AM, Rajan_Verma
Hi friend, i don´t understand exactly what you want, but if you want to
highlight the entire row that has the negative numbers like this, or do you
want it to copy to another column the year and negative value?
Year Cash Available 2002 0 1983 6.71 1995 23.75 1994 21.06 2007 -11 2009
20 2011
PLease post a sample file with clear requirement.
On Wed, Jul 13, 2011 at 1:44 PM, Juan Antonio Castillo Guerrero
castill...@gmail.com wrote:
Hello group!
I'm doing an Excel spreadsheet in which I posed the following problem, I
put a sample of what I have and a sample of what you need to
Hi Rajan,
For some odd reason, putting in the parentheses does not affect the
outcome - runtime error continues to show up !
Appreciate any help you can give.
Thanks,
FG
On Jul 13, 3:42 am, Rajan_Verma rajanverma1...@gmail.com wrote:
Try this.
Range(A Range(A65536).End(xlUp).Row +
Try This
Sub GiveColor()
Dim rng As Range
Dim cell As Range
Set rng = Range(B2:B ActiveSheet.UsedRange.Rows.Count)
For Each cell In rng
If cell.Value 0 Then
cell.Offset(0, -1).Resize(1, 2).Interior.ColorIndex = 38
End If
Next
End Sub
From: excel-macros@googlegroups.com
Hi Sajid,
First of all, your sheet is protected, I couldnt save it as.. and 2nd you
are using wrong formulas.. specially which naming the range.
In the form sheet you are trying to do vlookup on a blank source.. in the
last sheet you are using a wrong name range for Vlookup..
We need an
You Can use conditinoal formatting
On Wed, Jul 13, 2011 at 4:05 PM, Jorge Marques leote.w...@gmail.com wrote:
Hi friend, i don´t understand exactly what you want, but if you want to
highlight the entire row that has the negative numbers like this, or do you
want it to copy to another column
hi,
can you refer me the best web site for flash(actionscript) and excel
(vba) connection.
Thanks
senthilkumar
--
--
Some important links for excel users:
1. Follow us on TWITTER for tips tricks and links :
If you are using Excel 2007, then you can do part of this without VBA. If
you want to change color of cell, for example, when the cell value is
negative, you can accomplish this by going to Home Conditional Formatting
and then creating a rule by which the cell changes. This is probably
*Hey,
Please find the below mention link for Microsoft Excel 2077 VBA Macro
Programming 2009*
http://www.4shared.com/document/Kd7W3YMN/MicrosofExcel2007VBAMacroProgr.htm
*
Regards, Vikas Chauhan*
On Wed, Jul 13, 2011 at 3:46 PM, jmothilal gjmothi...@gmail.com wrote:
if any one have pdf file
Below mentioned is an opening of life time with one of the most esteemed
management consulting firm. If currently you are aiming for a job change
please do read the below e-mail very carefully.
*About The Client: -*
McKinsey is a preeminent management consulting firm that helps leading
ur name range (PDATA) shud start frm col B and not from col A.i.e. from col B
to
col F or may b more if u like. so the new formula will b
=VLOOKUP(K13,PDATA,5,FALSE)
formula without name range.
=VLOOKUP(I18,$B$2:$F$3,5,FALSE)
this will solve the problem
From: SAJID MEMON
Hi guys, i have this table where i want to fill the column A with 2010
Real but stopping when in the same row the column B is Total i used Do
Loop but i can´t seem to find the right code.
sub fill2010real()
Do until range(B:B).value = Total
range(A:A).value = 2010 Real
loop
end sub
I can´t seem
try this
Sub fill2010real()
Dim i As Long
i = 1
Do Until Cells(i, 2).Value = Total
Cells(i, 1).Value = 2010 Real
i = i + 1
Loop
End Sub
On Thu, Jul 14, 2011 at 5:39 AM, Jorge Marques leote.w...@gmail.com wrote:
Hi guys, i have this table where i want to fill the column A with 2010
Real but
Ah that was fast and PERFECT :), i suppose, cell(i,2), the 2 is for column
B, 3 C 4 D and so on(this is a huge implement in my learning), many many
many thanks Ashish, perfect as always :).
2011/7/14 ashish koul koul.ash...@gmail.com
try this
Sub fill2010real()
Dim i As Long
i = 1
Hello Nilesh,
Another way, K2 copy down.
=TEXT(I2,\/00\/00)-TEXT(J2,\/00\/00)
If you don't want to see -days use
=ABS(TEXT(I2,\/00\/00)-TEXT(J2,\/00\/00))
Or,
convert the Dates to actual date, for doing this,
Select the whole column I:I, go to,
Data Text to Columns
Hi All,
I have an acadamic question paper on desiginig spreadsheet solution.
Need your help.
The proprietor of Pizza Kutir has realized that a certain segment of
his customers consists of low budget customers, who before placing an
order, state the maximum amount (budget) they want to spend, and
Hi,
I am looking for macro where in i can do find replace in all opened excel
workbook.
Eg., I have 10 Excel workbook(s) where the Common Text is asdfghjkl which
i want replace with lkjhgfdsa.
Presently I am doing this manually. Request to help me to get the macro.
Regs
Sunny
--
Use this
Sub EndLoop()
Range(A2).Select
Do
ActiveCell.Value = 2010 Real
ActiveCell.Offset(1, 0).Select
Loop Until ActiveCell.Offset(0, 1).Value = Total
End Sub
From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com]
On Behalf Of Jorge Marques
Sent: Thursday,
32 matches
Mail list logo