*hi jai
do u want print out of sheet 1 after having Name, Designation, Emp code of
each employee*?
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 Wed, Jul 6, 2011 at 11:17 AM, ashish koul koul.ash...@gmail.com wrote:
Hi Ankur,
Glad to help you. Pls send me your file...let me try :)
On Wed, Jul 6, 2011 at 12:34 PM, ankur ankurpande...@gmail.com wrote:
hi vasant
thnks for such nice code
i have similar problem also...but i need some modification
this code produce many workbook...cant it be possible to
Hi Ankur,
Glad to help you. Pls send me your file...let me try :)
On Wed, Jul 6, 2011 at 12:34 PM, ankur ankurpande...@gmail.com wrote:
hi vasant
thnks for such nice code
i have similar problem also...but i need some modification
this code produce many workbook...cant it be possible to
Thanks a lot Ashish but this doesn't do what i need. I want the available
quantity and amount against negative and zero values. In other words I want
to set off those negatives and nulls with the positives.
Thanks regards,
AJ
On Wed, Jul 6, 2011 at 12:39 PM, ashish koul koul.ash...@gmail.com
--
--
Some important links for excel users:
1. Follow us on TWITTER for tips tricks and links :
http://twitter.com/exceldailytip
2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310
3. Excel
Hi Jai,
Look Attached below..
On Wed, Jul 6, 2011 at 2:19 PM, Jai jaihumtu...@gmail.com wrote:
--
--
Some important links for excel users:
1. Follow us on TWITTER for tips tricks and links :
*hi jai
find the attached filethis has slight modification of venkatesan
solution...the repeat of name is taken care , as u required tell me it
helps?
*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 Wed, Jul 6,
Dear Jai,
Please try it without helping column..
=VLOOKUP(B7*,Sheet1!B7:C12,2,)
Thanks regards,
Noorain Ansari
*http://noorain-ansari.blogspot.com/* http://noorain-ansari.blogspot.com/
On Wed, Jul 6, 2011 at 2:19 PM, Jai jaihumtu...@gmail.com wrote:
--
hi Noorain Ansari
very good formula.can u explain me
what * had make difference in this formula.
use of * in formula had done what magic..i will also use this in other
formulas in future
Have A Nice Time Enjoy Life
Regards:
CMA Ankur Pandey
(Someone Different)
I'm not the best but
Hi Ankur,
Not sure, whether i understood your query completly...
Pls find this code
This code takes the staff no. from Sheet2 and puts in A2 in the
'gents report sheet. It then picks up the result from C2 cell
of the same sheet and puts into the income tax column for the
corresponding staff
Dear Members
I have a query regarding conditional formating:
1. I have a sheet in which some cells containg amounts out of those some
cells are coloured.
Is there any way to coloured only those coloured cells. One way i have by
filter on the basis of colour but everytime to use that is hectic
Thanks of Lot Sir
On Wed, Jul 6, 2011 at 3:42 PM, ankur ankurpande...@gmail.com wrote:
*hi jai
find the attached filethis has slight modification of venkatesan
solution...the repeat of name is taken care , as u required tell me it
helps?
*Have A Nice Time Enjoy Life
Very intelligent solution by Noorain..
Jai, I am giving another solution
=VLOOKUP(IF(FIND(B17,Sheet1!B5,1),*B17*,0),Sheet1!$B$5:$C$10,2,0)
Try this, it will search RAM or ROH in total string and show result.
RAM or ROH could be anywhere in the string.
On Wed, Jul 6, 2011 at 3:49
It's great...!!!
*---
кαяαηη*
On Wed, Jul 6, 2011 at 3:49 PM, NOORAIN ANSARI noorain.ans...@gmail.comwrote:
Dear Jai,
Please try it without helping column..
=VLOOKUP(B7*,Sheet1!B7:C12,2,)
Thanks regards,
Noorain Ansari
Hello Experts
I Have a one Qurery Please Check the attachment
--
--
Some important links for excel users:
1. Follow us on TWITTER for tips tricks and links :
http://twitter.com/exceldailytip
2. Join our LinkedIN
*HI LK MODI
USED SUM BASED ON COLOUR OF CELL , MAY THIS HELP YOU
USE THIS UDF, U CAN SEE THE CODE IN MODULE
=ColorFunction($B$30,$B$2:$B$27,TRUE)
WHERE B30 CELL IS HAVING COLOUR OF THE CONDITIONAL FORMATING
FILE IS ATTACHED FOR UR REFERENCE
*Have A Nice Time Enjoy Life
Regards:
CMA Ankur
*HI VASANT
THNKS FOR UR EFFORTS
EmpCode = ThisWorkbook.Worksheets(Sheet2).Cells(x, 1)..this code
is not working
U R GETTING IN RIGHT DIRECTION, NOW I NEED... THE STAFF NO OF NEXT EMPLOYEE
GET CHANGED AND THE RESULT GET PASTED IN SHEET2MEANS AUTO CHANGING OF
DATA VALIDATION
http://akoul.blogspot.com/search/label/Function%20To%20Sum%20cells%20on%20the%20basis%20of%20font%20color
http://akoul.blogspot.com/search/label/Function%20To%20Count%20cells%20on%20the%20basis%20of%20font%20color
On Wed, Jul 6, 2011 at 5:06 PM, ankur ankurpande...@gmail.com wrote:
*HI LK
Hello,
Can you explain a bit more ?
Regards.
Daniel
De : excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com] De
la part de Jai
Envoyé : mercredi 6 juillet 2011 13:07
À : excel-macros@googlegroups.com
Objet : $$Excel-Macros$$ Vlookup Query-2
Hello Experts
I
On Wed, Jul 6, 2011 at 4:56 PM, Kal xcel kalx...@gmail.com wrote:
Dear Experts,
For this chart
3001-5000 = 30
5001-6000 = 40
6001-7000 = 45
7001-8000 = 50
8001-9000 = 50
9001-15000 = 110
15001-25000 = 130
25001-4 = 150
40001= =200
I use this formula:
*hi ashish sir
may this help u ...
*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 Wed, Jul 6, 2011 at 5:30 PM, ashish koul koul.ash...@gmail.com wrote:
On Wed, Jul 6, 2011 at 4:56 PM, Kal xcel kalx...@gmail.com
Dear Jai,
Please find solution of 2nd Query...
=VLOOKUP(*C6*,Sheet1!B4:C10,2,0)
See attached sheet.
--
Thanks regards,
Noorain Ansari
*http://noorain-ansari.blogspot.com/* http://noorain-ansari.blogspot.com/
On Wed, Jul 6, 2011 at 4:37 PM, Jai jaihumtu...@gmail.com wrote:
Hello Experts
I
use conditional format with formula
=indirect(B row())
pls find file attached.
cells containg amounts out of those some
cells are coloured.
Is there any way to coloured only those coloured cells. One way i have by
filter on the basis of colour but everytime to use that is hectic so can we
Dear Experts,
For this chart
3001-5000 = 30
5001-6000 = 40
6001-7000 = 45
7001-8000 = 50
8001-9000 = 50
9001-15000 = 110
15001-25000 = 130
25001-4 = 150
40001= =200
I use this formula:
Hi L K Modi,
your query is not clear. Please elaborate.
Kalyan
On Wed, Jul 6, 2011 at 5:06 PM, ankur ankurpande...@gmail.com wrote:
*HI LK MODI
USED SUM BASED ON COLOUR OF CELL , MAY THIS HELP YOU
USE THIS UDF, U CAN SEE THE CODE IN MODULE
=ColorFunction($B$30,$B$2:$B$27,TRUE)
WHERE
The macro is functioning as per my expectation.
Please set the calculation to automatic in your workbook if you hv not done so.
R u getting any error. If so what is the error.
Goto into the debug mode and check if the values in empcode is changing.
On Wed, Jul 6, 2011 at 5:16 PM, ankur
Hi Group,
Pls find a job opening for VBA in Gurgaon.
*Dear Vasant,
*Hi,
Trust you are doing good.
This is Harmeet here from DynPro India Pvt. Ltd.
About DynPro India Pvt. Ltd.:
Established in 1996, DynPro Inc was formed by a management team with
unrivalled experience in IT recruitment,
I want common numbers of both column should shown in column C while
clicking a button. I have used the following formula, but it take very
long time to process each time I opened the file. Thanks
Dear Ankur,
Its working fine. Thank you very much.
Regards,
Idhrees.
On Tue, Jul 5, 2011 at 3:46 PM, ankur ankurpande...@gmail.com wrote:
*You can create a form, by using the IIF function in Control Source
property...Of the field which required
=IIf([Valid date]=Date(),valid,expired)
Hi there i have 2 questions
Firstly how do i attach a file to these posts? i cant see anywhere to
show people my problem?
Secondly:
i have a word document which needs excel pages putting in it - i need
a macro to:
print page 1 of c:\xx\document1.doc
print page1 of sheet1 of
Hi
Pls find the code and the file attached.
The html files stored in the folder 'Folder' will be used for the report.
Sub Test()
Dim Fs As New FileSystemObject, Fl As File
Dim Fld As Folder, FolderPath As String
Dim WkBk As Workbook, DtWkBk As Workbook
Set WkBk = Workbooks.Add
NoShts =
Please see the attached File.
Sub pasteData()
Dim rng As Range
Dim cell As Range
Set rng = Sheets(Sheet1).Range(A3:A
Sheets(Sheet1).UsedRange.Rows.Count)
For Each cell In rng
If cell.Value = ActiveSheet.Range(B1).Value Then
ActiveSheet.Range(C2:C11).Copy
Sheets(Sheet1).Activate
Try this
=IF(ISERROR(VLOOKUP(B2,A:A,1,0)),Common,Double)
From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com]
On Behalf Of HARI NAIR
Sent: Wednesday, July 06, 2011 10:49 AM
To: excel-macros@googlegroups.com
Subject: $$Excel-Macros$$ marco to find common value
I
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
Try this
Sub PrintPerpage()
Dim rng As Range
Dim cell As Range
Set rng = Sheets(OD_New).Range(N5:N23)
For Each cell In rng
Range(G4).Value = cell.Value
Range(G5).Value = cell.Offset(0, 1).Value
ActiveWindow.SelectedSheets.PrintOut Copies:=1
* Character will find the value which start with Following Characters.
From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com]
On Behalf Of ankur
Sent: Wednesday, July 06, 2011 4:07 PM
To: excel-macros@googlegroups.com
Subject: Re: $$Excel-Macros$$ Vlookup Regarding Query
See if it help
From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com]
On Behalf Of Jai
Sent: Wednesday, July 06, 2011 4:37 PM
To: excel-macros@googlegroups.com
Subject: $$Excel-Macros$$ Vlookup Query-2
Hello Experts
I Have a one Qurery Please Check the attachment
See if it Help.
Sub Compile()
On Error GoTo Err_Clear:
Application.ScreenUpdating = False
Application.DisplayAlerts = False
Dim Fso As New Scripting.FileSystemObject
Dim Path As String
Application.FileDialog(msoFileDialogFolderPicker).Title = Select Folder to
Pick Downloaded Bills
Converting text case to ProperCase in VBA
alt:
Instead of using Application.Function / WorksheetFunction) we can also use
VBA function:
*StrConv *function
StrConv( , vbProperCase)
Example in sub procedur
Sub ConvertProperCase()
Application.ScreenUpdating = False
Dim Cell As
OH Ashish,
I havent gone throuh the mail.
btw congrats buddy :)
Thanks
On Mon, Jul 4, 2011 at 10:07 PM, seraj alam seraj.ala...@gmail.com wrote:
Hi Ashish,
Many many congrats...
With best wishesh,
Seraj Alam
On Mon, Jul 4, 2011 at 9:40 PM, Hari harisha.prabha...@gmail.com wrote:
=*LOOKUP*
(D16,{3001,5001,6001,7001,8001,9001,15001,25001,40001},{30,40,45,50,60,110,130,150,200})
or..
=*VLOOKUP*(D16,$A$1:$B$9,2,TRUE)
the above VLookUp fungtion refers to a table
*tabel A1:B9*
* 3001 30 *
* 5001 40 *
* 6001 45 *
* 7001 50*
* 8001 60*
* 9001 110*
*15001 130*
You can use Vlookup formula as shown in attachment.
Regards,
Modh
From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com] On
Behalf Of Kal xcel
Sent: Wednesday, July 06, 2011 4:56 PM
To: excel-macros@googlegroups.com
Cc: Dave Bonallack; NOORAIN ANSARI; Ashish Koul
Subject:
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
43 matches
Mail list logo