Use this if you have data for this month only small and simple
=SUMPRODUCT(--((DAY($B$2:$B$15)=DAY(D2
Regards,
Mandeep baluja
On Friday, September 12, 2014 2:34:42 PM UTC+5:30, Chandru wrote:
Hello,
How to get unique values based on two conditions. Could you help me
Who is Vabz and how much experience he' having ?
--
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
i have a question that i have a list of entries with duplicates what i want
is how to get the distnict values(values which occur only one time) .
Please read my question carefully, I am not asking for removing duplicates
what I want is how to get the list of data which occured 1 time only in
I have made this code for I have two worksheets that are in the same
workbook.
I want to check the values of WS 2, Column B to WS 1, Column B. If there is
a match, then copy/write the row of WS1 to WS 2. but in my code I am
retreiving the values through cells one by one I want *if cell
I have made this code for I have two worksheets that are in the same
workbook.
On Tuesday, November 11, 2014 1:17:46 PM UTC+5:30, Mandeep Baluja wrote:
I have made this code for I have two worksheets that are in the same
workbook.
I want to check the values of WS 2, Column B to WS 1
Kindly find the file attached.
On Tuesday, November 11, 2014 1:17:46 PM UTC+5:30, Mandeep Baluja wrote:
I have made this code for I have two worksheets that are in the same
workbook.
I want to check the values of WS 2, Column B to WS 1, Column B. If there
is a match, then copy/write
Awesome ashish
On Tuesday, November 11, 2014 1:11:31 PM UTC+5:30, Ashish Kumar wrote:
Hi Saleem,
PFA
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 @
Yes there is option in excel to split the data in seperate column as same
format of pdf .
On Sunday, October 19, 2014 6:48:36 PM UTC+5:30, Ujjwal Desai wrote:
Hello ,
I need your help with regards to the attached macro file.
I am trying to convert the pdf file to excel format but the
One thing I let you know that you're are truely awesome in excel and in
concepts the way you answering the questions of Excel VBA related. Wish you
good luck for you future.
On Monday, September 15, 2014 5:41:09 PM UTC+5:30, Mandeep Baluja wrote:
Who is Vabz and how much experience he
I got understand it today . thanks vab I can't expect this kind of
formula what a logical thinking .
On Saturday, August 16, 2014 8:02:59 PM UTC+5:30, Vabz wrote:
Cheers !!
On Aug 16, 2014 4:38 PM, Rajan Verma rajanve...@gmail.com javascript:
wrote:
Wow
On Monday, 11 August 2014
Hello kamal,
check dis out .
Private Sub CommandButton1_Click()
Dim brand As Long
Dim invoice As Long
Dim cell As Range
brand = TextBox1.Value
invoice = TextBox2.Value
temp = brand invoice
Set ws1 = ActiveWorkbook.Sheets(1)
For Each cell In ws1.Range(a1, [a65535].End(xlUp))
If
Use this
formula
=IF(COUNTIF($A$2:$A$64,VLOOKUP(A2,$A$2:$A$64,1,0))1,Duplicate,unique)
if you want to be specific for only using vlookup function in this you can
use =VLOOKUP(VLOOKUP(A2,$A$2:$A$64,1,0),A3:A64,1,0) if na received then
value is unique if value retreived value is duplicate. You
Thanks Vaibhav I got to know that I have not entirerow while pasting the
data to sheet2 . thanks :)
On Tuesday, November 11, 2014 1:17:46 PM UTC+5:30, Mandeep Baluja wrote:
I have made this code for I have two worksheets that are in the same
workbook.
I want to check the values of WS 2
Hey Amit,
kindly find the attachment of data .
Thanks
*Mandeep Baluja *
On Tuesday, November 11, 2014 10:37:18 PM UTC+5:30, Anil Kumar wrote:
how to use function show all location by country name
pfa
Regards,
Anil Kumar Maurya
--
Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel
Hey Pol check this sheet and confirm you want this kind of filters or not .
*Thanks *
*mandeep Baluja*
On Wednesday, November 12, 2014 5:29:41 PM UTC+5:30, Pol Ktk wrote:
Sir,
in attached there are 2 sheet
1 sheet contain data in 2nd sheet need filter data
thanks
--
Are you =EXP(E:RT
Hello All,
My name is Mandeep , I have been working as a MIS Executive since 1 year. I
have keen interest in excel and love the power of VBA. Hope I will help you
in some of your issues.
Regards,
Mandeep Baluja
--
Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s
Please explain the last line !! What's going on in that line what is \b ??
etc etc
Set re = CreateObject(vbscript.regexp)
re.IgnoreCase = True
re.Global = True
re.Pattern = \b[A-Z0-9._%+-]+@[A-Z0-9.-]+\.[A-Z]{2,6}\b
Regards,
Mandeep
--
Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And
Thanks Broo. Have you got your MVP award :)
On Thursday, November 13, 2014 2:47:19 PM UTC+5:30, Mandeep Baluja wrote:
Please explain the last line !! What's going on in that line what is \b
?? etc etc
Set re = CreateObject(vbscript.regexp)
re.IgnoreCase = True
re.Global = True
Hey Kalyan,
check this formula and the sheet
. =COUNT(C4:R4)-COUNTIF(C4:R4,=0)-SUM(IF(ISNUMBER(SEARCH(.,C4:R4)),1,0))
Ctrl+shift+Enter
Regards
Mandeep Baluja
On Thursday, November 13, 2014 5:12:11 PM UTC+5:30, Kal xcel wrote:
Dear Experts,
Please help me to solve my query.
Thanks
Hey Kalyan,
check this array formula and the
sheet.
=COUNT(C4:R4)-COUNTIF(C4:R4,=0)-SUM(IF(ISNUMBER(SEARCH(.,C4:R4)),1,0))
Regards,
Mandeep Baluja
On Thursday, November 13, 2014 5:12:11 PM UTC+5:30, Kal xcel wrote:
Dear Experts,
Please help me to solve my query.
Thanks in advance
Try Freeze panes
On Thursday, November 13, 2014 4:38:49 PM UTC+5:30, Eugene Bernard wrote:
Hi all,
FInd attached an excel sheet, where in i pasted a circular shape in that
sheet.
Whenever i scroll down the row, or move accross the column, I want keep the
circle on the same position. ie
Mr. Rafeeq Let me tell I have faced the same problem while preparing the
invoice for various vendors. I can only provide you the way to create each
and every sheet in separate pdf. if you want. But still question is I dont'
understand dt his amount will be calculated from Source Data!Sheet (G4)
May I know how duplicates are removing ?? as you have not wrote any command
but still duplicates removed in this code. Vabz.. How ?
Thanks in advance
Mandeep
Sub GetUniques()
Dim d As Object, c As Variant, i As Long, lr As Long
Set d = CreateObject(Scripting.Dictionary)
lr =
you can set your default path by copying it in code there is no need to
change it again and again.
add these lines of code in bottom
Workbooks(file1 .xlsx).Close savechanges:=False
Workbooks(file2 .xlsx).Close savechanges:=False
Thanks
*Mandeep Baluja*
On Friday, November 14, 2014 11:31:53
Use this code to apply filter do the changes as per your data.
Sub Filter()
Dim lastrow
Range(m2:q65536).Select
Selection.Clear
lastrow = ActiveSheet.Cells(Rows.Count, 1).End(xlUp).Row
Range(A1:e lastrow).Select
Sheets(Mainsheet).Range(A1:e lastrow).AdvancedFilter
Action:=xlFilterCopy,
Dear Rupesh,
Please find the attachment .
Regards,
*Mandeep Baluja *
On Monday, November 17, 2014 4:10:26 PM UTC+5:30, Rupesh Patil wrote:
Hello experts,
I need your help,I have one userform which attached with mail for your
reference, what I need is add text boxes vertical on button
used name range to achieve the same :) it will not get shifted when you
named that cell and apply link on that.
Thanks
*Mandeep Baluja *
On Wednesday, November 19, 2014 10:24:36 AM UTC+5:30, amar takale wrote:
Dear All friends
Pls solve my hyperlink issue.
If I give hyperlink
zeros and non-zeros in Column A and would like
to see the maximum number flanked by zeros in Column A's non-zero range in
Column B.
What formula should be written in cells in Column B?
A B
0 0
0 0
3 7
2 7
6 7
7 7
0 0
0 0
0 0
8 8
2 8
3 8
0 0
Regards
*Mandeep
=IF(D3=N/A,INDEX($D$1:$D$13,LARGE(IF($D$1:D3N/A,ROW($D$1:D3)),ROW(D3:D3)-ROW(D2:D2)),1),D3)
Ctrl + shift + enter
Mandeep Baluja
Excel Specialist.
On Thursday, November 20, 2014 10:55:44 AM UTC+5:30, Rohan Young wrote:
Dear Group,
Please see the attachment for my requirement
Regards
Try dis kind of formulas. Don't delete the hide rows reference you can
shift it. I will provide you a solution soon for % column too.
Regards,
Mandeep Baluja
*Excel Specialist. *
On Thursday, November 20, 2014 1:22:52 PM UTC+5:30, Nur wrote:
Dear all, I need to extract the partial
through the
sheet.Looking for a Macro which can correct the format of time
automatically.
Regards,
Mandeep Baluja
--
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
Dear Nur,
Thanks to appreciate.
Actually I was doing my office work yes it is possible to reference text
inside the formula.But I need time because I have to do my ofc work too :),
Soon I will submit it your percentage formula too.
On Thursday, November 20, 2014 1:22:52 PM UTC+5:30, Nur
Hey Nur,
Kindly find the attached UDF just type the formula in sheet First
percentage/Second percentage it will give to appropriate result. if text
does not contain second percentage value it will give wrong result.
Function Firstpercentage(txt) As String
Dim k() As String
Dim x As
Worked like a charm :)
Thanks a lot .
On Thursday, November 20, 2014 4:59:00 PM UTC+5:30, Mandeep Baluja wrote:
Dear All,
I need to work on Data sheet which contains all the cells in text format.
basically its a timing sheet. I want to change the format of all the time
values
Thanks Thanks Thanks Thanks Thanks Thanks Thanks Thanks Thanks Thanks Thanks
Thanks Thanks Thanks Thanks Thanks Thanks Thanks Thanks Thanks Thanks Thanks
On Thursday, November 20, 2014 7:01:02 PM UTC+5:30, Mandeep Baluja wrote:
Worked like a charm :)
Thanks a lot .
On Thursday
. If you have any idea to achieve this it
would be great help.
On Thursday, November 20, 2014 4:59:00 PM UTC+5:30, Mandeep Baluja wrote:
Dear All,
I need to work on Data sheet which contains all the cells in text format.
basically its a timing sheet. I want to change the format of all
How can be the no of months between 1 april and 30 june 19 is 12 ? what
you are saying.
Regards,
Mandeep baluja
*Month* *End Month* *FY 15-16* *FY 16-17* *FY 17-18* *FY 18-19* *FY
19-20* *FY 20-21*
*1-Apr-15* *30-Jun-19* *12* *12* *12* *12* *3* *0*
On Friday
Your're most Welcome.
Regards,
Mandeep Baluja
Excel Specialist.
https://www.linkedin.com/profile/view?id=312532939
https://www.facebook.com/VBAEXCELSQL?ref=hl
On Wednesday, November 19, 2014 10:24:36 AM UTC+5:30, amar takale wrote:
Dear All friends
Pls solve my hyperlink issue.
If I
How can be the no of months between 1 april and 30 june 19 is 12 ? what
you are saying.
Regards,
Mandeep baluja
*Month**End Month**FY 15-16**FY 16-17**FY 17-18**FY 18-19**FY 19-20**FY
20-21*
*1-Apr-15**30-Jun-19**12**12**12**12**3**0*
On Friday, November 21, 2014 3:27:20 PM
Regards,
Mandeep Baluja
Excel Specialist.
https://www.linkedin.com/profile/view?id=312532939
https://www.facebook.com/VBAEXCELSQL?ref=hl
On Thursday, November 20, 2014 10:39:07 PM UTC+5:30, Laxmanan M wrote:
hi All,
Please see the attached file as requested. What the outcomes I’m after
of your code
except this , Debug.assert = True , If ((ActiveSheet.Range(A1).Value
X = X) _
And (ActiveSheet.Range(B1).Value X X)).
if(Query = True, Paul will handle it, Paul will handle it) :P
Cheers
Regards,
Mandeep Baluja
https://www.linkedin.com/profile/view?id=312532939
https
Hey Nur,
Kindly find the attachment. frankly speaking this is first time i made this
code without any help from blogs. :)
Regards,
Mandeep Baluja
Excel Specialist.
https://www.linkedin.com/profile/view?id=312532939
https://www.facebook.com/VBAEXCELSQL?ref=hl
On Sunday, November 23, 2014 9:03
Set the columns for emails. it will take email one by one and send the mail
from outlook automatically without showing any notification you can also
use msgbox function to check the list of of users one by one. here the
email column is For Each cell In Range(AJ2:AJ300)
Regards,
Mandeep Baluja
Dear All,
I hope you have a correct idea for my question I am asking to select rows
in data with the help of loop. Please note that what i want is to run a
loop select a row move next and *keep the previous row selected too*. I
need a efficient code for this.
Regards,
Mandeep Baluja
Dear Chandru,
Kindly find the attached file.
Regards,
Mandeep Baluja
On Monday, November 24, 2014 5:41:42 PM UTC+5:30, Chandru wrote:
Hello ,
I need to display value as percentage could you please help me on attached
file.
Thank you,
Chandru
--
Are you =EXP(E:RT
Hey Ashish, Dont you think it will be converted to text if you use that
formula.
On Monday, November 24, 2014 5:50:29 PM UTC+5:30, Ashish Kumar wrote:
Hi Chandra Shekar,
Use this formula :
=A1 %
Regards
Ashish
--
Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be?
Nopz but I just want to learn new things if it works bro.
On Monday, November 24, 2014 6:06:55 PM UTC+5:30, Ashish Kumar wrote:
Dear Mandeep,
Are you trying this formula.
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) !
Chandru find the attachemnt ihad get given above it will take the format as
value. Ashish i know that its a concatenate function but as you are not aware
about the fact whenever a concatenate function is used with text that value
turned into a text .
--
Are you =EXP(E:RT) or =NOT(EXP(E:RT))
,
Mandeep Baluja.
--
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, like Please Help
Sorry not working try this this also selecting the whole range.
On Monday, November 24, 2014 5:05:14 PM UTC+5:30, Mandeep Baluja wrote:
Dear All,
I hope you have a correct idea for my question I am asking to select rows
in data with the help of loop. Please note that what i want is to run
Sub Exercise()
Range(1:1,3:3, 5:5, 7:7).Select
End Sub
See this how this rows are selected I want automation for this with the
help of loop .
On Tuesday, November 25, 2014 11:21:46 AM UTC+5:30, Mandeep Baluja wrote:
Sorry not working try this this also selecting
query is for
alternate rows.
On Tuesday, November 25, 2014 11:30:40 AM UTC+5:30, Mandeep Baluja wrote:
Sub Exercise()
Range(1:1,3:3, 5:5, 7:7).Select
End Sub
See this how this rows are selected I want automation for this with the
help of loop .
On Tuesday
I just want to know whether it's is possible with the help of code or not.
I can achieve the same with the help of helper column using a mod function.
On Monday, November 24, 2014 5:05:14 PM UTC+5:30, Mandeep Baluja wrote:
Dear All,
I hope you have a correct idea for my question I am
Haha and the *master (vabz) *comes and the query resolved. I was looking
for this code. I have seen this code somewhere but it was slipped out of my
mind.
Gud one bro.
Regards,
Mandeep Baluja
Excel Specialist.
https://www.linkedin.com/profile/view?id=312532939
https://www.facebook.com
through me for you.*
On Tue, Nov 25, 2014 at 12:51 PM, Mandeep Baluja rocke...@gmail.com
javascript: wrote:
I just want to know whether it's is possible with the help of code or
not. I can achieve the same with the help of helper column using a mod
function.
On Monday, November 24, 2014 5
Does anyone has another code except this to loop files in folder and
perform operation on that file. ?? this code is correct but i want
different one.
Sub ListFiles()
Dim bookList As Workbook
Dim mergeObj As Object, dirObj As Object, filesObj As Object, everyObj As
Object
the above code is not opening all the files. why ???
On Tuesday, November 25, 2014 3:41:16 PM UTC+5:30, Mandeep Baluja wrote:
Does anyone has another code except this to loop files in folder and
perform operation on that file. ?? this code is correct but i want
different one.
Sub ListFiles
Don't worry I am not imposing this code on you to handle. I just want an
idea for doing this. This is about to highlight some rows data with the
help of conditional formatting. numerous of files reside in directory. I
want to iterate each file with the help of code which is working correctly.
Dear Sriram,
find the attached file.
Regards,
Mandeep Baluja
Excel Specialist.
https://www.linkedin.com/profile/view?id=312532939
https://www.facebook.com/VBAEXCELSQL?ref=hl
On Tuesday, November 25, 2014 4:52:28 PM UTC+5:30, sriram ji wrote:
Dear Guru's
If Forecast Deviation Answered
Filename)
Filename = Dir()
Loop
End Sub
On Tuesday, November 25, 2014 3:41:16 PM UTC+5:30, Mandeep Baluja wrote:
Does anyone has another code except this to loop files in folder and
perform operation on that file. ?? this code is correct but i want
different one.
Sub
Sheet required !!
On Tuesday, November 25, 2014 5:49:28 PM UTC+5:30, Maria Carmel wrote:
Hello,
i need help with creating a name and b-day list that accumulates data ()
from different worksheets of one excel file.
new worksheets added constantly with the same columns (among them names
[h]:mm:ss
What is the keyboard shortcut to set the time in this format.
--
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
build this hope this help someone else.
Sub Format_to_time()
Selection.NumberFormat = [h]:mm:ss
Selection.Font.Bold = True
End Sub
On Wednesday, November 26, 2014 3:29:40 PM UTC+5:30, Mandeep Baluja wrote:
[h]:mm:ss
What is the keyboard shortcut to set the time in this format
?
.
Enjoy
Team XLS
On Wed, Nov 26, 2014 at 4:02 PM, Mandeep Baluja rocke...@gmail.com
javascript: wrote:
build this hope this help someone else.
Sub Format_to_time()
Selection.NumberFormat = [h]:mm:ss
Selection.Font.Bold = True
End Sub
On Wednesday, November 26, 2014 3
path folder.
Regards,
Mandeep Baluja
Excel Specialist.
https://www.linkedin.com/profile/view?id=312532939
https://www.facebook.com/VBAEXCELSQL?ref=hl
On Wednesday, November 26, 2014 4:40:03 PM UTC+5:30, Muneera Shabana wrote:
Good Morning,
Hope you are having a great day!
*Objective: I
\Desktop\a\
k = Replace(wb.FullName, .xlsx, .csv)
q = Replace(k, SourcePath, newpath)
wb.SaveAs q
wb.Close True
Set wb = Nothing
strFile = Dir
Loop
End Sub
Regards,
Mandeep Baluja
Excel Specialist.
https://www.linkedin.com/profile/view?id=312532939
https
Where can I find a list of all methods and functions for VBA in Excel. I
want it in readable format not while searching with the object explorer.
various website is showing but not a complete information in single link.
Regards,
Mandeep Baluja
Excel Specialist.
https://www.linkedin.com
why dont you hide buttons on click and unhide on another
On Monday, November 17, 2014 4:10:26 PM UTC+5:30, Rupesh Patil wrote:
Hello experts,
I need your help,I have one userform which attached with mail for your
reference, what I need is add text boxes vertical on button every time
Replace source line with this
Set j = Application.FileDialog(msoFileDialogFolderPicker)
j.Show
SourcePath = j.SelectedItems(1)
On Wednesday, November 26, 2014 4:40:03 PM UTC+5:30, Muneera Shabana wrote:
Good Morning,
Hope you are having a great day!
*Objective: I
= Dir
Loop
MsgBox The files are successfully converted into .csv format placed in
target folder
End Sub
Regards,
Mandeep Baluja
Excel Specialist.
https://www.linkedin.com/profile/view?id=312532939
https://www.facebook.com/VBAEXCELSQL?ref=hl
On Wednesday, November 26, 2014 4:40:03 PM
Sub test()
Dim sh As Worksheet
Dim sh1 As Worksheet
Dim sh2 As Worksheet
Set sh1 = ActiveWorkbook.Sheets(fullData)
Set sh2 = ActiveWorkbook.Sheets(sheet2)
sh1.Select
Range(2:2,4:4,5:5,10:10,11:11,15:15,16:16,17:17,22:22,26:26).Copy
sh2.Range(A2).PasteSpecial
End Sub
for time query kindly
Hello daya,
there is no pattern to select rows in your Data. Define the pattern first.
On Friday, November 28, 2014 10:53:00 AM UTC+5:30, daya p wrote:
sir,
there is a huge data in my file
On 28 November 2014 at 10:07, Mandeep Baluja rocke...@gmail.com
javascript: wrote:
Sub test
Do you want to get data in next sheet on Day wise criteria or time wise
criteria. row you have highlighted was for 8th nov and 9 th nov .
On Thursday, November 27, 2014 8:00:57 PM UTC+5:30, daya p wrote:
Sir,
good evening to all
i need help on attached sheet
its a machine data of finance
Kindly find the solution i have used two helper column and a macro.
Regards,
Mandeep Baluja
Excel Specialist.
https://www.linkedin.com/profile/view?id=312532939
https://www.facebook.com/VBAEXCELSQL?ref=hl
On Thursday, November 27, 2014 8:00:57 PM UTC+5:30, daya p wrote:
Sir,
good
Sub copysheet2()
ActiveSheet.Range(Range_name).Copy
Sheets(NewsheetName).Range(A1).PasteSpecial
End Sub
Regards,
Mandeep Baluja
Excel Specialist.
https://www.linkedin.com/profile/view?id=312532939
https://www.facebook.com/VBAEXCELSQL?ref=hl
On Tuesday, December 2, 2014 1:01:46 PM UTC+5:30
Hello,
I need your help to acheive something with the help of regular expression
or by any way in vba. what i want is to concateneate a range of cells if
its cell is having duplicates then it should be concatenate only one time.
Regards,
Mandeep
--
Are you =EXP(E:RT) or =NOT(EXP(E:RT))
Thanks Vabz
On Tuesday, December 2, 2014 3:02:29 PM UTC+5:30, Mandeep Baluja wrote:
Hello,
I need your help to acheive something with the help of regular expression
or by any way in vba. what i want is to concateneate a range of cells if
its cell is having duplicates then it should
.Names
WKB2.Names.Add NM.Name, NM.RefersTo
Next NM
MsgBox Completed..., vbInformation
End Sub
Regards,
Mandeep Baluja
Excel Specialist.
https://www.linkedin.com/profile/view?id=312532939
https://www.facebook.com/VBAEXCELSQL?ref=hl
On Tuesday, December 2, 2014 1:01:46
This question is for vabz, Mostly the queries answered by vaibhav
Are you working with a team or you are answering the queries by yourself
only ??? without getting help of someone,
because you're the only efficient programmer in vba here.And I am new in
this field.Can you recommend the best
Hard work Experience Pays off Way to gooo
On Wednesday, December 3, 2014 12:42:13 PM UTC+5:30, Mandeep Baluja wrote:
This question is for vabz, Mostly the queries answered by vaibhav
Are you working with a team or you are answering the queries by yourself
only ??? without getting help
Hey,
I am working on this code if i will not use statement *filename = Dir()*
then it goes into a infinite stage. May I know the reason why and why it's
stopped when i apply this line.
as Per the meaning of this line it will check all the rest of files.
Sub
Try this resolve this query.
Trying to automate this any help will be appreciated.
Regards,
Mandeep
--
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
Good one bro/Sir( hmmm age? ) Awesome use of EO month and Day function.
On Wednesday, December 3, 2014 4:54:19 PM UTC+5:30, Mandeep Baluja wrote:
Try this resolve this query.
Trying to automate this any help will be appreciated.
Regards,
Mandeep
--
Are you =EXP(E:RT) or =NOT(EXP
...
Cheers!!
+
*I did not do this for you. God is here working through me for you.*
On Wed, Dec 3, 2014 at 4:18 PM, Mandeep Baluja rocke...@gmail.com
javascript: wrote:
Hey,
I am working on this code if i will not use statement *filename = Dir()*
then it goes into a infinite stage. May
Thanks bro, Is this your link??
http://www.thinkvidya.com/mumbai/vaibhav-joshi/2391199
On Wednesday, December 3, 2014 4:54:19 PM UTC+5:30, Mandeep Baluja wrote:
Try this resolve this query.
Trying to automate this any help will be appreciated.
Regards,
Mandeep
--
Are you =EXP(E:RT
While studying I got to know that Collection is the object that can take
only unique values with the key identifier and i am taking this advantage
of this. Another one which is having this special property is
Scripting.dictionary object. Can someone incorporate the usage of
duplicates then only
Msgbox 1,2,3,6,7,8,9,10 will be retrieved in msgbox except 4 and 8 which is
duplicate.
On Thursday, December 4, 2014 4:50:09 PM UTC+5:30, Mandeep Baluja wrote:
While studying I got to know that Collection is the object that can take
only unique values with the key
cell.Value
Next
For i = 1 To dicobj.Count
MsgBox dicobj.Item(i)
Next
End Sub
On Thursday, December 4, 2014 4:50:09 PM UTC+5:30, Mandeep Baluja wrote:
While studying I got to know that Collection is the object that can take
only unique values with the key identifier and i am taking
Thanks Paul for your code. Now I got your point. Vabz this is the best link
I have ever seen for VBA.
On Thursday, December 4, 2014 4:50:09 PM UTC+5:30, Mandeep Baluja wrote:
While studying I got to know that Collection is the object that can take
only unique values with the key
Function F_concatenaterow_snb(c01)
F_concatenaterow_snb = Join(Application.Index(c01.Value,1,0), |)
End Function
Is this Index function or other thing. How is it working.???
--
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
http://www.excel-formulas.com/sample-question/Password-Protect-Particular-Column-or-Row-in-Excel
On Friday, December 5, 2014 12:08:06 PM UTC+5:30, Putta Madaiah wrote:
Hi Friends,
How to protect only few cells with a password where users should not be
able to update anything in a shared
with a delimiter. here the point is how
the increment is going on.
*MsgBox Join(arrColor, ) *
On Friday, December 5, 2014 11:44:59 AM UTC+5:30, Mandeep Baluja wrote:
Function F_concatenaterow_snb(c01)
F_concatenaterow_snb = Join(Application.Index(c01.Value,1,0), |)
End Function
Can I get that file with the result
On Saturday, December 6, 2014 12:06:42 AM UTC+5:30, Paul Schreiner wrote:
I have a worksheet template in which I display a 3-digit Product Code.
I have a hidden worksheet that has a list of Product Codes and
corresponding product names like:
Code Product
Kindly find the solution
Regards,
Mandeep Baluja
LearningZmyPassion
https://www.linkedin.com/profile/view?id=312532939
https://www.facebook.com/VBAEXCELSQL?ref=hl
On Saturday, December 6, 2014 9:14:25 AM UTC+5:30, Ashish_Bhalara wrote:
Dear experts,
I need function to receive data
I have a question check this sheet. first shape is copied from some file
and other one is created by me. I want to know that while selecting first
one cursor is showing inside the shape and not on the second one while
selecting. basically I can't create that kind of shape which can take text
I want a Udf or macro to concatenate a range with two special criteria.
First:- in Range it select only visible cells
Second :- remove duplicates.
Kindly don't provide me any website as I have checked numerous of codes but
no code is achieving this combined result.
Regards,
Mandeep Baluja
MADE FOR MYSELF, NO NEED TO REPLY
:)
On Wednesday, December 10, 2014 10:53:31 AM UTC+5:30, Mandeep Baluja wrote:
I want a Udf or macro to concatenate a range with two special criteria.
First:- in Range it select only visible cells
Second :- remove duplicates.
Kindly don't provide me any
this out hope you will convert this in udf .
On Wednesday, December 10, 2014 10:53:31 AM UTC+5:30, Mandeep Baluja wrote:
I want a Udf or macro to concatenate a range with two special criteria.
First:- in Range it select only visible cells
Second :- remove duplicates.
Kindly don't provide me
StrComp function through which assembly or references I can use this
function in vba.
Regards,
Mandeep Baluja
LearningZmyPassion
https://www.linkedin.com/profile/view?id=312532939
https://www.facebook.com/VBAEXCELSQL?ref=hl
--
Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you
'Most of the people have asked this simple question that what is the
difference between activate and select method.
'Lets Start describing this
'Try this
'Range(A1:A10).Select
'Range(a3).Activate
'Your range will selected but the activecell is A3
'Activates a single cell, which must be inside
1 - 100 of 454 matches
Mail list logo