@googlegroups.com
*Subject: *Re: $$Excel-Macros$$ Help to create summary table count unique
Dear ChilExcel,
For Unique Count...
Use below function..with Ctrl+shift+Enter..
*=SUM(1/COUNTIF(I1:I28,I1:I28))*
--
Thanks regards,
Noorain Ansari
*http://noorain-ansari.blogspot.com/*http
Try :
Sub FromTable1()
Dim Rg As Range, Tabl, lgRow As Long
Set Rg = Range([B6], Cells(6, 2).End(xlDown)).Resize(, 5)
Tabl = Rg
lgRow = 5
For i = 1 To UBound(Tabl)
lgRow = lgRow + 1
Cells(lgRow, 10).Resize(3) = Tabl(i, 1)
Cells(lgRow, 11).Resize(3) = Tabl(i, 2)
Thanks Daniel for your kind and prompt help.
But unfortunately I am not familiar to using Macros. Can you please
guide me in using this Macro.
Thanks again.
Regards,
Bhargava Raju
On Aug 22, 4:16 pm, Daniel dcolarde...@free.fr wrote:
Try :
Sub FromTable1()
Dim Rg As Range, Tabl, lgRow As
A simple vlookup formula such as this to lookup the item in the IS sheet when
you know the column should do it. You can then use edit/replace to change the
formulas. A one click macro could do it all.
=VLOOKUP(J9,'2011 Actual'!B2:AG331,10,0)
From: Steve Weaver
Sent: Friday, August
very good help!! . thank you very much to all
excellent
2011/8/19 dguillett1 dguille...@gmail.com
I would put the table to create to the side and retain the top row of
formulas and just fire this. See attached
Sub DoPercentageTableNextToTable1()
Dim slr As Long
slr =
Please attached Your Word document:
From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com]
On Behalf Of rengaraj mohan
Sent: Thursday, August 18, 2011 11:54 AM
To: excel-macros@googlegroups.com
Subject: $$Excel-Macros$$ Help for to get the detail from the word document
This Procedure Should be Like This :
Sub InsertRow()
For x = 1 To Range(A65536).End(xlUp).Row * 2
If Range(A Trim(Str(x))).Value And Range(A
Trim(Str(x))).Offset(1, 0).Value Then
Application.StatusBar = Inserting Rows on Row : Trim(Str(x + 1))
Range(A Trim(Str(x +
This Procedure Should be Like This :
Sub InsertRow()
For x = 1 To Range(A65536).End(xlUp).Row * 2
If Range(A Trim(Str(x))).Value And Range(A
Trim(Str(x))).Offset(1, 0).Value Then
Application.StatusBar = Inserting Rows on Row : Trim(Str(x + 1))
Range(A Trim(Str(x +
See if it helps , but Scop of this macro is only only Worksheet.
Sub matchValue()
' Short CUt Key Shift + CTRL + M
Application.ScreenUpdating = False
Dim F_range As Range
Dim S_range As Range
On Error Resume Next
Set F_range = Application.InputBox(Please Select 1st Range, , , , , , ,
Thank you raj for your help
On Sun, Aug 7, 2011 at 8:04 PM, Rajan_Verma rajanverma1...@gmail.comwrote:
*See this Function :*
* *
*if sum of any Two cell in selected Range is Equal to Given Value in
Second Parameter of Function then Function will Return the Address of that
Two Cells,
You need to post examples, etc.
From: Rajendra prasad yadav
Sent: Monday, August 08, 2011 1:31 PM
To: excel-macros@googlegroups.com
Subject: $$Excel-Macros$$ Help needed. compare two wxcel files
Hi friends,
I am not good at excel. I have a requirement now, Can some one please give the
macro
[mailto:excel-macros@googlegroups.com]
On Behalf Of Venkat CV
Sent: Friday, August 05, 2011 5:05 PM
To: excel-macros@googlegroups.com
Cc: ashlyprad...@gmail.com
Subject: Re: $$Excel-Macros$$ Help with =now()
Hi Ashish,
Yes you can Just Type in Custom As on mmm you will get output
Hello Venkat
Amazing :-)
Wonder why I couldn't think of it earlier :-)
Is the second part possible. For eg. In the same cell, I want the cell
to display as As on August 2011 (Where August 2011 will be obtained
using the now() formula as described earlier and as you have suggested..
Thanks
*Hi Ashish,*
*
*
*Yes you can Just Type in Custom As on mmm you will get output as
a As on August 2011*
*
*
*Best Regards,*
*Venkat *
*Chennai*
*
*
On Fri, Aug 5, 2011 at 4:53 PM, Ashish Pradhan ashlyprad...@gmail.comwrote:
Hello Venkat
Amazing :-)
Wonder why I couldn't think of it
Use this Format :
-
From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com]
On Behalf Of Venkat CV
Sent: Friday, August 05, 2011 5:05 PM
To: excel-macros@googlegroups.com
Cc: ashlyprad...@gmail.com
Subject: Re: $$Excel-Macros$$ Help with =now()
Hi Ashish
-macros@googlegroups.com
*Cc:* ashlyprad...@gmail.com
*Subject:* Re: $$Excel-Macros$$ Help with =now()
*Hi Ashish,*
*Yes you can Just Type in Custom As on mmm you will get output
as a As on August 2011*
*Best Regards,*
*Venkat *
*Chennai*
On Fri, Aug 5, 2011 at 4:53 PM, Ashish Pradhan
Hi kaushik,
I think copy and paste is the best option for this
Regards
Rajan
-Original Message-
From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com]
On Behalf Of KAUSHIK SAVLA
Sent: Wednesday, August 03, 2011 4:47 PM
To: excel-macros@googlegroups.com
Subject:
Hi Kaushik,
We can Copy Paste Else Link the Cells as Required data by using data
linking...workbook 1 to Workbook 2
*Best Regards,*
*Venkat *
*Chennai*
On Wed, Aug 3, 2011 at 4:47 PM, KAUSHIK SAVLA savla.kaus...@gmail.comwrote:
Hi All,
How to import only selected data from another workbook?
if your data format doesn´t change i recomend using links, i use links for a
database which doesn´t change the format, but i have another database i have
to add new data every month which is always changing values and cells, for
that i use a copy paste macro which copies all the data by selecting
Use paste special with paste link..
On Wed, Aug 3, 2011 at 4:47 PM, KAUSHIK SAVLA savla.kaus...@gmail.com wrote:
Hi All,
How to import only selected data from another workbook?
Please help.
Regards,
Kaushik
--
Sent from Gmail for mobile | mobile.google.com
Kaushik Savla
--
Query on paste link - Should i select each worksheet of workbook and
do the paste special value paste link? If so then is there any
shortcut to link whole workbook to another workvook.
Regards,
Kaushik
On 8/4/11, XLS S xlst...@gmail.com wrote:
Use paste special with paste link..
On
Hi Kaushik
You Have to Select Entire Page on Copying time as well Paste special and use
As told Mr XLS S Steps
*Best Regards,*
*Venkat *
*Chennai*
On Thu, Aug 4, 2011 at 5:53 AM, KAUSHIK SAVLA savla.kaus...@gmail.comwrote:
Query on paste link - Should i select each worksheet of workbook
Hey Kaushik,
can you attach the worksheet
and also..easy way to make link file..just create
workbook shortcut and use
On Thu, Aug 4, 2011 at 5:53 AM, KAUSHIK SAVLA savla.kaus...@gmail.com wrote:
Query on paste link - Should i select each worksheet of workbook
Sub
-- Forwarded message --
From: Daniel dcolarde...@free.fr
Date: Sun, Jul 31, 2011 at 12:53 AM
Subject: RE: $$Excel-Macros$$ Help needed to comine VBA modules
To: excel-macros@googlegroups.com
I am sorry, I don’t know how to do it. Maybe it is possible to achieve
Hey Thanks people.. never knew that the Refresh All option eixsted
!..appreciate the help.
Regards,
Ruchi
On Tue, Jul 26, 2011 at 8:13 AM, NOORAIN ANSARI noorain.ans...@gmail.comwrote:
Sub allpivotsofworkbook()
activeworkbook.Refreshall
end sub
On Mon, Jul 25, 2011 at 11:55 PM, XLS S
at 1:57 PM
Subject: RE: $$Excel-Macros$$ Help needed to comine VBA modules
To: excel-macros@googlegroups.com
It will be very difficult to move the code to the personal.xlsb workbook
without the initial file retaining some code. Can you explain why you want
to do so ? Maybe there should
[mailto:excel-macros@googlegroups.com]
On Behalf Of Daniel
Sent: Saturday, July 30, 2011 6:12 PM
To: excel-macros@googlegroups.com
Subject: RE: $$Excel-Macros$$ Help needed to comine VBA modules
Here is my test file.
-Message d'origine-
De : excel-macros@googlegroups.com [mailto:excel
HI,
Can you explain a bit more ?
Thanks.
Daniel
De : excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com] De
la part de aju chacko
Envoyé : vendredi 29 juillet 2011 00:37
À : excel-macros@googlegroups.com
Objet : Re: $$Excel-Macros$$ Help needed to comine VBA
Download the Excel Function Dictionary
http://www.xlfdic.com/
From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com]
On Behalf Of XLS S
Sent: Friday, July 29, 2011 10:38 PM
To: excel-macros@googlegroups.com
Subject: Re: $$Excel-Macros$$ Help
Hey Vijay,
Please
Hi,
You should indicate the file name before the function :
Eg. Personal.xlsb! SpellNumber...
Regards.
Daniel
-Message d'origine-
De : excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com] De
la part de aju chacko
Envoyé : jeudi 28 juillet 2011 06:10
À :
Please update...
Subhash Yadav
On Mon, Jul 25, 2011 at 7:00 PM, Subhash Yadav scy2...@gmail.com wrote:
Dear friends
I require some help regarding Vlookup function conunction with Combo Box.
I want vlookup in the combobox with respect to selected value in another
combo box. Also want to
I tested it with dates that exist but still got the same error
message.
You can try it.
Tom
On Jul 26, 3:42 pm, Rajan_Verma rajanverma1...@gmail.com wrote:
If error is coming it means yourdatenot found in that sheet..
' On the Top on Module
On Error Goto Err:
'Before End sub Statement
Err:
Hi,
=LEN(A1)-LEN(SUBSTITUTE(A1, ,))
Regards.
Daniel
De : excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com] De
la part de KAUSHIK SAVLA
Envoyé : mardi 26 juillet 2011 06:07
À : excel-macros@googlegroups.com
Objet : $$Excel-Macros$$ Help Required (Excel Function or
Thanks all.
Formula works but counts one less, so i am adding one manually.
Regards,
Kaushik
Dear Vijay,
Please clear the q4 and q5..
please find the solution.
On Tue, Jul 26, 2011 at 6:17 PM, vijayajith VA vijayajith...@gmail.comwrote:
Hi,
I have two excel questions.can you help me to solve those questions?
Thank you
--
Put this in B Column
=TEXT(DATE(LEFT(A4,4),MID(A4,FIND(.,A4,1)-2,2),MID(A4,FIND(.,A4,1)-2,2))
,mm/dd/yy)
From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com]
On Behalf Of vijayajith VA
Sent: Tuesday, July 26, 2011 6:17 PM
To: excel-macros@googlegroups.com
Subject:
Hello Vijay,
See the attached.
HTH
Haseeb
For tips visit;
http://www.excelfox.com/forum/forum.php
--
--
Some important links for excel users:
1. Follow us on TWITTER for tips tricks and links :
Doing that, it doesn´t return the error anymore, but the macro still doesn´t
copy the information :s, is it any complication with excel 2010?
2011/7/22 Rajan_Verma rajanverma1...@gmail.com
*Set Wb=ActiveWorkbook*
* *
*From:* excel-macros@googlegroups.com [mailto:
Easy way if you are using excel 2007,2010 then
just press ctrl+alt+F5
On Sat, Jul 23, 2011 at 10:36 PM, Ruchi B ruchi.ben...@gmail.com wrote:
All,
Have a excel workbook with around 15 tabs ..each of tab has multiple
pivots referring to different sets of data. All the pivots refer to 4
data
Sub allpivotsofworkbook()
activeworkbook.Refreshall
end sub
On Mon, Jul 25, 2011 at 11:55 PM, XLS S xlst...@gmail.com wrote:
Easy way if you are using excel 2007,2010 then
just press ctrl+alt+F5
On Sat, Jul 23, 2011 at 10:36 PM, Ruchi B ruchi.ben...@gmail.com wrote:
All,
Have a excel
Hi,
Use this formula
=LEN(A1)-LEN(SUBSTITUTE(A1, ,))
where A1 contains 9 7 5 6
On Tue, Jul 26, 2011 at 9:36 AM, KAUSHIK SAVLA savla.kaus...@gmail.comwrote:
Hi All,
I want to count the number of spaces in a cell:-
Eg In Cell A1 data is 9 7 5 6 I want function which returns answer as 4
Try this
=LEN(B1)-LEN(SUBSTITUTE(B1, ,))
From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com]
On Behalf Of KAUSHIK SAVLA
Sent: Tuesday, July 26, 2011 9:37 AM
To: excel-macros@googlegroups.com
Subject: $$Excel-Macros$$ Help Required (Excel Function or VBA Code)
Hi
Try using Cdate(Mydate) in Find
On Tue, Jul 26, 2011 at 9:44 AM, Tom tcli...@gmail.com wrote:
I want the macro below to accept any date that I enter in its input
box, e.g. 17/06/2011, and go and find it in the active worksheet. I
got an error message saying, Object variable or With block
Dear Kaushik,
In Excel
Try it
*=LEN(SUBSTITUTE(B2, ,))*
in VBA...
Try it.
*Function cell_length(s as range)*
*cell_length=application.worksheetfunction.*
*Function cell_length(s As Range)
cell_length = Len(Application.WorksheetFunction.Substitute(s, , ))
End
If error is coming it means your date not found in that sheet..
' On the Top on Module
On Error Goto Err:
'Before End sub Statement
Err:
If err.number0 then
Msgbox Date Not Found,vbinformation
endif
-Original Message-
From: excel-macros@googlegroups.com
See if it Helps
Sub UpdateAll()
Dim sh As Worksheet
Dim pt As PivotTable
For each sh in ActiveWorkbook.sheets
For Each pt In sh.PivotTables
pt.PivotCache.Refresh
Next
next
End Sub
-Original Message-
From: excel-macros@googlegroups.com
do you want to change the source data or just refresh
change calculations to automatic and then click on refresh all
On Sat, Jul 23, 2011 at 10:36 PM, Ruchi B ruchi.ben...@gmail.com wrote:
All,
Have a excel workbook with around 15 tabs ..each of tab has multiple
pivots referring to
Hi,
Is this possible using formula ?
On Thu, Jul 21, 2011 at 7:38 PM, Anish Shrivastava anish@gmail.comwrote:
Hi Vijay,
See the attached file. let me know if it works fine.
On Thu, Jul 21, 2011 at 7:26 PM, vijayajith VA vijayajith...@gmail.comwrote:
Hi,
I have names, order no and
Set Wb=ActiveWorkbook
From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com]
On Behalf Of Jorge Marques
Sent: Thursday, July 21, 2011 10:44 PM
To: excel-macros@googlegroups.com
Subject: $$Excel-Macros$$ Help Macro doesn´t work anymore, keeps giving same
error
Hi guys, i
Vijay,
Though you have provided the sample sheet your requirement is not clear.
What do you mean by merge the names in one sheet. do you want to consolidate
the data or you want a concatenation.
On Thu, Jul 21, 2011 at 5:33 PM, vijayajith VA vijayajith...@gmail.comwrote:
fyi
On Wed, Jul
Hi,
I have names, order no and county names in two sheets.. need to consolidate
in one sheet..
Thanks
On Thu, Jul 21, 2011 at 7:04 PM, Anish Shrivastava anish@gmail.comwrote:
Vijay,
Though you have provided the sample sheet your requirement is not clear.
What do you mean by merge the
Please check if the sheet name is Pivot.
if not then rename it to Pivot.
On Thu, Jul 21, 2011 at 10:44 PM, Jorge Marques leote.w...@gmail.comwrote:
Hi guys, i have this macro i use to copy a range from column D of a
worksheet of a workbook to column G of another workbook and worksheet, but
it
Yes, the names are all ok, i double checked it, even try to change names,
but doesn´t work :S
2011/7/21 Anish Shrivastava anish@gmail.com
Please check if the sheet name is Pivot.
if not then rename it to Pivot.
On Thu, Jul 21, 2011 at 10:44 PM, Jorge Marques leote.w...@gmail.comwrote:
is it possible to attach the sheet? You can remove the data from it or
replace the values..
On Thu, Jul 21, 2011 at 11:04 PM, Jorge Marques leote.w...@gmail.comwrote:
Yes, the names are all ok, i double checked it, even try to change names,
but doesn´t work :S
2011/7/21 Anish Shrivastava
add this line before if condition see if it helps
wb.Sheets(Pivot).select
On Thu, Jul 21, 2011 at 11:56 PM, Anish Shrivastava anish@gmail.comwrote:
is it possible to attach the sheet? You can remove the data from it or
replace the values..
On Thu, Jul 21, 2011 at 11:04 PM, Jorge
Dear Vijay,
Please provide sample sheet
On Wed, Jul 20, 2011 at 5:49 PM, vijayajith VA vijayajith...@gmail.comwrote:
Hi,
1;
I have several names in two sheets..i need to merge it in one sheet...is
this possible using formula..
Thanks
--
There is incompatibility in the way both versions are handling pivots. If
you are to design pivots with Excel 2007 for Excel 2003 users, you should
run Excel 2007 in compatibility mode.
Regards.
Daniel
De : excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com] De
la part de
Dear Noorain,
Really helpful solution. thanks a lot.
one question to you, is there any process to select two groups at a time?
cause I have a large database 15 customer groups from where I have to select
only Distributor Super Stokist only.
please reply
Thanks in advance
Kalyan
On Mon, Jul
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.
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
[mailto:excel-macros@googlegroups.com]
On Behalf Of Jorge Marques
Sent: Wednesday, July 13, 2011 4:05 PM
To: excel-macros@googlegroups.com
Subject: Re: $$Excel-Macros$$ HELP urgent
Hi friend, i don´t understand exactly what you want, but if you want to
highlight the entire row that has the negative
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
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
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,
Can you mail the sheet password back ?
De : excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com] De
la part de Bob
Envoyé : dimanche 10 juillet 2011 20:57
À : excel-macros@googlegroups.com
Objet : Re: RE: $$Excel-Macros$$ Help with formula
Here is the file. On the Quote
oops sorry, 291log
--
--
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 @
Please attached Some Data with More Specification..
From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com]
On Behalf Of Bob
Sent: Sunday, July 10, 2011 6:28 PM
To: excel-macros@googlegroups.com
Subject: $$Excel-Macros$$ Help with formula
*hi LK modi
use this simpler formula
=LOOKUP(2,1/(A1:A10=A2),B1:B10)
file is attached
*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 Fri, Jul 8, 2011 at 10:56 AM, harsh shah harshsha...@gmail.com wrote:
HOPE
See if it help,
Use this in L2
=OFFSET(INDEX(F:F,MATCH(K2,F:F,0),1),COUNTIF(F:F,K2)-1,-4,1,1)
From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com]
On Behalf Of ashish koul
Sent: Friday, July 08, 2011 11:06 AM
To: excel-macros@googlegroups.com
Subject: Re: $$Excel
Thanks a lot Ashish its working perfectly
Regards,
Rakesh.
On Fri, Jul 8, 2011 at 10:54 AM, ashish koul koul.ash...@gmail.com wrote:
add this code to new workbook and run the macro and choose the csv file
Option Compare Text
Sub swa()
Application.ScreenUpdating = False
Use this in D4
=DATE(YEAR(C4),MONTH(C4)+1,5)
From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com]
On Behalf Of L.K. Modi
Sent: Thursday, July 07, 2011 10:26 AM
To: excel-macros@googlegroups.com
Subject: $$Excel-Macros$$ help regarding date formula
Dear Members,
*
hi L K modi use this formula in d4
=EOMONTH(C4,0)+5
*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 Thu, Jul 7, 2011 at 11:29 AM, Rajan_Verma rajanverma1...@gmail.comwrote:
*Use this in D4*
THANKS A LOT MY PROBLEM IS SOLVED NOW BY THESE VALUABLE MEMBERS
REGARDS
LKMODI
On Thu, Jul 7, 2011 at 10:25 AM, L.K. Modi ca.mod...@gmail.com wrote:
Dear Members,
Me attaching a sheet which relates to Excise duty payment.The result should
be 5 of the next of the month of Invoice.We are
*ok sir
*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 Thu, Jul 7, 2011 at 11:44 AM, L.K. Modi ca.mod...@gmail.com wrote:
THANKS A LOT MY PROBLEM IS SOLVED NOW BY THESE VALUABLE MEMBERS
REGARDS
LKMODI
On Thu,
chart only represent the data of visible cells if you hide any rows or
will apply filter it will show the data of visible cells only
check the attachment choose any name u will see the chart will automatically
change
if it is not working as per the default setting .
*hi atul
dynamic chart preparation can help
have a look link below
http://chandoo.org/wp/2009/02/12/make-a-dynamic-chart-using-data-filters/
*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 Thu, Jul 7, 2011 at 12:11
See if it help
-Original Message-
From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com]
On Behalf Of Atul Kesaria
Sent: Thursday, July 07, 2011 12:11 PM
To: excel-macros
Cc: atul.kesaria
Subject: $$Excel-Macros$$ Help on Chart
Hello Team,
I am preparing chart
Hi,
u use this
=DATE(YEAR(C4),MONTH(C4)+1,5)and drag the fill handle down till c4 is not
blank.
u will get what u want.
R.Karunanithi.
--- On Thu, 7/7/11, L.K. Modi ca.mod...@gmail.com wrote:
From: L.K. Modi ca.mod...@gmail.com
Subject: $$Excel-Macros$$ help regarding date formula
To:
hi,
the betterr is
=DATE(YEAR(C4),MONTH(C4)+1,5)
because he wants 'next month' 5th.
R.Karunanithi
--- On Thu, 7/7/11, ashish koul koul.ash...@gmail.com wrote:
From: ashish koul koul.ash...@gmail.com
Subject: Re: $$Excel-Macros$$ help regarding date formula
To: excel-macros@googlegroups.com
: Thursday, July 07, 2011 1:18 PM
To: excel-macros@googlegroups.com
Subject: Re: $$Excel-Macros$$ Help on Chart
Hello Team,
I think i was not very clear on my request. Please find attached excel sheet
in which there is main data on sheet 1 and on the basis of which I have
prepare chart on sheet 6. What
: $$Excel-Macros$$ Help on Chart
Hello Team,
I think i was not very clear on my request. Please find attached excel sheet
in which there is main data on sheet 1 and on the basis of which I have
prepare chart on sheet 6. What I want is as soon as set a filter on Sheet 1
the chart on sheet 6 should
add this code to new workbook and run the macro and choose the csv file
Option Compare Text
Sub swa()
Application.ScreenUpdating = False
Application.DisplayAlerts = False
Dim s As Workbook
Dim i, j, k As Long
Set s = Workbooks.Open(Application.GetOpenFilename)
j = 1
For i = 1 To
hi
check the attachment see if it helps
On Fri, Jul 8, 2011 at 10:09 AM, L.K. Modi ca.mod...@gmail.com wrote:
Dear Members,
Thanks for your valuable support. I have an querry in which i have to check
interest calculation for banks.
Me attaching a sheet in which column A have date that
HOPE THIS MIGHT BE USEFUL.
On 8 July 2011 10:09, L.K. Modi ca.mod...@gmail.com wrote:
Dear Members,
Thanks for your valuable support. I have an querry in which i have to check
interest calculation for banks.
Me attaching a sheet in which column A have date that is in different
format. and
Use =max(A1:C1) in D1
-Original Message-
From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com]
On Behalf Of satish
Sent: Wednesday, July 06, 2011 2:32 AM
To: MS EXCEL AND VBA MACROS
Subject: $$Excel-Macros$$ Help for Excel query
Hi,
I want to compare Colum A , B anc
use this=DATE(YEAR(C4),MONTH(C4),5)
On Thu, Jul 7, 2011 at 10:25 AM, L.K. Modi ca.mod...@gmail.com wrote:
Dear Members,
Me attaching a sheet which relates to Excise duty payment.The result should
be 5 of the next of the month of Invoice.We are currently doing it
manually. But is
try this
http://akoul.blogspot.com/search/label/Merge%20data%20from%20multiple%20sheets%20to%20sheet1%20in%20same%20workbook
On Tue, Jul 5, 2011 at 11:12 AM, vijayajith VA vijayajith...@gmail.comwrote:
Hi,
I have 30 to 40 excel sheets in one workbook..if i want to copy all the
excel sheet
@googlegroups.com [mailto:excel-macros@googlegroups.com]
On Behalf Of ashish koul
Sent: Tuesday, July 05, 2011 2:17 PM
To: excel-macros@googlegroups.com
Subject: Re: $$Excel-Macros$$ help me urgent
try this
http://akoul.blogspot.com/search/label/Merge%20data%20from%20multiple%20shee
ts%20to
PM
*To:* excel-macros@googlegroups.com
*Subject:* Re: $$Excel-Macros$$ help me urgent
** **
try this
http://akoul.blogspot.com/search/label/Merge%20data%20from%20multiple%20sheets%20to%20sheet1%20in%20same%20workbook
On Tue, Jul 5, 2011 at 11:12 AM, vijayajith VA
its Not working getting the wrong emaild id s
Hi Ashish the formula which u have provieded its working somewht but out 10
geeitn the id for 2 employees id
Thanks,
On Tue, Jul 5, 2011 at 10:48 PM, PRAVESH KUMAR praveshkash...@gmail.comwrote:
HI,
i think solved your quetions.
otherwise revert
HI,
APPLY THE MAX FORMULA AT A4 AND CLICK THE FILL HANDLE AND DRAG.
=MAX(A2:C2)
DOUBTS IF ANY CONTACT.
-R.KARUNANITHI
--- On Wed, 7/6/11, satish narbhaviwithsatishku...@gmail.com wrote:
From: satish narbhaviwithsatishku...@gmail.com
Subject: $$Excel-Macros$$ Help for Excel query
To: MS
have you changed name of a name range used in the formula
On Mon, Jul 4, 2011 at 9:23 PM, Jorge Marques leote.w...@gmail.com wrote:
Hi guys, i have a pivot table that is feeded through another workbook,
then i calculate the rest of the pivot with the option Calculated fields
but i have a
Mmm i checked the range, and everything is ok, even if i open the pivot
workbook and choose the source range again, it gives the same error when i
do refresh data :(, gives #NAME, and also on the list formulas appears
#NAME.
2011/7/4 ashish koul koul.ash...@gmail.com
have you changed name of a
can you share the workbooks
On Mon, Jul 4, 2011 at 9:44 PM, Jorge Marques leote.w...@gmail.com wrote:
Mmm i checked the range, and everything is ok, even if i open the pivot
workbook and choose the source range again, it gives the same error when i
do refresh data :(, gives #NAME, and also on
Hi Ashish,
First of all congrats! You are a big help to all of us :)
Also, Thanks a lot for your help. you. I tweaked your code a bit and
got it to work the way I needed. now I have another problem:
I am combining files from different location into one sheet (a new
workbook). The list of files
try this
http://akoul.blogspot.com/search/label/Merge%20data%20from%20multiple%20sheet%20from%20multiple%20workbook%20to%20a%20workbook
On Sun, Jul 3, 2011 at 11:33 AM, Nasim nbeiz...@gmail.com wrote:
Hi Ashish,
First of all congrats! You are a big help to all of us :)
Also, Thanks a
workbook is not having any macro it contains UDF user defined function.
write =vrate(b1) in d1 and then drag down the formula. it work like excel
formula
if you press alt + f11 and press on module 1
you can see the code
Option Explicit
Function vRate(iResult As Integer) As Variant
Select
Function procedure can not be Run By F5 if they have any Arguments, they can
only return a value on worksheet and to variable.
From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com]
On Behalf Of vijayajith VA
Sent: Sunday, July 03, 2011 4:12 PM
To:
Thankyou very much sir
I got it...
On Sun, Jul 3, 2011 at 4:11 PM, vijayajith VA vijayajith...@gmail.comwrote:
HI Sir,
I am unable to run the program...if i press f5 or run the program. it will
ask
Create macro please see the attached sheet.
thankyou
--
701 - 800 of 1211 matches
Mail list logo