data
of file making this slowing down of macro code.
Third avoid application.screenupdating = true always keep it false to avoid
flickering.
Regards,
Mandeep Baluja
LearningZmyPassion
https://www.linkedin.com/profile/view?id=312532939
https://www.facebook.com/VBAEXCELSQL?ref=hl
On Thursday
Hey paul i really love the way of your coding.
Regards,
Mandeep Baluja
LearningZmyPassion
https://www.linkedin.com/profile/view?id=312532939
https://www.facebook.com/VBAEXCELSQL?ref=hl
On Thursday, November 27, 2014 2:57:09 PM UTC+5:30, shrini wrote:
Dear All
Please find below macro
Hey paul,
Thanks for reply I have highlighted number of *Dates *not days. I want
number of dates between two dates.
Like Start date
12/12/2014
end date
12/22/2014
Formula should return 13/12/2014
14/12/2014
15/12/2014
16/12/2014
17/12/2014
Want to retrieve this. I have an idea indirect
/12/2014
On Friday, December 12, 2014 6:23:45 PM UTC+5:30, Pol Ktk wrote:
Sir,
Check this
[image: Inline image 1]
On Fri, Dec 12, 2014 at 6:07 PM, Mandeep Baluja rocke...@gmail.com
javascript: wrote:
Hey paul,
Thanks for reply I have highlighted number of *Dates *not days
Thanks Paul and xls Yes this is the alternate method I have seen and it is
achieved with your formula.
On Friday, December 12, 2014 5:48:05 PM UTC+5:30, Mandeep Baluja wrote:
Just for knowledge can we get the number *Dates* between two dates. I am
trying to achieve with array. I saw
) Correct 1 Column
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 wanna be? It’s
=TIME(2,DO:IT,N:OW) ! Join official Facebook page
]
arr
= Application.Transpose(Range(A1:A10)) [image: Screen Clipping]
On Saturday, December 13, 2014 3:27:26 PM UTC+5:30, Mandeep Baluja wrote:
This Question is related to array before answering please
the range is not a range/something else.
On Saturday, December 13, 2014 3:27:26 PM UTC+5:30, Mandeep Baluja wrote:
This Question is related to array before answering please check my file
and see what I want to Clear it's not a query it's a concept.
I am trying to find out
Arr
+5:30, Mandeep Baluja wrote:
This Question is related to array before answering please check my file
and see what I want to Clear it's not a query it's a concept.
I am trying to find out
Arr = Application.Transpose(Range(A1:A10))
How array is considering this range whether in rows
. but for the
rest if the range consist of other column it works correctly .
On Saturday, December 13, 2014 3:27:26 PM UTC+5:30, Mandeep Baluja wrote:
This Question is related to array before answering please check my file
and see what I want to Clear it's not a query it's a concept.
I am trying to find
moved to one dimension. (1 to 5).
On Saturday, December 13, 2014 3:27:26 PM UTC+5:30, Mandeep Baluja wrote:
This Question is related to array before answering please check my file
and see what I want to Clear it's not a query it's a concept.
I am trying to find out
Arr
This one I was looking to Confirm from you experts. :) that it gets
transposes to *array format * hence you get 1D array Thankss
On Saturday, December 13, 2014 3:27:26 PM UTC+5:30, Mandeep Baluja wrote:
This Question is related to array before answering please check my file
and see what I
Check this sheet.
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 wanna be? It’s
=TIME(2,DO:IT,N:OW) ! Join official Facebook page
Kindly find the attachment
Regards,
Mandeep Baluja
LearningZmyPassion
https://www.linkedin.com/profile/view?id=312532939
https://www.facebook.com/VBAEXCELSQL?ref=hl
On Tuesday, December 16, 2014 8:20:52 AM UTC+5:30, Siraj Momin (DFU) wrote:
Dear Sir
I have an update query excel file
).Range(A1).PasteSpecial Paste:=xlPasteValues*
wb.Close False
Set wb = Nothing
Application.ScreenUpdating = True
End Sub
Regards,
Mandeep Baluja
LearningZmyPassion
https://www.linkedin.com/profile/view?id=312532939
https://www.facebook.com/VBAEXCELSQL?ref=hl
--
Are you =EXP(E:RT
wb.Sheets(sheet1).Range(B6:g6).Copy Destination:=
Workbooks(nameanddate.xlsm).Sheets(sheet1).*Range(A1)*
on the same line no need to write paste and always specify where to paste
highlighted in bold.
Regards,
Mandeep Baluja
LearningZmyPassion
https://www.linkedin.com/profile/view?id=312532939
commendable logic
On Tuesday, December 16, 2014 12:37:45 PM UTC+5:30, Haresh doley wrote:
Dear member,
i have a query on distributing total numbers to name list as like in
enclosed. sheet. Please help me out.
Name Qnty Name Distribute Qnty Formula ABC 3 ABC 1MNO 2 ABC 1
Bold doesn't mean anything I said I highlighted the thing in bold which is
require to mention
Second thing used range can work on that wb.Sheets(sheet1).UsedRange.Copy
Destination:=ThisWorkbook.Sheets(2).Range(A1)
you can use activate a cell and then paste into it.
On Tuesday, December 16,
Kindly find the solution.
Regards,
Mandeep Baluja
LearningZmyPassion
https://www.linkedin.com/profile/view?id=312532939
https://www.facebook.com/VBAEXCELSQL?ref=hl
On Tuesday, December 16, 2014 6:08:11 PM UTC+5:30, chintz wrote:
Hello Friends,
I have a lots of files(.pdf) in one
Check this sheet , you're trying to achieve this ?
Regards,
Mandeep Baluja
LearningZmyPassion
https://www.linkedin.com/profile/view?id=312532939
https://www.facebook.com/VBAEXCELSQL?ref=hl
On Thursday, December 18, 2014 5:27:30 AM UTC+5:30, Bob Engler wrote:
If columnA in sheet2 matches
check this out.
Regards,
Mandeep Baluja
LearningZmyPassion
https://www.linkedin.com/profile/view?id=312532939
https://www.facebook.com/VBAEXCELSQL?ref=hl
On Wednesday, December 17, 2014 6:30:29 PM UTC+5:30, Ashu k wrote:
Dear Seniors,
I have data in sheet 1
Name Class Roll NO. Exam
check this out.
Regards,
Mandeep Baluja
LearningZmyPassion
https://www.linkedin.com/profile/view?id=312532939
https://www.facebook.com/VBAEXCELSQL?ref=hl
On Thursday, December 18, 2014 5:27:30 AM UTC+5:30, Bob Engler wrote:
If columnA in sheet2 matches columnB in sheet1, append the data
Have you checked the Test sheet columns where I have put the new formulas.
after comparing it with your desire result i found no error ?? if yes then
confirm few things.
Comparison is going in between.
1)Columns 1 of sheet2 match with column 2 of sheet1 ? then sheet1 rows data
append with
Do one thing highlight the wrong values retrieved with the formulas it will
help us to understand your query as well.
On Thursday, December 18, 2014 5:27:30 AM UTC+5:30, Bob Engler wrote:
If columnA in sheet2 matches columnB in sheet1, append the data from the
row in sheet2 to the end of
For sure bob give me 10 minutes
On Thursday, December 18, 2014 5:27:30 AM UTC+5:30, Bob Engler wrote:
If columnA in sheet2 matches columnB in sheet1, append the data from the
row in sheet2 to the end of the row in sheet1. Sheet1 may have multiple
rows with the same column data and the data
PFA !!!
Regards,
Mandeep Baluja
LearningZmyPassion
https://www.linkedin.com/profile/view?id=312532939
https://www.facebook.com/VBAEXCELSQL?ref=hl
On Thursday, December 18, 2014 5:27:30 AM UTC+5:30, Bob Engler wrote:
If columnA in sheet2 matches columnB in sheet1, append the data from
use format painter select sheet 1 range click format painter go to sheet 3
click first cell of range. welcome
On Thursday, December 18, 2014 5:27:30 AM UTC+5:30, Bob Engler wrote:
If columnA in sheet2 matches columnB in sheet1, append the data from the
row in sheet2 to the end of the row in
Applied validation on 100 cells no error received. check this attachment.
Regards,
Mandeep Baluja
LearningZmyPassion
https://www.linkedin.com/profile/view?id=312532939
https://www.facebook.com/VBAEXCELSQL?ref=hl
On Thursday, December 18, 2014 1:58:09 PM UTC+5:30, rk sharma wrote:
Dear
reply already given send us the error snapshot.
Regards,
Mandeep Baluja
LearningZmyPassion
https://www.linkedin.com/profile/view?id=312532939
https://www.facebook.com/VBAEXCELSQL?ref=hl
On Thursday, December 18, 2014 1:58:09 PM UTC+5:30, rk sharma wrote:
Dear Experts
I received
Yes you can try
this
http://www.extendoffice.com/documents/word/508-word-lock-parts-of-document.html
Regards,
Mandeep Baluja
LearningZmyPassion
https://www.linkedin.com/profile/view?id=312532939
https://www.facebook.com/VBAEXCELSQL?ref=hl
On Thursday, December 18, 2014 11:22:57 AM UTC+5:30
This will help you PFA !! Don't delete the hide sheet.
Regards,
Mandeep Baluja
LearningZmyPassion
https://www.linkedin.com/profile/view?id=312532939
https://www.facebook.com/VBAEXCELSQL?ref=hl
On Monday, December 22, 2014 11:20:25 AM UTC+5:30, big smile wrote:
Hellow Friends 1
Open sheet 1 by 1 with the help of macro use file dilaog method to get the
names of the files and save it in xls Extension.
Regards,
Mandeep Baluja
LearningZmyPassion
https://www.linkedin.com/profile/view?id=312532939
https://www.facebook.com/VBAEXCELSQL?ref=hl
On Monday, December 22
Please explain your Query Again I an unable to understand it . Aeging can
be count but on what criteria whether on particular order no, material no ,
document no. where is availble qty column.
On Monday, December 22, 2014 9:44:49 AM UTC+5:30, kumar wrote:
Hi,
I have purchase data in a
Try this File hope it reach you expected Result.
Regards,
Mandeep Baluja
LearningZmyPassion
https://www.linkedin.com/profile/view?id=312532939
https://www.facebook.com/VBAEXCELSQL?ref=hl
On Monday, December 22, 2014 9:44:49 AM UTC+5:30, kumar wrote:
Hi,
I have purchase data
Now this macro works for 3 lakh rows you can increase the range as per your
convenience.
Regards,
Mandeep Baluja
LearningZmyPassion
https://www.linkedin.com/profile/view?id=312532939
https://www.facebook.com/VBAEXCELSQL?ref=hl
On Wednesday, December 17, 2014 6:30:29 PM UTC+5:30, Ashu k
It contains non printable characters try this method clean.
Regards,
Mandeep Baluja
LearningZmyPassion
https://www.linkedin.com/profile/view?id=312532939
https://www.facebook.com/VBAEXCELSQL?ref=hl
On Wednesday, December 24, 2014 5:20:56 PM UTC+5:30, amar takale wrote:
--
Are you =EXP
date is
TEXT(K12,dd-mm-yy),INDEX(A1:A195,MATCH(MIN(ABS($C$2:$C$195-M12)),ABS($C$2:$C$195-M12),0),0)+1))
Chk dis file.
Regards,
Mandeep Baluja
LearningZmyPassion
https://www.linkedin.com/profile/view?id=312532939
https://www.facebook.com/VBAEXCELSQL?ref=hl
On Wednesday, December 24, 2014 6:44
send file
On Friday, December 26, 2014 4:33:13 PM UTC+5:30, saravanan R wrote:
Hi Team,
I have an query on Importing text file , delimit by Seperator and make
particular column to be text, and import the same data into excel update
those data from Row 2.
thanks regards,
saravanan R
Want this result ?
Regards,
Mandeep Baluja
LearningZmyPassion
https://www.linkedin.com/profile/view?id=312532939
https://www.facebook.com/VBAEXCELSQL?ref=hl
On Friday, December 26, 2014 4:33:13 PM UTC+5:30, saravanan R wrote:
Hi Team,
I have an query on Importing text file , delimit
,
Mandeep Baluja
LearningZmyPassion
https://www.linkedin.com/profile/view?id=312532939
https://www.facebook.com/VBAEXCELSQL?ref=hl
On Saturday, December 27, 2014 11:48:23 AM UTC+5:30, sandeep chhajer wrote:
Dear Excel Gurus,
Please check the print screen attached herewith. I am getting a sheet
BackgroundQuery:=False
End With
End Sub
Try this macro.
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 wanna be? It’s
=TIME(2,DO:IT
chk dis file.
Regards,
Mandeep Baluja
LearningZmyPassion
https://www.linkedin.com/profile/view?id=312532939
https://www.facebook.com/VBAEXCELSQL?ref=hl
On Tuesday, December 23, 2014 4:46:44 PM UTC+5:30, Aparna wrote:
hi,
i have a column of around 150 different dates. i need to create
Reply already given check my file which i sent to you.
Regards,
Mandeep Baluja
LearningZmyPassion
https://www.linkedin.com/profile/view?id=312532939
https://www.facebook.com/VBAEXCELSQL?ref=hl
On Tuesday, December 23, 2014 4:46:44 PM UTC+5:30, Aparna wrote:
hi,
i have a column of around
Hope you know what is UDF. PFA for the solution it can some for any no of
colors in B column. just drag the formula in C according to your number of
cells.
Regards,
Mandeep Baluja
LearningZmyPassion
https://www.linkedin.com/profile/view?id=312532939
https://www.facebook.com/VBAEXCELSQL
,
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 wanna be? It’s
=TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @
https://www.facebook.com
This solution will work for you !!! To create a dependent drop down list
provide some unique values as all persons having the same values .This can
be achieved without dependent drop down.
Regards,
Mandeep Baluja
LearningZmyPassion
https://www.linkedin.com/profile/view?id=312532939
https
https://m.facebook.com/VBAEXCELSQL?__tn__=C
This is my page i have posted your macro on this blog top post is yours,
Copy the same and run in your sheet.
Sorry i forgot to send you the sheet.will send the same as i will be in office.
Regards,
Mandeep
--
Are you =EXP(E:RT) or =NOT(EXP(E:RT))
On Friday, January 16, 2015 at 4:04:43 PM UTC+5:30, Ashish_Bhalara wrote:
Dear experts,
Please see the attached file in which data copy to Record sheet, there are
error occur Object Require, I can't understand.
Kindly help for require out put as mention in Record sheet, also guide if
Line in your code *Acticecell.Cells(newrow, 6)*.Select is wrong it should
be Activecell. i have done some changes sheet sent to you.
Regards,
Mandeep Baluja
LearningZmyPassion
https://www.linkedin.com/profile/view?id=312532939
https://www.facebook.com/VBAEXCELSQL?ref=hl
--
Are you =EXP
send us the File
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 wanna be? It’s
=TIME(2,DO:IT,N:OW) ! Join official Facebook page
,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 wanna be? It’s
=TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @
https://www.facebook.com
My pleasure.
Regards,
Mandeep baluja
On Wednesday, 18 February 2015 12:55:31 UTC+5:30, Pravin Gunjal wrote:
Thank you so much.
This is what I was looking for...
On Tue, Feb 17, 2015 at 10:31 AM, Mandeep Baluja rocke...@gmail.com
javascript: wrote:
check this worksheet event
awesome looping thanks :) i will apply it on a huge data by changing the
parametres.
On Tuesday, 17 February 2015 16:10:37 UTC+5:30, Mandeep Baluja wrote:
help required !!
--
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
,If not possible atleast derive a click on this button. But how???
beacause name is not working as mention selected code.
*input class=selectedCode radio_type name=selectedCode
value=OC_GATI_BANGALOR type=radio id=2*
*Regards, *
*Mandeep baluja *
--
Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do
:
This works withe me..
IE.document.getElementsByName(selectedCode).Item(0).Checked = True
Cheers!!
On Fri, Feb 13, 2015 at 1:50 PM, Vaibhav Joshi v...@vabs.in javascript:
wrote:
can you share webpage url where you are performing this?
On Fri, Feb 13, 2015 at 1:06 AM, Mandeep Baluja rocke
As Object
Set hEle = IE.document.getElementsByName(selectedCode)
For Each btn In hEle
If btn.Value = OC_GATI_CHENNAI_ Then
btn.Click
Exit For
End If
Next
Cheers!!
On Fri, Feb 13, 2015 at 2:45 PM, Mandeep Baluja rocke...@gmail.com
javascript: wrote:
hey vabz, as i
help required !!
--
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,
check this worksheet event.
regards,
Mandeep
On Monday, February 16, 2015 at 7:49:23 PM UTC+5:30, Pravin Gunjal wrote:
Hi Mr Paul
The user name of excel to be come automatically in column L, once column
K is entered by the user.
I have given few names in column L as an example, which
Copy and drag the formula to get the result.
Regards,
Mandeep Baluja
On Wednesday, 18 February 2015 14:48:14 UTC+5:30, Amit Desai (MERU) wrote:
Dear Friends,
Please help me getting the data in a cell move to relevant columns. I have
Attached sample file for the same.
Best
Try this.
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 wanna be? It’s
=TIME(2,DO:IT,N:OW) ! Join official Facebook page
Send your sheet and the result expected.
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 wanna be? It’s
=TIME(2,DO:IT,N:OW) ! Join
Amazing Code Bro !!
On Wednesday, December 17, 2014 6:30:29 PM UTC+5:30, Ashu k wrote:
Dear Seniors,
I have data in sheet 1
Name Class Roll NO. Exam Date
and,
I have data in Sheet 2
Name Class Roll No. Exam Date
But some Names are not in Name Column and Some Class are not
.
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 wanna be? It’s
=TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @
https
from internet or
various websites which are text. *
*Regards,Mandeep
Baluja
LearningZmyPassionhttps://www.linkedin.com/profile/view?id=312532939https://www.facebook.com/VBAEXCELSQL?ref=hl
*
--
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
Done !!
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 wanna be? It’s
=TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum
Do these changes.
'First where the result you're are printing which is D8 should not come in
the Workrng. Get the result at some other location.
Range(D8).Select
Divide the result by total columns
Selection.FormulaR1C1 = countErr / Range(A1:H6930).Columns.Count
Regards,
Mandeep Baluja
how to click this
*input value=Sign in class=button type=submit button i tried many
thing but unsuccesful.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 @
Absolutely correct but i was using form 1 that's why it is giving error
could you please let me know why 0 is used. for form.
On Wednesday, February 11, 2015 at 10:20:23 AM UTC+5:30, Mandeep Baluja
wrote:
how to click this
*input value=Sign in class=button type=submit button i tried
, Mandeep Baluja rocke...@gmail.com
javascript: wrote:
Tried this code earlier not working ,may be python will be used to
achieve this.
input class=selectedCode radio_type name=selectedCode
value=OC_GATI_CHENNAI_ type=radio id=1
On Friday, February 13, 2015 at 4:58:02 PM UTC+5:30
Clear few things,
1.What is busy hour do you want that for first entry busy hour is 21 means
9 pm or anything else and then check whether it is in between start time
and end time. and getting result for serving cell.
2.what is Peging
Regards,
Mandeep Baluja
LearningZmyPassion
https
Try this ..
Regards,
MandeepBaluja
Learningzmypassion.
https://www.facebook.com/VBAEXCELSQL?ref=hl
https://www.linkedin.com/profile/view?id=312532939
On Wednesday, 18 March 2015 16:59:17 UTC+5:30, saravanan R wrote:
Hello Team,
I have an Query regarding Duplicate check for certain Criteria
Try to create a formula but the main problem is to understand your query ,
IF(A2=AED,B2,VLOOKUP(Question!A2,'Master
Sheet'!$A$3:$EC$8,MATCH($B$2,'Master Sheet'!$B$1:$EC$1,0)+1,0))
Clear one thing how the values are coming for rest of the i didn't found
any JOD ,LPB in master even KWD values
Run this code in your data
Sub Test()
With Application
.ScreenUpdating = False
.DisplayAlerts = False
End With
Dim lr As Long
lr = ActiveSheet.Cells(Rows.Count, 3).End(xlUp).Row
Set Rng = Range(C1:C lr)
Debug.Print Rng.Address
For Each Cell In Rng
If Left(Cell.Value, 5) = Estab Then
estab =
On Monday, 16 March 2015 17:50:49 UTC+5:30, Vabz wrote:
Hi Mandeep,
Logic used in macro is rilli cool...
Cheers!!
On Mon, Mar 16, 2015 at 1:46 PM, Mandeep baluja mandee...@gmail.com
javascript: wrote:
Check the *result sheet* in the attachment . for single single row this
formula will work
Try this code it will help as per your requirement , if you are using your
own code use this line pf.CurrentPage = W001
Sub Create_pivot()
Dim pt As PivotTable
Dim pf As PivotField
Dim rng As Range
Set rng = ActiveSheet.UsedRange
ActiveSheet.Range(A1).Select
Set pt =
Check this attachment achieved with a macro. Change your numbers
combination as per your requirement.
Regards,
MandeepBaluja
Learningzmypassion.
https://www.facebook.com/VBAEXCELSQL?ref=hl
https://www.linkedin.com/profile/view?id=312532939
On Sunday, 15 March 2015 23:04:26 UTC+5:30, Will
PFA !!!
Regards,
MandeepBaluja
Learningzmypassion.
https://www.facebook.com/VBAEXCELSQL?ref=hl
https://www.linkedin.com/profile/view?id=312532939
On Wednesday, 17 December 2014 18:30:29 UTC+5:30, Ashu k wrote:
Dear Seniors,
I have data in sheet 1
Name Class Roll NO. Exam Date
send me the values which you are trying to get
On Monday, March 16, 2015 at 3:24:40 AM UTC+5:30, Will Sob wrote:
thanks but it is not working when l use other values
On Sun, Mar 15, 2015 at 7:11 PM, Mandeep baluja mandee...@gmail.com
javascript: wrote:
Check this attachment achieved
in this attachment did you enabled this library in refrences go to vba
editior enalble these library and then go to sheet1 and click the button
send mails .
microsoft outlook 14.0 object library
ole auotmation
microsoft excel 14.0 object library
visual basic for applications
microsoft forms
javascript:] *On Behalf Of *Mandeep baluja
*Sent:* Monday, March 16, 2015 4:48 AM
*To:* excel-...@googlegroups.com javascript:
*Subject:* $$Excel-Macros$$ Re: vba recorded macro not working
Run this code in your data
Sub Test()
With Application
.ScreenUpdating = False
.DisplayAlerts
remove option explicity statement which is in first line of your code, as
this code working perfecctly on my pc , Please send me the line number of
error.
On Wednesday, 17 December 2014 18:30:29 UTC+5:30, Ashu k wrote:
Dear Seniors,
I have data in sheet 1
Name Class Roll NO. Exam
any other code ?? excep this one
For Each rngarea In .SpecialCells(xlCellTypeVisible).Areas
lcount = lcount + rngarea.Rows.Count
Next
--
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
_
), Operator:=xlFilterValues
On Saturday, 21 March 2015 18:48:58 UTC+5:30, Eugene Bernard wrote:
Hi Mandeep,
Just check the attached example.
Regards
Eugene
On Fri, Mar 20, 2015 at 11:59 PM, Mandeep Baluja rocke...@gmail.com
javascript: wrote:
Hey Eugene,,not easy as you're
:
The below code already given in this group by Mr Asish Kumar
start= ActiveSheet.UsedRange.Offset(1).SpecialCells(xlCellTypeVisible).Row
end= ActiveSheet.UsedRange.SpecialCells(xlCellTypeLastCell).Row
norows=end-start+1
Regards
Eugene
On Thu, Mar 19, 2015 at 12:56 PM, Mandeep baluja
, Mandeep Baluja rocke...@gmail.com
javascript: wrote:
send me the values which you are trying to get
On Monday, March 16, 2015 at 3:24:40 AM UTC+5:30, Will Sob wrote:
thanks but it is not working when l use other values
On Sun, Mar 15, 2015 at 7:11 PM, Mandeep baluja mandee...@gmail.com
wrote
Check the *result sheet* in the attachment . for single single row this
formula will work with helper column.
On Saturday, 14 March 2015 15:06:13 UTC+5:30, Will Sob wrote:
Hi,
Please I need help with the attached file. I want a formula that
calculates how many times (10, 13, 17)
Quuery for autofit
--
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,
me know if I am missing something.
Regards
Gaurav Devrani
On Thu, Mar 12, 2015 at 1:43 PM, Mandeep baluja mandee...@gmail.com
javascript: wrote:
Quuery for autofit
--
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
Hello mike, Please find the attached file as per your requirement. Always
send your requirement output in excel file.
Regards,
Mandeep Baluja
On Saturday, March 7, 2015 at 7:33:44 AM UTC+5:30, Mike B wrote:
*12/11/2014 5:15**12/11/2014 5:15*CGT 01*12/11/2014
5:15*CGT 02
it's so easy paste this code in module. i have highlighted the line in bold
where change is done. Remember one thing once these lines will be deleted
it can traverse back.
Sub Test()
With Application
.ScreenUpdating = False
.DisplayAlerts = False
End With
Dim lr As Long
lr =
Replace double -- with single - and then text to columns.
On Monday, March 30, 2015 at 3:07:58 AM UTC+5:30, Bill Q wrote:
Attached is a very small sample of a much larger data set. I need to
separate the data - in this case in 3 different and separate columns. For
whatever reason there is
send the attachment and output required in sheet.
On Monday, March 30, 2015 at 11:16:34 AM UTC+5:30, மதுர மதுர wrote:
Good Day Friends..
I need to retrieve certain set of data from multiple worksheets and
workbooks in a single worksheet. I appreciate if anyone help to set VBA
dont type -- manually just copy it and replace otherwise replace will not
work.
On Tuesday, March 31, 2015 at 12:22:54 AM UTC+5:30, Bill Q wrote:
Thanks, but I must be doing something wrong - becuase it isn;t working for
me.
On Sunday, 29 March 2015 17:37:58 UTC-4, Bill Q wrote:
Copy your double code in replace box don't type it it will get easily
replaced.
On Tuesday, March 31, 2015 at 12:22:54 AM UTC+5:30, Bill Q wrote:
Thanks, but I must be doing something wrong - becuase it isn;t working for
me.
On Sunday, 29 March 2015 17:37:58 UTC-4, Bill Q wrote:
Try this file !!!
Regards,
Mandeep baluja
On Tuesday, March 31, 2015 at 7:53:09 AM UTC+5:30, Bob Engler wrote
satendra max cannot be used here until you can create a array formula with
some logic. syntax of your max function is wrong. .
On Friday, March 27, 2015 at 11:29:10 AM UTC+5:30, Satendra kumar wrote:
Hi Amit,
Find below formula for result second highest value.
=max(renge,2)
thanks
did you tried the reply given to you.
On Friday, March 27, 2015 at 11:24:09 AM UTC+5:30, Mandeep Baluja wrote:
you can use large function to do that.
=large(range,2)
On Friday, March 27, 2015 at 11:09:28 AM UTC+5:30, Amit Desai (MERU) wrote:
Dear Friends,
Please let me know
=SUMPRODUCT((E3=$J$3:$J$11)*(E3=$K$3:$K$11)*($L$3:$L$11))
Copy this formula in g3 press control +shift+ enter
Regards,
Mandeep
On Friday, March 27, 2015 at 11:41:15 AM UTC+5:30, kasper wrote:
Hi Experts
please check the attached table , there i have to select a value from one
table to
put this formula in h2 it will give you large from alternate columns
=LARGE(IF(MOD(COLUMN(A2:G2),2)0,A2:G2),2)
Press control+ shift +enter to create array formula.
Regards,
Mandeep
On Friday, March 27, 2015 at 11:41:11 AM UTC+5:30, Amit Desai (MERU) wrote:
Sorry, I have one more
you can use large function to do that.
=large(range,2)
On Friday, March 27, 2015 at 11:09:28 AM UTC+5:30, Amit Desai (MERU) wrote:
Dear Friends,
Please let me know if I want to find second highest value from a data
range how shall I do that?
Please let me know what
101 - 200 of 454 matches
Mail list logo
