You can't have an Excel function replace the values in the cell.You could use
VBA, but it would be easier to simply use VLOOKUP.
In Cell B21, put:=VLOOKUP(C21,$A$10:$B$17,2,FALSE)Then copy this down to row 29.
HIghlight the cells and ctrl-CThen, right-click cell C21 and Paste Values.
Mr. Shot: :)
I don't believe you're being "ignored".I suspect it's more along the lines
of:"How much effort do I/we have to put into trying to figure out what it is
you want to do and do I/we have the expertise to address it".
Your messages are a "little" confusing.
You've posted a question on
Hi Guys,
Still waiting for some resolution in this group.
Pls help.
On Sat, Mar 26, 2016 at 12:46 AM, Secret Shot wrote:
> Dear Experts,
>
> I want help in macro which can attach 4 mail with standard subject line
> into one mail as an attachment and send that mail to a
Hi Guys,
Cant anyone here help me pls. Does no one know OUTLOOK MACROS
On Sat, Mar 26, 2016 at 12:46 AM, Secret Shot wrote:
> Dear Experts,
>
> I want help in macro which can attach 4 mail with standard subject line
> into one mail as an attachment and send that mail to a
Do you mean like:
=IF(AND(C51.1,C81.1),0.8,C10/C4)
Paul
-
“Do all the good you can,
By all the means you can,
In all the ways you can,
In all the places you can,
At all the times you can,
To all the people you can,
As long as ever you can.” - John Wesley
Dear Paul,
Thank you same as working properly.
Thanks Regards,
Sriram.
On Tue, Nov 25, 2014 at 5:04 PM, Paul Schreiner schreiner_p...@att.net
wrote:
Do you mean like:
=IF(AND(C51.1,C81.1),0.8,C10/C4)
*Paul*
-
*“Do all the good you can,By
Hi Ravinder,
PFA
Regards
Ashish
On Sun Nov 16 2014 at 5:10:24 PM Ravinder Kumar
ravinderbhardwa...@gmail.com wrote:
Hi All,
Please help me in the attached data, please share also the way to resolve
it.
Regards,
Ravindra
--
Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you
Hi Amit,
PFA..!!!
Regards
Ashish Kumar
On 24 September 2014 16:22, Amit Desai (MERU) amit.de...@merucabs.com
wrote:
Dear All,
I would like to have a layered chart for 3 cities...So for each city there
should be 3 main bars. These each Bar has to have 2 sub bars in side it...
Hi,
Check this..!!
Regards
Ashish
--
Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It's
=TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @
https://www.facebook.com/discussexcel
FORUM RULES
1) Use concise, accurate thread titles. Poor thread titles,
Hi,
Check this one!
Regards
Ashish
--
Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It's
=TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @
https://www.facebook.com/discussexcel
FORUM RULES
1) Use concise, accurate thread titles. Poor thread
fyi
Warm Regards,
Dhaval Shah
M) 98240 35253
*E-mail : todhavals...@gmail.com todhavals...@gmail.com*
On Tue, Jun 17, 2014 at 12:51 PM, Rakesh kumar rakesh.apt...@gmail.com
wrote:
Hi Guys,
I want to use formula on pivot table data.
Kindly help me.
--
Thanks £ Regards
Rakesh Kumar
Thanks Brother, But how you Did this.
Please explain the process.
On Tue, Jun 17, 2014 at 1:02 PM, Dhaval Shah todhavals...@gmail.com wrote:
fyi
Warm Regards,
Dhaval Shah
M) 98240 35253
*E-mail : todhavals...@gmail.com todhavals...@gmail.com*
On Tue, Jun 17, 2014 at 12:51 PM, Rakesh
Dear Harish,
Please find attachment of addin.
Please use reply.
Thanking you
(it was received by me in 2009 through this group)
On 30 January 2014 14:39, Harish P Y py.har...@gmail.com wrote:
Dear Excel Gurus,
Please find the attached file Marks Sheet,
and i want to obtain the marks
It is not working Sir
With Regards
*HARISH P Y*
*P* *THINK BEFORE YOU PRINT:**Before printing this e-mail think whether it
is really necessary. Thanks for your support to protect our environment for
the future generation*
*1 ream of paper = 6% of a tree and 5.4 kg CO2 in the atmosphere 3
Dear,
use this. =num2text(reference)
Please check attachment.
thanking you
On 4 February 2014 09:42, Harish P Y py.har...@gmail.com wrote:
It is not working Sir
With Regards
*HARISH P Y*
*P* *THINK BEFORE YOU PRINT:**Before printing this e-mail think whether
it is really necessary.
http://excelribbon.tips.net/T008351_Converting_Numbers_Into_Words.html
http://support.microsoft.com/kb/213360
http://www.yogeshguptaonline.com/2009/07/excel-functions-convert-numbers-into.html
check above links
On Thu, Jan 30, 2014 at 2:39 PM, Harish P Y py.har...@gmail.com wrote:
Dear Excel
This is very useful.
http://excelribbon.tips.net/T008351_Converting_Numbers_Into_Words.htmlhttp://support.microsoft.com/kb/213360
Thanks for this Link.
--
Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s
=TIME(2,DO:IT,N:OW) ! Join official Facebook page of this
Ravinder,
PFA,
Regards,
Cartik
On Tue, Nov 12, 2013 at 10:50 AM, Ravinder Kumar
ravinderbhardwa...@gmail.com wrote:
Hi
Please help me, to create a formula with small function and Vlook up
function.
Regards
Ravindra
--
Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you
Hi try these links see if it helps
http://chandoo.org/wp/2010/01/04/sales-dashboards/
http://chandoo.org/wp/2008/03/28/73-free-designer-quality-excel-chart-templates-grab-now-and-become-a-charting-superman/
http://chandoo.org/wp/2011/03/22/customer-service-dashboard/
Hi
I have attached some dummy data.
Please suggest how can I calculate on year basis or division basis like if
I change the division to calculate the head count/CTC then data should
change automatically.
In HR Dashboard I can show the status of recruitment done/ Exits/Head
Count in a particular
Give some data...in which you want to work even dummy data.
From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com]
On Behalf Of alisha malhotra
Sent: Tuesday, October 15, 2013 11:21 PM
To: excel-macros@googlegroups.com
Subject: $$Excel-Macros$$ Help needed in creating a
:49 AM
*Subject:* Re: $$Excel-Macros$$ Help needed in Excel
I want to merge contents of column A B as shown in column C. Please see
the sample file enclosed
On Wednesday, August 7, 2013 2:34:57 PM UTC+5:30, Ravinder Negi wrote:
pls provide excel or explain more about your query
See any hidden temp file is created or not.
Try revoking shared access for particular folder n re share.
Thanks
On 21 Aug 2013 17:26, thameem thamee...@gmail.com wrote:
Dear all,
file is in server, but no one is using that file, but stil showing file is
use.. please help me wat to do...
--
thanks.. its done
On Wed, Aug 21, 2013 at 4:05 PM, vba v...@vabs.in wrote:
See any hidden temp file is created or not.
Try revoking shared access for particular folder n re share.
Thanks
On 21 Aug 2013 17:26, thameem thamee...@gmail.com wrote:
Dear all,
file is in server, but no one is
:
*Cc:* ravinder negi ravi_c...@yahoo.com javascript:
*Sent:* Tuesday, August 13, 2013 8:49 AM
*Subject:* Re: $$Excel-Macros$$ Help needed in Excel
I want to merge contents of column A B as shown in column C. Please see
the sample file enclosed
On Wednesday, August 7, 2013 2:34:57 PM UTC+5
I want to merge contents of column A B as shown in column C. Please see
the sample file enclosed
On Wednesday, August 7, 2013 2:34:57 PM UTC+5:30, Ravinder Negi wrote:
pls provide excel or explain more about your query...
--
*From:* Pankaj
pls provide excel or explain more about your query...
From: Pankaj pankajdhamij...@gmail.com
To: excel-macros@googlegroups.com
Sent: Wednesday, August 7, 2013 9:23 AM
Subject: $$Excel-Macros$$ Help needed in Excel
I have 2 columns in excel - A and B.
I
Sorry, might be I am not explained clearly, example I have file name 350
in that folder i have file names from 1 to 5000, i will type this file name
350 in one cell, then i will run vba code, so it can open file with name
350. please help me
regards,
thameem
On Sun, Jul 14, 2013 at 9:57 AM,
hi try this
Sub check_files_to_open()
Dim fldpath
Dim fld As Object, fil As Object, fso As Object
Dim flname As String
With Application.FileDialog(msoFileDialogFolderPicker)
.Title = Choose the folder
.Show
End With
flname = InputBox(Enter file to search)
On Error Resume Next
fldpath =
sorry again not working, its asking to select folder, later file name, if i
type file name, its actually pdf format but opening in excel format.
cant we fix folder path in this program, so there is no need to select
folder every time
On Sun, Jul 14, 2013 at 11:57 AM, ashish koul
try this
Sub check_files_to_open()
Dim flname As String
flname = InputBox(Enter file to search)
Set fso = CreateObject(scripting.filesystemobject)
Set fld = fso.getfolder(C:\Users\admin\Desktop\New folder)
For Each fil In fld.Files
If UCase(Left(fil.Name,
thank you it working
On Sun, Jul 14, 2013 at 3:58 PM, ashish koul koul.ash...@gmail.com wrote:
try this
Sub check_files_to_open()
Dim flname As String
flname = InputBox(Enter file to search)
Set fso = CreateObject(scripting.filesystemobject)
Set fld =
try this see if it helps
Sub check_files_to_open()
Dim fldpath
Dim fld As Object, fil As Object, fso As Object
With Application.FileDialog(msoFileDialogFolderPicker)
.Title = Choose the folder
.Show
End With
On Error Resume Next
fldpath =
HI DP
many thanks for the solution..for my query and its working and serving
my purpose 100%
thanks
Patil M G
On Wed, Jul 10, 2013 at 7:22 PM, De Premor d...@premor.net wrote:
Hi Patil,
PFA
Please Run Procedure named *GenerateFromTemplate
*
Rgds,
[dp]*
*
Pada 10/07/2013 18:30,
Thank you Sir,
lock aspect ratio and move and don't resize with cells, are not
checked(ticked), I did both. thank you once again for helping me,
regards,
Thameem.M
On Mon, Jun 10, 2013 at 8:38 AM, P.VIJAYKUMAR vijay.4...@gmail.com wrote:
Respected Thameem,
After inserting the graph you get
Can you please share your file
On Sun, Jun 9, 2013 at 2:32 PM, thameem thamee...@gmail.com wrote:
Dear sir's,
I have problem in excel graph, its automatically getting enlarged, if i
close and open excel, then again it will be in original size, with out any
modification, please advise me
am sorry, it is office file, I am working for gas plant, they dont allow us
to use USB or to upload any official file in mail.
regards,
Thameem.M
On Sun, Jun 9, 2013 at 1:56 PM, priti verma pritiverma1...@gmail.comwrote:
Can you please share your file
On Sun, Jun 9, 2013 at 2:32 PM,
Respected Thameem,
After inserting the graph you get the chart tools in the menu bar. In the
chart tools menu go to the formatting tab. In the last tab (to the right)
you will find size munu.Click the small arrow down the tab and you will get
sizing message box with size and properties tabs.In
its serving my requirement..thank you so much for help paul
thanks
Patil MG
On Wed, Jun 5, 2013 at 8:05 PM, Paul Schreiner schreiner_p...@att.netwrote:
Try this macro.
if it does what you're looking for, then I can walk you through how it
operates.
*Paul*
Here.
This will create a list downwards from the selected cell.
On the Home sheet, select A1 and click the button. If you change the name
of sheets, or add / remove sheets, click on the button again to update.
HTH
Regards,
On Wed, May 15, 2013 at 10:04 AM, Prabhu Pinky
thanks abhi,
but i need this to be listed in drop down menu.
regards
prabhu r
On 15 May 2013 10:19, Abhishek Jain abhishek@gmail.com wrote:
Here.
This will create a list downwards from the selected cell.
On the Home sheet, select A1 and click the button. If you change the name
of
You did not mention that in your earlier query.
However, attached is the solution to your new requirement.
Regards,
Abhi
On Wed, May 15, 2013 at 10:22 AM, Prabhu Pinky prabhupin...@gmail.comwrote:
thanks abhi,
but i need this to be listed in drop down menu.
regards
prabhu r
On 15
Hi abhi,
thanks for your quick help. it really works fine.
i need one more modification in this querry. is it possible if i delete any
sheet in this workbook and it should not show in that list..?
On 15 May 2013 10:36, Abhishek Jain abhishek@gmail.com wrote:
You did not mention that in
Whenever you add, delete, or rename a sheet - just save and close the file.
When you will open the file again, it will be updated.
On Wed, May 15, 2013 at 10:41 AM, Prabhu Pinky prabhupin...@gmail.comwrote:
Hi abhi,
thanks for your quick help. it really works fine.
i need one more
oh yeah
its working.. thanks abhi... :D
regards
Prabhu R
On 15 May 2013 10:49, Abhishek Jain abhishek@gmail.com wrote:
Whenever you add, delete, or rename a sheet - just save and close the
file. When you will open the file again, it will be updated.
On Wed, May 15, 2013 at 10:41
=MID(A1,FIND(5,A1),6)
On Thu, Apr 11, 2013 at 10:16 PM, KAUSHIK SAVLA savla.kaus...@gmail.comwrote:
Hi Team,
I need a formula to find anything starting from 5 in a cell and to take 6
digit right of the cell starting from 5 as below.
Eg.
DataDesired Result
ABC
Thank You very much for prompt response!
On Thu, Apr 11, 2013 at 10:22 PM, ashish koul koul.ash...@gmail.com wrote:
=MID(A1,FIND(5,A1),6)
On Thu, Apr 11, 2013 at 10:16 PM, KAUSHIK SAVLA
savla.kaus...@gmail.comwrote:
Hi Team,
I need a formula to find anything starting from 5 in a cell
There are several different types of loops.
The type you select will depend on your specific situation.
a couple of examples would be:
'---
Sub Loop1()
Dim Rng As Range
For Each Rng In Range(A2:A10)
MsgBox Rng.Value
Next Rng
Hi all,
thank you all for your help and time that you spend to solve this problem!
I am very happy with the solution that Ashish attached.
This solution works perfect and I am very happy with it - thank you!
Unfortunately, I forgot to mention something important yesterday ...
I need this
Hi,
Pls find attached excel.
Check if it is ok with you.
Regards,
Swapnil.
On Wed, Oct 10, 2012 at 1:41 PM, Henning Deschka kie...@freenet.de wrote:
Hi all,
thank you all for your help and time that you spend to solve this problem!
I am very happy with the solution that Ashish attached.
Hi,
Here is another solution without inserting exta column Column D.
Don't ask me to explain this formula, because I also don't know how it
works. [?] I get this formula from net and just modified it.
Following is the link from where I get it.
Hi,
Insert followibg formula in D1 cell.
=if(and(or(a1=1,b1=1),c123400),3,0)
Hope this is what u want.
Regards
swapnil,
On Oct 9, 2012 6:57 PM, Henning Deschka kie...@freenet.de wrote:
Hi NG,
I need to insert a function into cell D1 with an Excel2007 macro that
executes the following:
see the attachment check the cells with Yellow color
On Tue, Oct 9, 2012 at 8:48 PM, Swapnil Palande palande.swapni...@gmail.com
wrote:
Hi,
Insert followibg formula in D1 cell.
=if(and(or(a1=1,b1=1),c123400),3,0)
Hope this is what u want.
Regards
swapnil,
On Oct 9, 2012 6:57 PM,
Thank you its working
On Mon, Sep 3, 2012 at 5:22 PM, Amresh Maurya amreshkushw...@gmail.comwrote:
Hi Rambabu,
Find the attached file.
use this formula.
=SUMIFS(I15:I24,K15:K24,O15,J15:J24,N15)
Regards
Amresh
On Mon, Sep 3, 2012 at 5:19 PM, NOORAIN ANSARI
Please try
=SUMIFS($I$15:$I$24,$J$15:$J$24,N15,$K$15:$K$24,=O15)
On Mon, Sep 3, 2012 at 5:17 PM, Rambabu Mudiraj rambabu1...@gmail.comwrote:
Dear all,
--
Regards
Rambabu. G
--
Join official facebook page of this forum @
https://www.facebook.com/discussexcel
FORUM RULES (1120+
Dear Ram,
If you working in prior version of Excel 2007
You can use
=SUMPRODUCT(($J$15:$J$24=N15)*($K$15:$K$24=O15)*($I$15:$I$24))
On Mon, Sep 3, 2012 at 5:19 PM, NOORAIN ANSARI noorain.ans...@gmail.comwrote:
Please try
=SUMIFS($I$15:$I$24,$J$15:$J$24,N15,$K$15:$K$24,=O15)
On Mon, Sep
Hi Rambabu,
Find the attached file.
use this formula.
=SUMIFS(I15:I24,K15:K24,O15,J15:J24,N15)
Regards
Amresh
On Mon, Sep 3, 2012 at 5:19 PM, NOORAIN ANSARI noorain.ans...@gmail.comwrote:
Please try
=SUMIFS($I$15:$I$24,$J$15:$J$24,N15,$K$15:$K$24,=O15)
On Mon, Sep 3, 2012 at 5:17
Dear Sanotsh,
If you are using Excel 2007+, Attached sheet will also helpful for you.
On Sat, Jul 21, 2012 at 4:38 PM, santosh subudhi
santoshkumar.subu...@gmail.com wrote:
Hi Group,
Need another help to count and sum data between two fixed dates.
Regards
Santosh
Don Guillett
Microsoft Excel Developer
SalesAid Software
dguille...@gmail.com
From: santosh subudhi
Sent: Saturday, July 21, 2012 6:08 AM
To: excel-macros
Subject: $$Excel-Macros$$ Help needed to count and sum data between two fixed
dates.
Hi Group,
Need another help to count and sum data
You can try this :
Sub sauce_data_FRI_AMPM()
Dim wbkNew As Workbook
Set wbkNew = Workbooks.Open(Filename:=R:\Planning\Sauce Plan - New.xls,
ReadOnly:=True)
wbkNew.Worksheets(SaucePlan).Range(E6:H101).Copy Workbooks(LowRisk
EPlan SAUCE week 19.xls).Worksheets(YourSheetName).Range(W6)
I think No, you can't change.
You can convert it in PDF and make it readable by One Adobe Tools [name I
don't remember) , Please google it.
Rajan.
From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com]
On Behalf Of Shekhar Sharma
Sent: Apr/Fri/2012 02:32
To:
Please
download ; http://www.minipdf.com/
I tried it and it works fine ...
Chilexcel
2012/4/20 Rajan_Verma rajanverma1...@gmail.com
I think No, you can’t change.
** **
You can convert it in PDF and make it readable by One Adobe Tools [name I
don’t remember) , Please google
Dear Sir
I can able to create Notepad files , but i getting following error when
trying to create word files
Run Time Error
User Defined is not found
On Tue, Mar 13, 2012 at 4:39 PM, BNS kumar chimir...@gmail.com wrote:
Hi,
check this out
Sub CreateWordDocs()
' add a reference to the
Try this
Sub CreateWordDocs()
Dim xsht As Worksheet
Dim rng As Range
Dim lngLoop As Integer
Set xsht = ActiveWorkbook.Worksheets(Sheet1)
lngLoop = xsht.Cells(Rows.Count, 3).End(xlUp).Row
If lngLoop 1 Then
With CreateObject(Word.Application)
.Visible
Hi All
can any one help me pl..its very urgent,,,
On Mon, Mar 12, 2012 at 12:52 PM, Patil MG mailpati...@gmail.com wrote:
Dear Experts,
I have to create 'N' number of empty files of word and note pad files,
this word will long time to do can any one help to write a macro
Hi,
Please find the attached text file. Copy and paste in that excel file and
run.
Regards
Kumar
On Tue, Mar 13, 2012 at 2:08 PM, Patil MG mailpati...@gmail.com wrote:
Hi All
can any one help me pl..its very urgent,,,
On Mon, Mar 12, 2012 at 12:52 PM, Patil MG
Hi,
check this out
Sub CreateWordDocs()
' add a reference to the Word-library
' this is for creating number word Documents and renaming them with
file names mentioned in 'C' column
' this code doesn't write any content, it just creates word documents
and saves them
Dim newapp As
please find the attachment
On Sun, Feb 26, 2012 at 9:19 PM, Sourabh Salgotra rhtdmja...@gmail.comwrote:
Dear sir,
plz download the attachment and help me...
--
FORUM RULES (986+ members already BANNED for violation)
1) Use concise, accurate thread titles. Poor thread titles,
My Try,
=IF(AND(C2=Y,COUNTIF(D2:G2,Y)),$C$1,,IF((C2)=Y,$C$1,))IF(AND(D2=Y,COUNTIF(E2:G2,Y)),$D$1,,IF((D2)=Y,$D$1,))IF(AND(E2=Y,COUNTIF(F2:G2,Y)),$E$1,,IF((E2)=Y,$E$1,))IF(AND(F2=Y,COUNTIF(G2:G2,Y)),$F$1,,IF((F2)=Y,$F$1,))IF(G2=Y,$G$1,)
On Sun, Feb 26, 2012 at 8:03 PM, xlstime xlst...@gmail.com
thanks for help sir
i am already done with if statement. chk attachment.
and provide other solution vlookup/index-match
On Sun, Feb 26, 2012 at 9:33 PM, xlstime xlst...@gmail.com wrote:
please find the attachment
On Sun, Feb 26, 2012 at 9:19 PM, Sourabh Salgotra rhtdmja...@gmail.comwrote:
) = Right(ms, Len(ms) - 1)
Next r
End Sub
Don Guillett
SalesAid Software
dguille...@gmail.com
From: Sourabh Salgotra
Sent: Sunday, February 26, 2012 10:23 AM
To: excel-macros@googlegroups.com
Subject: Re: $$Excel-Macros$$ help needed??
thanks for help sir
i am already done with if statement
For book #s starting at 1001 and changing every 10 rows;
Put in cell A2:
=IFERROR(OFFSET(A2,-10,0)+1,1001)
In case of Excel version prior to 2003, which doesn't support IFERROR, use:
=IF(ROW(A2)11,OFFSET(A2,-10,0)+1,1001)
Change default book # in formula as desired. Copy down.
So what exactly do you want? Your attachment isn't clear as to what formula
you require.
From what I understood, have made a sheet with sequence of receipt leaflets,
depending on the number of leaves and starting number.
Regards,
Sam Mathai Chacko (GL)
On Mon, Oct 24, 2011 at 7:04 PM, sriram
Maybe???
=IF(COUNTIF(A:A,D4)=10,No,)
Don Guillett
SalesAid Software
dguille...@gmail.com
From: sriram ji
Sent: Monday, October 24, 2011 8:34 AM
To: excel-macros@googlegroups.com
Subject: $$Excel-Macros$$ Help needed..?
Dear All,
Kindly find the attached file, and provide
AM
To: 'excel-macros@googlegroups.com'
Subject: RE: $$Excel-Macros$$ Help needed..?
For book #s starting at 1001 and changing every 10 rows;
Put in cell A2:
=IFERROR(OFFSET(A2,-10,0)+1,1001)
In case of Excel version prior to 2003, which doesn't support IFERROR, use:
=IF(ROW(A2)11
Rossoff
Sent: Monday, October 24, 2011 8:16 AM
To: 'Asa Rossoff'; excel-macros@googlegroups.com
Subject: RE: $$Excel-Macros$$ Help needed..?
I agree with Sam that your requirement isn't 100% clear. He gave a solution
for one interpretation.
I'll flesh out mine.
=IFERROR(OFFSET(A2,-10,0
Hi Sriram,
Please find attached solved sheet.
Thanks
Mukesh
- Original Message -
From: sriram ji
To: excel-macros@googlegroups.com
Sent: Monday, October 24, 2011 7:04 PM
Subject: $$Excel-Macros$$ Help needed..?
Dear All,
Kindly find the attached file, and provide
Hi Amit,
Follow steps carefully in sequence
Add 3 named ranges as below
Vehicle=LOG!$E$2:INDEX(LOG!$E$2:$E$1,MATCH(REPT(z,20),LOG!$E$2:$E$1,1))
EntryDate=LOG!$B$2:INDEX(LOG!$B$2:$B$1,MATCH(9E+305,LOG!$B$2:$B$1,1))
Data=IF((EntryDate=Sheet2!$A1)*(EntryDate=Sheet2!$B1)=1,Vehicle,)
for appreciating Meru's service
Regards,
Amit Desai
From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com] On
Behalf Of Sam Mathai Chacko
Sent: 02 October 2011 21:28
To: excel-macros@googlegroups.com
Subject: Re: $$Excel-Macros$$ Help needed to find total Unique count from
*To:* excel-macros@googlegroups.com
*Subject:* Re: $$Excel-Macros$$ Help needed to find total Unique count
from a range of moving dates
** **
Hi Amit,
Follow steps carefully in sequence
Add 3 named ranges as below
Vehicle=LOG!$E$2:INDEX(LOG!$E$2:$E$1,MATCH(REPT(z,20),LOG!$E$2:$E
HI,
Please visit this Page to know more about Worksheet Events..
Regards
Rajan
On Sat, Oct 1, 2011 at 10:53 AM, Mr excel excelkeec...@gmail.com wrote:
HI group,
This is a Great amazing group in learning excel vba..
*Private Sub Worksheet_BeforeDoubleClick(ByVal Target As Range, Cancel
Hey Rajan Babu,
which page?
On Sat, Oct 1, 2011 at 11:52 AM, rajan verma rajanverma1...@gmail.comwrote:
HI,
Please visit this Page to know more about Worksheet Events..
Regards
Rajan
On Sat, Oct 1, 2011 at 10:53 AM, Mr excel excelkeec...@gmail.com wrote:
HI group,
This is a Great
Please VIsit this Page..
http://www.cpearson.com/excel/Events.aspx
On Sat, Oct 1, 2011 at 12:09 PM, XLS S xlst...@gmail.com wrote:
Hey Rajan Babu,
which page?
On Sat, Oct 1, 2011 at 11:52 AM, rajan verma rajanverma1...@gmail.comwrote:
HI,
Please visit this Page to know more about
Thanks rajan babu, for that link.Can anybody quote some more examples in
detail.I just got a little understanding of the function with arguments.But
to enhance my knowledge i would like to study more examples...Pls provide me
with any other examples.
On Sat, Oct 1, 2011 at 12:18 PM, rajan
Here is one I like to use for setting variables (Options) in a file
that is used by other Macros.
Using the Macro below; I can toggle between True and False on the
Options and Colors for specific cells.
Available Options
Star Font Size =16
Label
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, , , , , , ,
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
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
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
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
À :
Hari,
Find attached
*Best Regards,*
*Venkat*
*
*
*Join My Group:
http://groups.google.com/group/excel-miraclehttps://groups.google.com/group/excel-miracle?hl=en
*
On Mon, Jun 20, 2011 at 11:03 AM, HARI NAIR hari.shrin...@gmail.com wrote:
I WANT YOUR VALUE HELP TO PUT A FORMULA IN THE
Hi
Try
=IF(COUNTIF(B:B,A2)0,A2,)
Thanks
Mahesh
On Mon, Jun 20, 2011 at 11:03 AM, HARI NAIR hari.shrin...@gmail.com wrote:
I WANT YOUR VALUE HELP TO PUT A FORMULA IN THE ATTACHED SHEET. PLEASE HELP
THANKS IN ADVANCE..
HARI
--
Hi Hari,
Please find the attached file.
Thanks Regards
Anil Kumar
113784
On Sun, Jun 19, 2011 at 10:33 PM, HARI NAIR hari.shrin...@gmail.com wrote:
I WANT YOUR VALUE HELP TO PUT A FORMULA IN THE ATTACHED SHEET. PLEASE HELP
THANKS IN ADVANCE..
HARI
--
Hi Hari,
U can use this simple UDF.
Public Function CommonNumbers(Rng1 As Range, Rng2 As Range)
Fc =
For x = 1 To Len(Rng1.Value)
src = Mid(Rng1.Value, x, 1)
If InStr(Fc, src) = 0 Then
Fc = Fc src
End If
Next x
For x = 1 To Len(Rng2.Value)
src = Mid(Rng2.Value, x,
Sub ests()
Dim i As Long
Dim j, s As Long
For i = 1 To Sheets(1).Range(a65356).End(xlUp).Row
If Sheets(1).Cells(i, 1).Value = Then
j = i + 1
i = i + 2
End If
If Sheets(1).Cells(i, 1).Value Then
Sheets(2).Range(b65356).End(xlUp).Offset(1, 0).Value = Sheets(1).Cells(j,
1).Value
End If
Next i
i would like say thanks for new tips for me i haven't tried it as if
now i am doing it through formula IF itself however to automate this
work if possible could help me to write a macro.
On 5/10/11, ashish koul koul.ash...@gmail.com wrote:
see if it helps
On Tue, May 10, 2011 at 12:13 PM,
Sheet is protected and certain cells are unlocked. (The ones you can get to
are unlocked). The sheet must be protected or the locked and unlockj feature
will not work.
On Sat, Apr 9, 2011 at 8:14 AM, Rambabu Mudiraj rambabu1...@gmail.comwrote:
Dear Friends,
Help needed in Cells Protection
check out this link
http://www.techonthenet.com/excel/cells/protect.php
On Sat, Apr 9, 2011 at 6:44 PM, Rambabu Mudiraj rambabu1...@gmail.comwrote:
Dear Friends,
Help needed in Cells Protection can any one tell me that i cant able to put
cursor in some cells how it is possible i want to
1 - 100 of 123 matches
Mail list logo