Hi
You can find the same under Templates section in MS Excel.
1. Open MS Excel
2. Go to File -> New -> Templates -> More Templates -> Ledgers
Regards
Rajender Soni
On Jul 8, 9:46 am, Dilip Pandey wrote:
> FYI & FYNA...!!
>
> --
> Thanks & Regards,
>
> DILIP KUMAR PANDEY
> MBA-HR,B.Com(Hons),
Hi Andy
Thanks for sharing the detailed info on loop.
Regards
Rajender Soni
On Jul 7, 6:28 am, Aindril De wrote:
> Hi Venkat,
>
> *
>
> The purpose of a loop is to get Excel to repeat a piece of code a certain
> number of times. How many times the code gets repeated can be specified as a
> fixe
Hi
Please find the code below.
Sub test()
Dim one As String
Dim two As String
Dim three As String
Dim four As String
one = Range("a1")
two = Range("b1")
Range("c1").Value = ""
For x = 1 To 10
If Mid(one, x, 1) = Mid(two, x, 1) Then
Else
Range("c1") = Range("c1").Value & Mid(one, x, 1)
End If
Next
Hi
Can you pls attached a sample sheet, what you are looking for.
Regards
Rajender Soni
On Jul 7, 11:30 am, Bhawna Jain wrote:
> Hi All,
>
> Can anyone tell me how to insert sub columns under single column in an Excel
> Worksheet.
>
> Thanks
> Bhawna
--
---
FYI & FYNA...!!
--
Thanks & Regards,
DILIP KUMAR PANDEY
MBA-HR,B.Com(Hons),BCA
Mobile: +91 9810929744
dilipan...@gmail.com
dilipan...@yahoo.com
New Delhi - 62, India
-- Forwarded message --
From: Jitender
Date: Thu, 8 Jul 2010 09:26:57 -0700
Subject: Help Accounting
To: dili
Hi
You can use the below formulae for calculation as required:
=EDATE("31-mar-2011","-6")
Regards
Rajender Soni
On Jul 7, 5:21 pm, Avinash Daga wrote:
> Assuming your current date is in a1 cell
>
> =date(year(a1),month(a1)-6,day(a1))
>
> Please let me know,if this works
>
>
>
>
>
> On Wed,
Hi,
You can't change the format of data validation drop-down menus.
The option is to use a combo box from the forms or control toolbox menus
Regards - Dave.
Date: Wed, 7 Jul 2010 22:47:28 +0530
Subject: $$Excel-Macros$$ Increase the Text Size in drop-down
From: nikhil201...@gmail.com
To: ex
> I don't know what the range is that you are referring to but:
"... The original code references rows 2 to 259 in Column A. I have
since
named A2:A259 "MyRange" ..."
So the range I'm referring to is A2:A259.
(I named this range in the Excel sheet by selecting the cells and
entering "MyRange" in
Hi Friends
Query :
I have a drop-down list that displays at about a size 6 (or smaller) font
when the worksheet is displayed at 75-100%. I can make it readable by
changing the magnification of the sheet to 150-200%, but that takes the rest
of the sheet out of view, interferes with functionality, a
Hi Sajid
Click on sheet1 tab
right click & select view code
copy below mention code
enter value in c8 & press enter cursor will move to G14
Private Sub Worksheet_Change(ByVal Target As Range)
If Target.Address = "$C$8" Then
Range("G14").Select
End If
End Sub
On Wed, Jul 7, 2010 at 7:36 PM, SAJ
Dear aindril plz help me, awaiting your replay.
Date: Mon, 5 Jul 2010 12:08:52 +0530
Subject: Re: $$Excel-Macros$$ Problem facing
From: aind...@gmail.com
To: excel-macros@googlegroups.com
Hi Sajid,
Would it be possible for you to share a sample sheet
Regards,Aindril
On Mon, Jul 5, 2010 at 10:
Assuming your current date is in a1 cell
=date(year(a1),month(a1)-6,day(a1))
Please let me know,if this works
On Wed, Jul 7, 2010 at 4:06 AM, Nikhil Shah wrote:
> Hi Friends,
>
> Here I am sending One Query, pl Give the formula..
>
> Date : 31/03/2011 ( Format is dd/mm/ )
> Deduct : 6 (
You are welcome Nikhil..!!
--
Thanks & Regards,
DILIP KUMAR PANDEY
MBA-HR,B.Com(Hons),BCA
Mobile: +91 9810929744
dilipan...@gmail.com
dilipan...@yahoo.com
New Delhi - 62, India
On Wed, Jul 7, 2010 at 6:17 PM, Nikhil Shah wrote:
> Hi Dilip
>
> Thanks for sending me formula..I have apply this
Hi,
If original date is in A1:
=EOMONTH(A1,-6)
Regards - Dave.
Date: Wed, 7 Jul 2010 16:36:18 +0530
Subject: $$Excel-Macros$$ Query - How To Find out Month
From: nikhil201...@gmail.com
To: excel-macros@googlegroups.com
Hi Friends,
Here I am sending One Query, pl Give the formula..
Date : 31/0
Hi Nikhil,
Try below formula:-
=DATE(YEAR(C3),MONTH(C3)-6,DAY(C3))
Note:- Day portion of Date may vary as per the exact calculation, please
revert if you need 31 or 30 as the date every time.
--
Thanks & Regards,
DILIP KUMAR PANDEY
MBA-HR,B.Com(Hons),BCA
Mobile: +91 9810929744
dilipan...@gmai
Absaloutly perfect mate J thanks so much
From: excel-macros@googlegroups.com [mailto:excel-mac...@googlegroups.com]
On Behalf Of Aindril De
Sent: 07 July 2010 02:25
To: excel-macros@googlegroups.com
Subject: Re: $$Excel-Macros$$ How to alter the contents of a row in a sheet
Hi Alex,
Ple
Hi Friends,
Here I am sending One Query, pl Give the formula..
Date : 31/03/2011 ( Format is dd/mm/ )
Deduct : 6 ( Months )
Answer Should be : 30/09/2010
Thanks
Nikhil Shah
--
--
Some important links for e
it is not ?
On 5 juil, 14:40, Alfred WALLACE wrote:
> Hi to all !
> I'm wondering if it is possible to set à graph to a shape in vba ?
>
> Thx for your help
--
--
Some important links for excel users:
1. Follow us o
Urgent help is required. Please help!
--
--
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 @ http://www.linkedin.
Dear Experts!
Hi.
I have a big Excel file where over a 100 places, there are Embedded Word
Documents. I want to extract all such embedded documents on a separate sheet
and remove the embedded documents from Excel.
Kindly help
Regards!
--
Have a good day!
Muneeb
Cell: 0300 2213043
--
---
HI Subbu,
I hope you have found the solution for this query.
Recently I came across a similar kind of query and after solving that I have
customized the solution to solve your query. Please find the attached
solution and let me know if this helps. Thanks.
--
Thanks & Regards,
DILIP KUMAR PAND
Hi All,
Can anyone tell me how to insert sub columns under single column in an Excel
Worksheet.
Thanks
Bhawna
--
--
Some important links for excel users:
1. Follow us on TWITTER for tips tricks and links :
http://t
22 matches
Mail list logo
