Try this
Sub INputDate()
Range(A1).Value = Application.InputBox(Please Enter YOur date, , , , , ,
, 1)
Range(A1).NumberFormat = mm/dd/yy
End Sub
-Original Message-
From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com]
On Behalf Of Erick C
Sent: Friday, August 12, 2011
Hope it will help you
Add this in Your code
If Day(Me.DTPicker1.Value) = Day(Now()) And Month(Me.DTPicker1.Value) =
Month(Now()) And Year(Me.DTPicker1.Value) = Year(Now()) Then
If Hour(Me.DTPicker2.Value) = Hour(Now)
Minute(Me.DTPicker2.Value) = Minute(Now) Then
MsgBox
Team,
Can you please help me on my query.
I want you to work on attached file itself.
Waiting for your response
Regards,
-- Forwarded message --
From: hemant shah hemanthin...@gmail.com
Date: Wed, Aug 3, 2011 at 9:26 PM
Subject: $$Excel-Macros$$ Need help on Email from Excel
try this
http://akoul.wordpress.com/category/email-through-excel-using-outlook/
On Wed, Aug 3, 2011 at 9:26 PM, hemant shah hemanthin...@gmail.com wrote:
Dear Team,
I need a help on emailing from excel itself.
I have explained all the steps in the attached excel.
Regards,
--
can you attach the sample sheet
On Tue, Jul 26, 2011 at 4:39 PM, Venkatesh Narla nvenki...@gmail.comwrote:
Hi All,
Need help for SUMIF Function i am doing time sheet conslidation i am
not able sum up all days for one resource in other TAB
Example:
Resource7/1/2011
*Sent:* Friday, July 22, 2011 9:37 PM
*To:* excel-macros@googlegroups.com
*Subject:* Re: $$Excel-Macros$$ need help
** **
cjeck the attachment have applied conditional formatting
** **
** **
** **
On Fri, Jul 22, 2011 at 8:47 PM, Akshay akshaya.mal...@gmail.com wrote
Hey Haseeb,
This formula is AWESOME man... Tooo goood.. helped me big time..
A big THANK YOU :)
Thanks,
Anish
On Tue, Jul 12, 2011 at 8:25 AM, Haseeb Avarakkan
haseeb.avarak...@gmail.com wrote:
Hello, Try this Array Formula. Must hit CONTROL+SHIFT+ENTER, rather than
ENTER.
Thanks Ankur, Rajan, Haseeb and Ashish for helping me.. :)
On Tue, Jul 12, 2011 at 5:37 PM, Rajan_Verma rajanverma1...@gmail.comwrote:
*=VLOOKUP(*A1*,Sheet1!A:A,1,0)*
*Use this*
* *
*From:* excel-macros@googlegroups.com [mailto:
excel-macros@googlegroups.com] *On Behalf Of *Anish
*can u explain ur requirement with a sample file?, i m not getting it
properly
*Have A Nice Time Enjoy Life
Regards:
CMA Ankur Pandey
(Someone Different)
I'm not the best but i'm not like the rest~~
On Sun, Jul 10, 2011 at 10:10 PM, Rajan_Verma rajanverma1...@gmail.comwrote:
*Which is the
Hi,Thanks for taking initiative ,
See there are two Clients:-
1 Genentech
2 Lifetech
Both have three tabs Open,closed,Rejection that means total 6 tabs but i
want only three tabs named Open,close,Rejection,in Open tab i want to put
all GenentechLifetech Open data same in closed tab i want to put
try this
VLOOKUP(A1*,Sheet1!$A:$A,1,0)
On Mon, Jul 11, 2011 at 3:42 PM, Anish Shrivastava anish@gmail.comwrote:
Hello Experts,
I am writing this mail with a great hope.
Please see the attached file where I have 2 sheets with data populated
column A.
I want to find the best possible
Hi Ashish,
This one looks great but it will only help if few of the characters at the
end of the text is missing.
For Example - Guitar Center, . (row # 1650) in the 2nd sheet is not able
to find the value because it's Guitar Center, Inc. in sheet one.
*I wanted something like which matches the
Which is the Column of Client Name.??
From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com]
On Behalf Of syed aliya raza hashim
Sent: Saturday, July 09, 2011 1:10 AM
To: excel-macros@googlegroups.com
Subject: $$Excel-Macros$$ need help
Hi,
Hi ,
I have the two client
-macros@googlegroups.com
Objet : Re: $$Excel-Macros$$ Need Help Help Help.Putting value in user
from by loop
Daneil, that is what i want but the same code is not working.in my
sheet.
what is Me.contol ?
On Fri, Jul 8, 2011 at 10:22 PM, Daniel dcolarde...@free.fr wrote:
Give
: samedi 9 juillet 2011 00:32
À : excel-macros@googlegroups.com
Objet : Re: $$Excel-Macros$$ Need Help Help Help.Putting value in user
from by loop
Daneil, that is what i want but the same code is not working.in my
sheet.
what is Me.contol ?
On Fri, Jul 8, 2011 at 10:22 PM
@googlegroups.com]
*De la part de* shariq khan
*Envoyé :* samedi 9 juillet 2011 13:01
*À :* excel-macros@googlegroups.com; dcolarde...@free.fr
*Objet :* Re: $$Excel-Macros$$ Need Help Help Help.Putting value in
user from by loop
** **
Please find the attached workbook. on login page use Mudit
Hi,
Try :
For num = 1 To 22
txtbox_val = Me.Controls(TB num).Value
txtbox_num = num
Next num
Regards.
Daniel
De : excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com] De
la part de shariq khan
Envoyé : vendredi 8 juillet 2011 11:00
À :
You have to make a loop through each OleObject Embaded on Worksheet,
See if it helps.
Sub LoopWsCntrl()
Dim OLECont As OLEObject
Dim lRow As Long, lCol As Long
For Each OLECont In Sheet1.OLEObjects
If OLECont.progID = Forms.TextBox.1 Then
Variable =
Hi Daneil,
Thanks but it didnt worked..
Run-time error '-2147024809
Could not find the specified object
Thanks,
Shariq
On Fri, Jul 8, 2011 at 11:12 AM, Daniel dcolarde...@free.fr wrote:
Hi,
** **
Try :
** **
For num = 1 To 22
txtbox_val = Me.Controls(TB
Which line gets the error ?
Daniel
De : excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com] De
la part de shariq khan
Envoyé : vendredi 8 juillet 2011 13:11
À : excel-macros@googlegroups.com
Objet : Re: $$Excel-Macros$$ Need Help Help Help.Putting value in user
from
@googlegroups.com] De
la part de shariq khan
Envoyé : vendredi 8 juillet 2011 13:11
À : excel-macros@googlegroups.com
Objet : Re: $$Excel-Macros$$ Need Help Help Help.Putting value in user
from by loop
Hi Daneil,
Thanks but it didnt worked..
Run-time error '-2147024809
Could
@googlegroups.com]
*De la part de* shariq khan
*Envoyé :* vendredi 8 juillet 2011 13:11
*À :* excel-macros@googlegroups.com
*Objet :* Re: $$Excel-Macros$$ Need Help Help Help.Putting value in
user from by loop
** **
Hi Daneil,
Thanks but it didnt worked
-macros@googlegroups.com]
*De la part de* shariq khan
*Envoyé :* vendredi 8 juillet 2011 18:17
*À :* excel-macros@googlegroups.com
*Objet :* Re: $$Excel-Macros$$ Need Help Help Help.Putting value in
user from by loop
** **
Daneil,
This one txtbox_val = Me.Controls(TB num
Thanks for helping.
On Sun, May 8, 2011 at 6:31 AM, STDEV(i) setiyowati.d...@gmail.com wrote:
Sub ExpandTable()
' by siti Vi / jakarta, 8 may 2011
Dim SrcRng As Range, ResRng As Range, pDate As Date
Dim i As Long, r As Long, u As Integer
Set SrcRng = Cells(1).CurrentRegion
hi
find attached File
On Sat, May 7, 2011 at 11:33 AM, anvesh.gw...@gmail.com
anvesh.gw...@gmail.com wrote:
Hi,
I need help in VBA code.
I have excel sheet on which data is write as below mention
Input
A BC D
1 X1 1.511/11/2008
hi STDV(i)
Your macro only working with 3 Rows.. if he want to add more data in that
table it will not expend all table..
On Sun, May 8, 2011 at 1:40 PM, rajan verma rajanverma1...@gmail.comwrote:
hi
find attached File
On Sat, May 7, 2011 at 11:33 AM, anvesh.gw...@gmail.com
dear Mr. Verma,
et us try both macros with the NEW source table (as New Input) like this
please find attached:
** a workbook containing this data
** a workbook containing both macros
X1 1.7 11/11/2008 01/11/2010
X2 2.4 11/12/2009 01/11/2010
X3 3.8
When copying excel files, the following problems:
PROBLEM 1
1). The settings of the Margins are getting disturbed
PROBLEM 2
Also when you take a print out, the @age of the page fluctuates
Do you or your friends have any solution
Please revert
Thanks regards
On 5/6/11, mayur
try this
(VLOOKUP(MAX(G:G),G:K,5,0)+VLOOKUP(MAX(G:G)-1,G:K,5,0)+VLOOKUP(MAX(G:G)-2,G:K,5,0))/3
On Fri, May 6, 2011 at 5:20 PM, mayur zinknax.zin...@gmail.com wrote:
Hi All,
I need help on get pivot formula for getting average of last three days
score.
Please find attached sheet, is more
Thank you all... Have a great Weekend :)
On Fri, May 6, 2011 at 8:54 AM, rajan verma rajanverma1...@gmail.comwrote:
Find the attached File..
On Fri, May 6, 2011 at 5:20 PM, mayur zinknax.zin...@gmail.com wrote:
Hi All,
I need help on get pivot formula for getting average of last three
Create a Object of Excel in Access...the work with that Object.
On Mon, May 2, 2011 at 5:44 PM, rohit gupta gupta1.ro...@gmail.com wrote:
Dear,
pls let me know how i can create excel macros in MS ACESS 2003.
thanks in advance...
regards,
--
Hi Ashish,
Thanks for replying but it is showing for only 28-April-2011 see what i want
to display the meassage which date has been expired eg.today date is 27
april ,so the message display for less than the today date or system date
for example
Product Date
1001 3-May-2011
1002
Try ths code
Private Sub Workbook_Open()
Dim i, j, k As Long
Dim SWA1, SWA2, SWA3 As String
SWA1 =
SWA2 =
SWA3 =
Sheets(UPS).Activate
For j = 2 To Sheets(UPS).Range(a1).End(xlDown).Row
If Sheets(UPS).Cells(j, 2).Value = DateSerial(Year(Now), Month(Now),
Day(Now)) Then
SWA1 = SWA1 vbNewLine
Thank you very much Ashish Ji,
very sorry for late reply
Redgs
ROHAN
On Thu, Apr 21, 2011 at 4:00 PM, ashish koul koul.ash...@gmail.com wrote:
rohan
try this
=IF(ABS(C3-B3)=0.1,B3,C3)
On Thu, Apr 21, 2011 at 1:49 PM, Rohan Young rohan.j...@gmail.com wrote:
Dear Ashish,
please
Dear rajan,
i need output figure not blank cell
thanks
On Wed, Apr 20, 2011 at 3:46 PM, rajan verma rajanverma1...@gmail.comwrote:
=IF((C3-B3)0.01,C3,
--
--
Some important links for excel users:
1. Follow us on
Dear Ashish,
please sought it out my problem as attached
thanks
Rohan
On Thu, Apr 21, 2011 at 12:02 PM, Rohan Young rohan.j...@gmail.com wrote:
Dear rajan,
i need output figure not blank cell
thanks
On Wed, Apr 20, 2011 at 3:46 PM, rajan verma rajanverma1...@gmail.comwrote:
rohan
try this
=IF(ABS(C3-B3)=0.1,B3,C3)
On Thu, Apr 21, 2011 at 1:49 PM, Rohan Young rohan.j...@gmail.com wrote:
Dear Ashish,
please sought it out my problem as attached
thanks
Rohan
On Thu, Apr 21, 2011 at 12:02 PM, Rohan Young rohan.j...@gmail.comwrote:
Dear rajan,
i need
Hello,
Can you explain G6 ?
Difference is -0.190 which is =0.1.
Regards.
Daniel
De : excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com] De
la part de Rohan Young
Envoyé : mercredi 20 avril 2011 09:35
À : excel-macros@googlegroups.com
Objet : $$Excel-Macros$$ Need Help
Dear Daniel,
i need here Actual wt., the difference output is negative but the condition
is =0.1. what i need? does'nt matter output figure is negative but
condition is =0.1 is fixed* (if difference is 0.1, i only need Invoice wt.
in the rest condition i need Actual wt. after the fixed
Dear Daniel,
i need here Actual wt., the difference output is negative but the condition
is =0.1. what i need? does'nt matter output figure is negative but
condition is =0.1 is fixed* (if difference is 0.1, i only need Invoice wt.
in the rest condition i need Actual wt. after the fixed
First problem:
Read guidelines for posting questions.
DESCRIBE THE PROBLEM!
Your Subject line should give a brief description of the problem.
You should elaborate in the email, and explain what you've tried
and where the error is.
THEN attach a file if it helps.
We have many helpful users here
find the attached workbook
Thanks,
Irfan Khan
On Wed, Apr 13, 2011 at 11:22 AM, syed aliya raza hashim
hashim...@gmail.com wrote:
Plz solve my problem!
--
syed aliya
--
--
Some important links for excel
On Wed, Apr 13, 2011 at 11:22 AM, syed aliya raza hashim
hashim...@gmail.com wrote:
Plz solve my problem!
--
syed aliya
--
--
Some important links for excel users:
1. Follow us on TWITTER for tips tricks
As per my observation this is producing wrong result, please check it once
again.
On Fri, Apr 8, 2011 at 9:34 AM, §»VIPER«§ viper@gmail.com wrote:
hi syed,
find the attached without array.
--
*Thanks Regards
Thamu
*
On Fri, Apr 8, 2011 at 2:45 AM, syed aliya raza hashim
Hi,
Find the attachment.
Thaks,
Kishor
On Fri, Apr 8, 2011 at 2:45 AM, syed aliya raza hashim
hashim...@gmail.comwrote:
Hi,
Hi i have attached my file i want in sheet 2 there are column c in that i
want the name from sheet 1 but there are two condition first is match by ID
then match by
Hi,
In K3 (array formula, validate with Ctrl+Shift+Enter) :
=IF(ISERROR(AVERAGE(IF((MONTH($B$2:$B$125)=MONTH(J3))*(YEAR($B$2:$B$125)=YEA
R(J3))0,$E$2:$E$125))),,AVERAGE(IF((MONTH($B$2:$B$125)=MONTH(J3))*(YEAR(
$B$2:$B$125)=YEAR(J3)),$E$2:$E$125)))
Regards.
Daniel
De :
use averageif() Function instead of Average(if())
Rajan.
On Wed, Apr 6, 2011 at 2:09 PM, syed aliya raza hashim
hashim...@gmail.comwrote:
Hi in this formula if i am incresing the range 25 to 125 then it is
counting blank cell also and traeting blank cell as a jan month so is there
any
Thank you very much!
On Thu, Apr 7, 2011 at 7:32 AM, rajan verma rajanverma1...@gmail.comwrote:
use averageif() Function instead of Average(if())
Rajan.
On Wed, Apr 6, 2011 at 2:09 PM, syed aliya raza hashim
hashim...@gmail.com wrote:
Hi in this formula if i am incresing the range 25
see if it helps
On Fri, Apr 8, 2011 at 2:45 AM, syed aliya raza hashim
hashim...@gmail.comwrote:
Hi,
Hi i have attached my file i want in sheet 2 there are column c in that i
want the name from sheet 1 but there are two condition first is match by ID
then match by Name as well then how can
hi syed,
find the attached without array.
--
*Thanks Regards
Thamu
*
On Fri, Apr 8, 2011 at 2:45 AM, syed aliya raza hashim
hashim...@gmail.comwrote:
Hi,
Hi i have attached my file i want in sheet 2 there are column c in that i
want the name from sheet 1 but there are two condition first
Hi Daniel,
Thank you so much for helping me out with this.
Appreciate ur help bro
Thanks n Regards
Anupam
On Fri, Mar 25, 2011 at 1:55 AM, Daniel dcolarde...@free.fr wrote:
Hi,
Have a look at the attached file.
Regards.
Daniel
*De :* excel-macros@googlegroups.com
use concatenate function or operator like
=A1 B1 C1
etc
On Tue, Mar 8, 2011 at 3:02 PM, sudhir kumar bluecore...@gmail.com wrote:
Hi,
Can u send Excel Sheet of this example.
thanx
On 7 March 2011 12:17, Krish kandy.kr...@gmail.com wrote:
Hi ,
I have data in row and column
use this code in sheet 1
Private Sub Worksheet_BeforeDoubleClick(ByVal Target As Range, Cancel As
Boolean)
If Target.Column = 1 And Target.Row = 3 Then
Sheets(2).Activate
Sheets(2).Cells(2, 1).Select
End If
End Sub
On Mon, Feb 14, 2011 at 12:48 PM, rashid memon mr.rashidme...@gmail.comwrote:
That was Excel limitation: max number of criteria (unique values
list)on Auto Filter = 1000
On 2/13/11, Aamir Shahzad aamirshahza...@gmail.com wrote:
sheet attached, simply when you want to use auto filter you must select all
your data till at the end.
Regards,
Aamir Shahzad
On Wed, Feb
your needs...
Paul
--
*From:* Prathima R prathima@gmail.com
*To:* excel-macros@googlegroups.com
*Sent:* Thu, February 10, 2011 9:11:41 AM
*Subject:* Re: $$Excel-Macros$$ Need Help
please advice in this concern as i am having around 20-30 workbooks where
Function
'
From: Prathima R prathima@gmail.com
To: excel-macros@googlegroups.com
Sent: Fri, February 11, 2011 7:49:00 AM
Subject: Re: $$Excel-Macros$$ Need Help
Paul
Are you wanting to count the sheets
or count the records/rows on all sheets?
Sheets.Count
gets you the number of sheets.
For Sht = 1 to sheets.count
total = total
+ application.worksheetfunction.counta(sheets(sht).range(A1:A65000))
next Sht
would loop through all sheets and count the
Thanks for the response.
Here am trying to count the number of non-blanks in multiple sheets
On Thu, Feb 10, 2011 at 6:32 PM, Paul Schreiner schreiner_p...@att.netwrote:
Are you wanting to count the sheets
or count the records/rows on all sheets?
Sheets.Count
gets you the number of
please advice in this concern as i am having around 20-30 workbooks where in
need to count the number of Non-blanks in multilple sheets.
Thanks,
Prathima
On Thu, Feb 10, 2011 at 7:23 PM, Prathima R prathima@gmail.com wrote:
Thanks for the response.
Here am trying to count the number of
.
I can give that to you and then you can customize it to fit your needs...
Paul
From: Prathima R prathima@gmail.com
To: excel-macros@googlegroups.com
Sent: Thu, February 10, 2011 9:11:41 AM
Subject: Re: $$Excel-Macros$$ Need Help
please advice
Try This..
Sub GetNonBlank()
For i = 1 To ActiveWorkbook.Sheets.Count
t = t + WorksheetFunction.CountA(Sheets(i).UsedRange)
Next
MsgBox t
End Sub
On Thu, Feb 10, 2011 at 6:11 AM, Prathima R prathima@gmail.com wrote:
please advice in this concern as i am having around 20-30 workbooks where
Hi
Se att, u can do with pivot table.
Rgds
Enjoy excelling...
On Mon, Jan 17, 2011 at 7:04 PM, Priya Jose questpr...@gmail.com wrote:
Dear Team,
Please find attach file in which i have explained my requirement and
request of your kindness to provide me the solution, *as i have more
check the attachment se eif it helps
On Mon, Jan 17, 2011 at 7:04 PM, Priya Jose questpr...@gmail.com wrote:
Dear Team,
Please find attach file in which i have explained my requirement and
request of your kindness to provide me the solution, *as i have more than
4000 records of such
can you attach the sample sheet
On Fri, Jan 7, 2011 at 8:40 PM, Erick C boricua2...@gmail.com wrote:
Hello everybody,
I am in desperate need of some assistance, and I am hoping someone may
be able to give me a hand. I am still a bit of a novice when it comes
to vba code writing, so I am
Align-left and Align-Right is irrelevent (I think)
because alignment is a paragraph property, not a string property.
What you're saying is that you need the string padded
with spaces either on the left or right...
So, by example, if you were padding with underscores (_),
then the results you're
Paul -
Thank you, this is exactly what I was looking for!
On Jan 7, 11:37 am, Paul Schreiner schreiner_p...@att.net wrote:
Align-left and Align-Right is irrelevent (I think)
because alignment is a paragraph property, not a string property.
What you're saying is that you need the string
Dear You can compare two files with if formula
just copy one file in second file and use =IF(columne one = columne
two,ture,false)
hope you can easily find errors
thanks
Date: Thu, 23 Dec 2010 01:31:23 -0800
Subject: $$Excel-Macros$$ Need Help URGENTLY - zip file
From:
@googlegroups.com
Subject: RE: $$Excel-Macros$$ Need Help URGENTLY - zip file
Dear You can compare two files with if formula
just copy one file in second file and use =IF(columne one = columne
two,ture,false)
hope you can easily find errors
thanks
Date: Thu, 23 Dec 2010 01:31:23 -0800
Subject
check this link see if it helps
http://www.ehow.com/how_5976974_insert-flash-movie-outlook-signature.html
On Tue, Dec 14, 2010 at 10:44 AM, renuka chari jva.ch...@gmail.com wrote:
hi experts good morning
i need help for insert flash(.swf) signature file into outlook
signature
how it
try this
INDEX($B$1:$W$1,0,MATCH(Collected,B2:W2,0))
On Tue, Dec 14, 2010 at 11:28 AM, lucky singh lucky60...@gmail.com wrote:
Hi All,
kindly help me to get the collaction date with the help of an formula...
I want to know the date of collection of each customer...
please refer the
No attachment found.
On Fri, Dec 10, 2010 at 3:16 PM, lucky singh lucky60...@gmail.com wrote:
Hi All,
kindly help me to get the collaction date with the help of an formula...
please refer the attachment...
Regards,
Lucky
--
Hi Sharath,
Please check the attached file which has the resolution as per your
requirements. :)
Best Regards,
DILIPandey
On Wed, Dec 8, 2010 at 7:38 PM, Sharath Sambrani
sharath.c.sambr...@gmail.com wrote:
Hi,
I have two columns A and B.
column A contains list of tasks and column B
: $$Excel-Macros$$ Need help on Excel Dynamic List
To: excel-macros@googlegroups.com
Cc: sharath.c.sambr...@gmail.com
Hi Sharath,
Please check the attached file which has the resolution as per your
requirements. :)
Best Regards,
DILIPandey
On Wed, Dec 8, 2010 at 7:38 PM, Sharath Sambrani
Hi,
Please find the attached solution. In sheet one I have two validation
lists, which is taking data from Sheet2. Sheet2 has named ranges.
Hope this will help you. With the help of Named Range and Indirect formula
you can do this very easily.
Regards,
Deepak Rai
On Wed, Dec 8, 2010 at 7:33
: Manjunath C cmanjunathchen...@gmail.com
Subject: Re: $$Excel-Macros$$ Need help on excel sheet
To: excel-macros@googlegroups.com
Date: Wednesday, December 1, 2010, 12:15 AM
No,
I have different data (place wise) in 5 tabs, my expectation is that wile
pasting the raw data in the first sheet
Hello,
Do you mean that you want to collect the data on all 5 sheets and add it to a
6th sheet and then save the workbook with all 6 sheets?
Or do you need to take the data from the 5 sheets and put it on one sheet, then
saving a new workbook with only one sheet?
--- On Tue, 11/30/10,
Hello,
With Application.CommandBars(1)
.Controls(.Controls.Count).Delete
End With
Regards.
Daniel
-Message d'origine-
De : excel-macros@googlegroups.com [mailto:excel-mac...@googlegroups.com] De
la part de Sayyad1284
Envoyé : lundi 22 novembre 2010 05:44
À : MS EXCEL AND VBA MACROS
Hey Daniel,
Thank you very much
On Nov 22, 8:24 pm, Daniel dcolarde...@free.fr wrote:
Hello,
With Application.CommandBars(1)
.Controls(.Controls.Count).Delete
End With
Regards.
Daniel
-Message d'origine-
De : excel-macros@googlegroups.com
Hi,
You can use Data Validation for this. Search Google or Excel Help you will
get to know about this.
Regards,
Deepak
On Sun, Sep 26, 2010 at 8:49 PM, Idhrees Mohamed idhrees...@gmail.comwrote:
Dear Team,
I need help with attached file. In this one column Relay type, we select
any one
Dear Mohammed Idhrees,
Please find attach, i hope this is your requirement, i have done only for
the 2 rows which are colored in yellow, if you wish you can copy paste and
tak the values from the list.
If this is not your requirement you can revert to the group for more help.
Regards
Ahmed
Hi Friend,
You can download Excel addins from www.diddb.com,www.vertex42.com,
www.ozgrid.com,www.add-ins.com,www.ablebits.com,www.office-eccel.com etc.
For creating excel add-ins you have to be proficient in VBA Coding,writing
Macros and also you require knowledge of some excel events and
Hi Vinod,
Thank you very much,
Vinod can you give me vba code for that issue
Regards
Vilas
On Sat, Aug 28, 2010 at 9:11 PM, VILAS CHAVAN vilaschav...@gmail.com wrote:
Hi vinod,
You are not sending me any attachment please send solve attachment please
regards
Vilas
On Sat, Aug
Hi Vilas,
Please find below the macro recorded by me...
Sub Date_Format()
'
' Date_Format Macro
' Macro to convert date format- 8/29/2010 by Vinod
'
Columns(A:A).Select
With Selection
Selection.TextToColumns Destination:=Range(A1), DataType:=xlDelimited,
_
Oops Missed to attach the file... Now done...
On Sun, Aug 29, 2010 at 12:56 AM, Vinod N nvino...@gmail.com wrote:
Hi Vilas,
Please select column A and use Text-to-Columns under Data menu... Next
choose the desired date format from Format-- Cells option.. Solved copy of
your sample file
Hi vinod,
You are not sending me any attachment please send solve attachment please
regards
Vilas
On Sat, Aug 28, 2010 at 12:26 PM, Vinod N nvino...@gmail.com wrote:
Hi Vilas,
Please select column A and use Text-to-Columns under Data menu... Next
choose the desired date format from
In my opinion, data lost.
On Fri, Aug 27, 2010 at 6:54 AM, Idhrees Mohamed idhrees...@gmail.comwrote:
Dear guys,
I have a excel sheet with big data. Its contain one date column
unfortunately I delete and save it. It’s possible to recover that
column.
Thanks in Advance.
Regards,
Hi,
Do you back-up regularly? If so, it may be in your back-up files. If not, then
it is lost lost. Sorry.
Regards - Dave.
Date: Fri, 27 Aug 2010 05:24:43 +0400
Subject: $$Excel-Macros$$ Need help deleted column in excell sheet
From: idhrees...@gmail.com
To: excel-macros@googlegroups.com
Date: Sun, 22 Aug 2010 15:10:50
To: excel-macros@googlegroups.comexcel-macros@googlegroups.com
Reply-To: excel-macros@googlegroups.com
Subject: RE: $$Excel-Macros$$ Need Help in Cross tab
Hi,
I have re-done your sheet using VBA.
It will accommodate as many rows as needed on the report sheet
You're welcome.
Regards - Dave.
To: excel-macros@googlegroups.com
Subject: Re: $$Excel-Macros$$ Need Help in Cross tab
From: shariqcoo...@gmail.com
Date: Sun, 22 Aug 2010 07:15:09 +
Thanks Dave
Thanks for your help.I have not checked the sheet coz I'm not on my laptop
but I
Thanks Andy. You're welcome.
Regards - Dave.
Date: Sat, 21 Aug 2010 15:33:03 +0530
Subject: Re: $$Excel-Macros$$ Need Help in Cross tab
From: aind...@gmail.com
To: excel-macros@googlegroups.com
Hey Dave,
This is great!! you never stop amazing me with your simple solutions to complex
Reply-To: excel-macros@googlegroups.com
Subject: RE: $$Excel-Macros$$ Need Help in Cross tab
Hi Shariq
I've done this with worksheet functions, not VBA.
The original formula is in B3 on the Report sheet. It's then just copied down,
then copied across.
If you really need it in VBA, it can be done
davebonall...@hotmail.com
Sender: excel-macros@googlegroups.com
Date: Sat, 21 Aug 2010 18:16:12
To: excel-macros@googlegroups.comexcel-macros@googlegroups.com
Reply-To: excel-macros@googlegroups.com
Subject: RE: $$Excel-Macros$$ Need Help in Cross tab
Thanks Andy. You're welcome.
Regards - Dave
Much appreciated! I am upgrading next week!
From: excel-macros@googlegroups.com
[mailto:excel-mac...@googlegroups.com] On Behalf Of Dave Bonallack
Sent: Friday, August 20, 2010 9:04 AM
To: excel-macros@googlegroups.com
Subject: RE: $$Excel-Macros$$ Need help
As dave said, there is a formula in column
Click on the formula.
Carefully copy the formula except '=' symbol
type the following in the same cell.
=iserror(FORMULA, 0, FORMULA)
Replace the FORMULA with the copied formula
Regards,
Kishan Reddy, K
On Aug 19, 9:27 am, Dave Bonallack
-macros@googlegroups.com
Subject: RE: $$Excel-Macros$$ Need help with a formula
Hi Becky,
If XL has put NA in a cell, you must already have a formula there.
You'll need to send a sample workbook so we can see get the whole
picture.
Regards - Dave.
Date: Wed, 18 Aug 2010 12:15:30 -0700
Subject
-Macros$$ Need help with a formula
Hi Becky,
If XL has put NA in a cell, you must already have a formula there.
You'll need to send a sample workbook so we can see get the whole
picture.
Regards - Dave.
Date: Wed, 18 Aug 2010 12:15:30 -0700
Subject: $$Excel-Macros$$ Need help with a formula
Thanks, Michael!
-Original Message-
From: excel-macros@googlegroups.com [mailto:excel-mac...@googlegroups.com] On
Behalf Of Michael Hayes
Sent: Thursday, August 19, 2010 2:37 PM
To: MS EXCEL AND VBA MACROS
Subject: Re: $$Excel-Macros$$ Need help with a formula
Beckie or is it Becky
Hi Becky,
If XL has put NA in a cell, you must already have a formula there. You'll need
to send a sample workbook so we can see get the whole picture.
Regards - Dave.
Date: Wed, 18 Aug 2010 12:15:30 -0700
Subject: $$Excel-Macros$$ Need help with a formula
From: rebecca.math...@kraft.com
Hi I have responded to your email
sent before pl chk and see if this is what u wanted
Regards,
Andy
On Thu, Aug 5, 2010 at 9:48 AM, prabhakar thakur prabhakarthak...@gmail.com
wrote:
Hi All,
Please help.
Thanks,
Prabhakar Thakur
New Delhi
+919953736776
On Wed, Aug 4,
Do u want the data in ms-word as a paragraph ?
On 7/28/10, madha...@yahoo.com madha...@yahoo.com wrote:
Dear expert
I have some data stored in excel sheet and I wanted to convert the same in
paragraph form can I know how can I convert the same in paragraph form.
Warm regards
Madhav Vyas
501 - 600 of 656 matches
Mail list logo