Hi,
I've a workbook where two tables given on the sheet1 showing sales for 2009
and 2010. I want to present the data through Line Char. There should be a
dropdown on the top of the charts containing three values 2009, 2010 2009
Vs 2010. If I select 2009 then the chart should show only sales
HI sumanth
Bhupendra Chaudari had send Xcellent link for VBA
http://www.pdftop.com/ebook/vba+for+dummies/
Try to downoad a appropiate file Try it
--- On Wed, 8/9/10, sumanth kumar sumanth@gmail.com wrote:
From: sumanth kumar sumanth@gmail.com
Subject: Re: $$Excel-Macros$$ VBA
To:
Thanx a lot I would like to know how to have the new symbol in the below
mentioned format :
[999]Rs. ##\,##\,##\,##0.00;[9]Rs. ##\,##\,##0.00;Rs.##,##0.00
N.SHIVKUMAR
--
--
Some important links for excel
Dear Aftab,
Please find attachment with solution.
Thanks,
Noorain Ansari
On Wed, Sep 8, 2010 at 3:06 PM, ALAM aftab.ala...@gmail.com wrote:
Dear all,
I want to make complete Attendance sheet in excel format
and other application or S/w. like FoxPro/ c++ /V.B.
Note:--
have u checked that attachment its working fine at my place
--
*Regards*
* *
*Ashish Koul*
*akoul*.*blogspot*.com http://akoul.blogspot.com/
*akoul*.wordpress.com http://akoul.wordpress.com/
My Linkedin Profile http://in.linkedin.com/pub/ashish-koul/10/400/830
P Before printing, think about
hi Dilip,
Thank u very much for contributing time for me. But I am facing some problem
in the given file.
Actually I need this:
When I select 01.04.2010 to 30.04.2010 it will show april, if date is from
01.05.2010 to 31.05.2010 it will show may, when date will cross 30.04.2010
from 01.04.2010
no problem welcome.
On Wed, Sep 8, 2010 at 5:38 PM, api gud aparnagud...@gmail.com wrote:
Sorry for the inconvenience. I have disabled the macros..that
was not able to run the macro attached. Now its working perfectly.
Thanks Ashish
On Sep 8, 8:19 am, ashish koul
Hi kalyan,
This is not possible without vba as u r asking for a sheet to be
available on password, else u can simply go ahead n use protect sheet
option available under Tools menu.
Best Regards,
DILIPandey
On 9/8/10, Kal xcel kalx...@gmail.com wrote:
Hi Dilip,
Thanks a lot for your help, but
*(1) : Macro VBA-Excel Solution*
Private Sub CommandButton1_Click()
Dim SrceTbl As Range, DestTbl As Range
Dim r As Long, nr As Long, c As Integer
Set SrceTbl = Sheets(Sheet1).Cells(1, 1).CurrentRegion
Set DestTbl = Sheets(Sheet2).Cells(2, 2)
For r = 2 To SrceTbl.Rows.Count
Hi,
I assume your shading is currently done manualy.
It could easily done with VBA or even more easily with Conditional formatting,
as long as you aren't currently using it for something else.
Select all cells in the block
Open the conditional formatting dialogue box
Select 'Formula is'
Hi, Experts
I need u r help, i have a excelsheet my problem is I am only looking for
e-mail id in different colums
ex in Colum F --- resume @alsachi.com
if I do one by one copy paste it's a lot of time , is any short cut to do
it
--
*Warm Regards
Pankaj kumar
M: 9899816107
e-mail:
You can copy the all the email ids after filtering them and then paste
special and transpose them.
Is this wht u r looking for ?
On 9/9/10, Pankaj Kumar rajputpanka...@gmail.com wrote:
Hi, Experts
I need u r help, i have a excelsheet my problem is I am only looking for
e-mail id in
Dear Dilip,
I can't see the codes. How shal I get codes. Please help me..I am not
comfortable with VBA.
And what is the password.
Thanks in advance
Kalyan
On Thu, Sep 9, 2010 at 12:01 AM, Dilip Pandey dilipan...@gmail.com wrote:
Hi kalyan,
This is not possible without vba as u r
Hi,
I need a help to connect excel file to a database in Access, I've a table
format in the attached file, can anyone make a macro to solve this query.
1) Macro should take inputs from a useform and saved the data in the table
in access databse. Seq# should be unique and auto generated for every
14 matches
Mail list logo