Hi,Prabhu!
All !dias are great...! simply you should use someif.
On Tue, Sep 13, 2011 at 10:51 AM, NOORAIN ANSARI
wrote:
> Dear Prabhu,
>
> Please see attached sheet..
> Conditional SUM thourgh VBA..
>
>
>
>
> On Tue, Sep 13, 2011 at 7:15 AM, Prabhu wrote:
>
>> Hi All,
>>
>> I need to compare t
Dear all,
I want Help for creating the VBA Codes for Repeating of Text in my Excel
sheet..
*Problem :*
I have made excel sheet in Columns.In which I have some texts which are
likely to repeat in my sheet frequently. So please help me to make proper
Hot Keys to make my work fast and easy.
Ex
Hi All
Please help me for the inventory sheet for manufacturing unit.
Regards
Manhar
--
On Sat, Sep 10, 2011 at 4:33 PM, manhar prajapati <
prajapati.man...@gmail.com> wrote:
> Hi
>
> Anyone have inventory sheet for manufacturing unit.
>
>
>
> --
> *Manhar Prajapati*
> *Contact: 9824335449*
thank one and all for providing solution for me.
On Tue, Sep 13, 2011 at 12:23 AM, dguillett1 wrote:
> Repost
> I really don’t use USERFORMS, but try
>
> Private Sub CommandButton1_Click()
> txtdor.Text = DateSerial(Year(txtdob.Text) + 60, Month(txtdob.Text) + 1, 0)
> End Sub
>
> *From:* dgui
Dear Awal,
Please see below link it will help to u.
http://www.vbaexpress.com/kb/getarticle.php?kb_id=360
On Tue, Sep 13, 2011 at 5:46 AM, Awal wrote:
> I have a macro to sort and subtotal a set of data. This data will
> always be different amount of lines. I can set the mac
Dear Prabhu,
Please see attached sheet..
Conditional SUM thourgh VBA..
On Tue, Sep 13, 2011 at 7:15 AM, Prabhu wrote:
> Hi All,
>
> I need to compare two columns and sum the unique value.
>
> Example:
>
> Apple 10
> Orange 5
> Apple 20
> Mango 25
> Orange 15
> Mango 7
>
>
> Result
Use sumif or put pivot tableplease find the attachment..
On Tue, Sep 13, 2011 at 7:15 AM, Prabhu wrote:
> Hi All,
>
> I need to compare two columns and sum the unique value.
>
> Example:
>
> Apple 10
> Orange 5
> Apple 20
> Mango 25
> Orange 15
> Mango 7
>
>
> Result
>
> Apple 30
try this
Sub copy_files()
Dim ServerA As String
Dim ServerB As String
ServerA = "C:\temp\filename.dat"
ServerB = "C:\temp\filename2.xls"
FileCopy ServerA, ServerB
End Sub
On Tue, Sep 13, 2011 at 7:30 AM, Prabhu wrote:
> Hi All,
>
> How to convert DAT to Excel file.
>
> Now i am just conver
Hi All,
How to convert DAT to Excel file.
Now i am just converting by importing DAT to excel but i am facing
some alignment problem.
Plz help to know the same.
Regards
Prabhu
--
--
Some important links for excel u
Hi All,
I need to compare two columns and sum the unique value.
Example:
Apple 10
Orange 5
Apple 20
Mango 25
Orange 15
Mango 7
Result
Apple 30
Orange 20
Mango 32
Plz help to know the formula.
Regards,
Prabhu
--
--
I have a macro to sort and subtotal a set of data. This data will
always be different amount of lines. I can set the macro to subtotal
only current range. If I try to include all lines so that I account
for when the lines of data increase, it will not allow the first line
to be included.
Here is my
Consultant Parvathy
Email ID parva...@absolutehrs.com
Subject: Absolute HR - XL Group - Analyst - Management Information
This refers to our telecon today; firstly I would like to thank you for your
time.
*Absolute HR International* is a Global Talent Acquisition Consulting
firm. Abs
Just put in the top cell and use the fill handle to copy down
-Original Message-
From: Rajesh K R
Sent: Monday, September 12, 2011 2:08 PM
To: excel-macros@googlegroups.com
Subject: Re: $$Excel-Macros$$ Look formula to select ledger group
Hi,
Thanks for getting a very quick reply, I d
Hi,
Thanks for getting a very quick reply, I don't know lookup formulas.
Regards
Rajesh Kainikkara
On 9/13/11, dguillett1 wrote:
> It appears that a simple vlookup should do it.
> =IF(ISNA(VLOOKUP(A11,$A$1:$B$8,2,0)),"",(VLOOKUP(A11,$A$1:$B$8,2,0)))
>
> -Original Message-
> From: Raje
Hi,
I was not aware of that.Thanks for information.
Regards
Rajesh Kainikkara
On 9/13/11, dguillett1 wrote:
> I would strongly suggest that you not try to break this password UNLESS
> poster can PROVE ownership. Legal problems
>
> -Original Message-
> From: Rajesh K R
> Sent: Mon
I would strongly suggest that you not try to break this password UNLESS
poster can PROVE ownership. Legal problems
-Original Message-
From: Rajesh K R
Sent: Monday, September 12, 2011 1:58 PM
To: excel-macros@googlegroups.com
Subject: Re: $$Excel-Macros$$
Hi,
Pls send me the file,
It appears that a simple vlookup should do it.
=IF(ISNA(VLOOKUP(A11,$A$1:$B$8,2,0)),"",(VLOOKUP(A11,$A$1:$B$8,2,0)))
-Original Message-
From: Rajesh K R
Sent: Monday, September 12, 2011 1:51 PM
To: excel-macros
Subject: $$Excel-Macros$$ Look formula to select ledger group
Hi Experts,
Hi,
Pls send me the file, I will try.
Regards
Rajesh
On 9/12/11, channa srinivas wrote:
> hello everyone
>
> i have created a macro and protected it
> and i forgot the password
> is it possible to view the code??
> please help
>
> thanks
>
> srinivas
>
> --
> -
Repost
I really don’t use USERFORMS, but try
Private Sub CommandButton1_Click()
txtdor.Text = DateSerial(Year(txtdob.Text) + 60, Month(txtdob.Text) + 1, 0)
End Sub
From: dguillett1
Sent: Monday, September 12, 2011 1:04 PM
To: excel-macros@googlegroups.com
Subject: Re: $$Excel-Macros$$ date diff
Hi Experts,
Is there any formula we can use to select matched texts just like
sumif formula(in case of numbers).Kindly find the attached file it
ellaborate well about the issue.And tell me how to solve it.
Regards
Rajesh Kainikkara
--
---
I am an advocate of the KISS (keep it simple stupid-not meant personally) so
stick with my original offering.
From: Shankar Bheema
Sent: Monday, September 12, 2011 10:58 AM
To: excel-macros@googlegroups.com
Subject: Re: $$Excel-Macros$$ date difference
but i am using userform na sir. So pls se
Shankar, IIF is an alternative for the IF Else.End if. statement
to evaluate single-statement true-false comparisons. The *IIf* function is
easier to debug and shortens the amount of code you need to write, and it
takes for following format:
IIf(Expression, TruePart, FalsePart)
The
Thought you wanted to increment date only...
Try this
Private Sub CommandButton1_Click()
txtdor.Text = DateAdd("", 60, IIf(Day(CDate(txtdob.Text)) = 1,
DateAdd("d", -1, CDate(txtdob.Text)), DateAdd("m", 1,
DateSerial(Year(CDate(txtdob.Text)), Month(CDate(txtdob.Text)), 1)) - 1))
End Sub
Hi All,
Need your help to Populate the data from the pivot for the available
columns.
Regards
Anu
On Thu, Sep 8, 2011 at 10:57 PM, anu gomathi wrote:
> Hi All,
>
> Please find the attached file. Need to populate the data sheet from pivot
>
> Regards
>
> Anu
>
> On Thu, Sep 8, 2011 at 10:46 PM,
amazing its working bro.
i didnot understand that, in the code you have
written IIf(Day(CDate(txtdob.Text). I thought its wrong and changed it
to If(Day(CDate(txtdob.Text) then it thrown error. Why it happened so. IIf
is what for ?
On Mon, Sep 12, 2011 at 9:46 PM, Sam Mathai Chacko wrote:
> An
And if you go the formula way, try this
=IF(DAY(A2)=1,DATE(YEAR(A2-1)+60,MONTH(A2-1)+1,0),DATE(YEAR(A2)+60,MONTH(A2)+1,0))
On Mon, Sep 12, 2011 at 9:43 PM, Sam Mathai Chacko wrote:
> Thought you wanted to increment date only...
>
> Try this
>
> Private Sub CommandButton1_Click()
>
> txtdor.T
I tried with the provided code but its working only with the years but
months and days are not working
On Mon, Sep 12, 2011 at 9:33 PM, Sam Mathai Chacko wrote:
> Private Sub CommandButton1_Click()
>
> txtdor.Text = DateAdd("", 60, IIf(Day(CDate(txtdob.Text)) = 1,
> DateAdd("d", -1, CDate
Private Sub CommandButton1_Click()
txtdor.Text = DateAdd("", 60, IIf(Day(CDate(txtdob.Text)) = 1,
DateAdd("d", -1, CDate(txtdob.Text)), CDate(txtdob.Text)))
End Sub
Regards,
Sam Mathai Chacko (GL)
On Mon, Sep 12, 2011 at 9:28 PM, Shankar Bheema wrote:
> but i am using userform na sir.
but i am using userform na sir. So pls see my attachment and i am not
understanding the mistake i did in my code
On Mon, Sep 12, 2011 at 9:07 PM, dguillett1 wrote:
> Why not just a simple formula for a dob in cell d11
>
> =DATE(YEAR(D11)+60,MONTH(D11)+1,0)
>
> *From:* Shankar Bheema
> *Se
Try
Workbooks.OpenText Filename:=fldpth & fname, _
Origin:=xlWindows, StartRow:=1, DataType:=xlFixedWidth, FieldInfo:= _
Array(0, 2), TrailingMinusNumbers:=True
On Mon, Sep 12, 2011 at 6:40 PM, mrinal saha wrote:
> Hey Folks,,
>
> I have figured out a code to match the text file with excel sh
Why not just a simple formula for a dob in cell d11
=DATE(YEAR(D11)+60,MONTH(D11)+1,0)
From: Shankar Bheema
Sent: Monday, September 12, 2011 9:54 AM
To: excel-macros@googlegroups.com
Subject: $$Excel-Macros$$ date difference
Hai all,
I am attaching an excel userform which conta
Hai all,
I am attaching an excel userform which contains Dateof Birth textbox and
Date of Retirement textbox.
Conditions are:
i) Date of Retirement should be 60 years after Date of Birth
eg. if date of birth is in the year 1960 date of retirement would be 2020
ii) Date of retirement would be la
>
>
> - Original message
> From:""Scope International Pvt Ltd""< ramya.rampra...@sc.com >
> Date: 12 Sep 11 16:01:05
> Subject: Walk in For Finance Professionals on September 13th and
> 14thTuesday and Wednesday@ Scope International Haddows Road
> To:
>
> The sender of this email i
hello everyone
i have created a macro and protected it
and i forgot the password
is it possible to view the code??
please help
thanks
srinivas
--
--
Some important links for excel users:
1. Follow us on TWITTER
hello everyone
I have created a macro long back and i have protected it
and now forgot the passwork,
is it possible to veiw the code??
--
--
Some important links for excel users:
1. Follow us on TWITTER for ti
I guess I'm in over my head. I have no clue how to use what you just
attached. Thanks anyway.
On Sep 8, 9:30 pm, NOORAIN ANSARI wrote:
> Dear Robert,
>
> Please see attached add-in. It will be help to Compare Table.
>
> On Fri, Sep 9, 2011 at 12:29 AM, Robert Jacobs
> wrote:
>
>
>
>
>
>
>
>
>
Hey Folks,,
I have figured out a code to match the text file with excel sheet name.but
not able to open thetext file. Error in red line.
I want to open without using get openfilename.
Sub Read_text_File()
Dim fso, fld, fil As Object
Dim fldpth As String
fldpth = "C:\Documents and Settings\287
For each in a LIST in range(“a1:a12”)
Sub test()
For i = 1 To 12
ThisWorkbook.Sheets(Array("Sheet1", "Sheet2")).Copy
ActiveWorkbook.SaveAs "C:\Documents and Settings\ASHISH\Desktop\ABC\book" &
cells(I,”a”) & ".xlsx"
ActiveWorkbook.Close
Next i
End Sub
From: ashish koul
Sent: Wednesday, September
Thanks for your reply...
Can you please do a small favour for me.
Now I want to copy the same data not in to more sheets, it should be into
different workbooks.
Thanks and Regards,
Naresh V,
Sr Analyst,
iSpace global services India pvt ltd.
From: excel-macros@googlegroups.com [mailto:exce
Hi Ashish, appreciate you help.
The code is partly okay. The above code created a new files with those x and
y sheets.
Can you alter the above macro code, so that those x and y sheets will get
pasted to already existing (12)files?
Appreciate your help once again.
Regards,
Sridhar BL
--
- Original message
From:""S Suvarna""< ssuva...@magna.in >
Date: 12 Sep 11 13:12:37
Subject: Urgent Oening for SQL Server Developer at Chennai based Client
To: "S Suvarna"
Hi,
Greetings for the day!!!
Let me take this opportunity to introduce Magna Infotech Pvt. Ltd. We are
on
41 matches
Mail list logo
