without
using large function not sheet function and not vba function.
Take the range(a1:a15) and make the logic there.
Pramod
On 27 Mar 2015 11:41, Mandeep Baluja rocke...@gmail.com javascript:
wrote:
did you tried the reply given to you.
On Friday, March 27, 2015 at 11:24:09 AM UTC+5:30
not possible without vba i have prepared vba solution check dis out.
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 RULES
1) Use
check this there are many method but i am using this.
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
FORUM RULES
1) Use concise
giving correct results which is going in g7 and g8 what else do you want
Sub test()
ThisWorkbook.Activate
mynum = dw*
Cells(1, 25).Value = (mynum)
ActiveSheet.ListObjects(Table1).Range.AutoFilter Field:=1,
Criteria1:=mynum
lr = ActiveSheet.Cells(Rows.Count, 1).End(xlUp).Row
For i = 2 To lr
If
Check this result with the help of helper column . in case you want the
approximate match remove roundup function from formula and set vlookup to
approximate match set it to 1. .\
Regards,
Mandeep
On Thursday, 26 February 2015 14:34:17 UTC+5:30, Deepak Rawat wrote:
Hi,
I have some
-...@googlegroups.com javascript:] *On Behalf Of *Mandeep baluja
*Sent:* Monday, March 16, 2015 11:35 PM
*To:* excel-...@googlegroups.com javascript:
*Subject:* Re: $$Excel-Macros$$ Re: vba recorded macro not working
Dear Mike,
Thank u so much for your Appreciation. It's a pleasure
send me your file and steps you want to achieve
Regards,
Mandeep
On Thursday, March 5, 2015 at 9:46:12 PM UTC+5:30, Mike B wrote:
I try it works but goes back to what I just did even though I moved my
cursor down 11 rows. I would appreciate any help how to get it to advance
to the next
Dear Check this file ;)
Regards,
Mandeep
On Thursday, March 5, 2015 at 8:39:29 PM UTC+5:30, Prabhu Pinky wrote:
Hi experts,
I have around 10-15 excel file in a folder and updated every week.
I need macro in master file which will open each file from folder and copy
in master file.
Put this in your code before end keyword.
ActiveWorkbook.Worksheets(Consolidate).UsedRange.Sort
key1:=ActiveWorkbook.Worksheets(Consolidate).Range(b:b),
order1:=xlAscending, Header:=xlYes
On Tuesday, April 14, 2015 at 11:23:35 AM UTC+5:30, TAWHID wrote:
Hi Vaibhav,
I was
Wondering , If
unmerge your cells and Fill it down to create a helper and use this formula.
Regards,
Mandeep Baluja
On Tuesday, April 14, 2015 at 2:21:19 PM UTC+5:30, Chandru wrote:
Hello,
PFA file and am trying to get counts based on merged cells. I have given
comments in Column G. Could you help me
You can use inputbox to copy a range or a header, clear your quesiton by
putting data in output sheet2.so that we can understand what need to be
copy.
On Thursday, April 30, 2015 at 2:09:48 PM UTC+5:30, hilary lomotey wrote:
Hello Bosses,
i have this code am using to copy Dates from
check this out code given
Regards,
Mandeep Baluja
On Monday, April 27, 2015 at 12:42:08 PM UTC+5:30, sk.yadav7186 wrote:
hi...pls any revert
--
Thanks Regards
*Sunil Kumar Yadav*
Skype ID: sunil.yadav7186
On Sat, Apr 25, 2015 at 3:10 PM, Sunil Kumar Yadav sk.yad...@gmail.com
check this !!
Regards,
Mandeep
https://www.linkedin.com/profile/public-profile-settings?trk=prof-edit-edit-public_profile
On Monday, April 27, 2015 at 12:42:08 PM UTC+5:30, sk.yadav7186 wrote:
hi...pls any revert
--
Thanks Regards
*Sunil Kumar Yadav*
Skype ID: sunil.yadav7186
On
change activesheet to Sheets(sheet1)
On Monday, April 27, 2015 at 5:41:00 PM UTC+5:30, Mandeep Baluja wrote:
Sub Getvalues()
Dim r As Range
lr = ActiveSheet.Cells(Rows.Count, 2).End(xlUp).Row
Set Rng = ActiveSheet.Range(B2:B lr)
For Each cell In Rng
If cell.Value Like *LF
...@gmail.com
javascript: wrote:
Thank u so much
it's working as per my requirement :-)
--
Thanks Regards
*Sunil Kumar Yadav*
Skype ID: sunil.yadav7186
On Mon, Apr 27, 2015 at 3:12 PM, Mandeep Baluja rocke...@gmail.com
javascript: wrote:
check this out code given
Regards,
Mandeep
End Sub
Regards,
Mandeep Baluja
Snapdeal.com
https://www.linkedin.com/profile/view?id=312532939
On Saturday, May 2, 2015 at 1:12:28 AM UTC+5:30, Mike B wrote:
I would like to copy this for each location and paste in front inventory
numbers in Column A(some begin with letters
Last line edited :) Now this will handle your requriement
Sub Test()
With Application
.ScreenUpdating = False
.DisplayAlerts = False
End With
Dim lr As Long
lr = ActiveSheet.Cells(Rows.Count, 2).End(xlUp).Row
Set Rng = Range(b1:b lr)
Debug.Print Rng.Address
For Each cell In Rng
If
on same machine or they are on Network?
On Tue, Apr 28, 2015 at 11:34 AM, Mandeep Baluja rocke...@gmail.com
javascript: wrote:
My mmaster file is large and i just want to do lookup on my sheet from
master file without opening my master file as it is of huge mb around 250
mb or more than
My mmaster file is large and i just want to do lookup on my sheet from
master file without opening my master file as it is of huge mb around 250
mb or more than that. any ideas
--
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
Yes it works, Thanks for the same we can considered this issue is resolved.
But one thing Excel is not useful for large files On Daily basis I got
files of 350 mb having data of 2-3 lakh rows and I am unable to combine the
same jjust because excel not responds.
On Tuesday, April 28, 2015 at
.
--
Thanks Regards
*Sunil Kumar Yadav*
Skype ID: sunil.yadav7186
On Mon, Apr 27, 2015 at 5:41 PM, Mandeep Baluja rocke...@gmail.com
javascript: wrote:
change activesheet to Sheets(sheet1)
On Monday, April 27, 2015 at 5:41:00 PM UTC+5:30, Mandeep Baluja wrote:
Sub Getvalues()
Dim r As Range
what F2 i didn;t get you
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 RULES
1) Use concise, accurate thread titles.
Fax 01912477442
Mobile +91 9906115140
rakesh.kum...@ericsson.com javascript:
www.ericsson.com
“If You fall, fall like a seed to germinate, not like a leaf to die.”
On Wed, May 6, 2015 at 12:13 PM, Mandeep Baluja rocke...@gmail.com
javascript: wrote:
Select b3:m5 press f5 - click
Glad to help :)
Regards,
Mandeep Baluja
Email :-mandeep.bal...@snapdeal.com
mandeep.bal...@gmail.com
https://in.linkedin.com/pub/mandeep-baluja/88/7bb/b77
https://www.facebook.com/groups/825221420889809/
On Wednesday, May 6, 2015 at 12:28:39 PM UTC+5:30, rk sharma wrote:
Thanks alot Mandeep
:
Hi Mandeep,
I want to unmerge the rows nos 1,15,25,31,43,113,126,193,200
This may increase or decrease in my upcoming month excel hence i want to
continue merge all the header rows as much as the headers.
Thanks
N.Sundarvelan
9600160150
On Wed, May 6, 2015 at 12:06 PM, Mandeep Baluja
what is the error you are getting give me the snapshot.
On Wednesday, May 6, 2015 at 6:44:12 AM UTC+5:30, Sundarvelan wrote:
Thanks Mandeep,
But the given solution is not working.
Thanks
N.Sundarvelan
9600160150
On Tue, May 5, 2015 at 4:16 PM, Mandeep Baluja rocke...@gmail.com
.
When i apply your macro it doesn't work.
Thanks
N.Sundarvelan
9600160150
On Wed, May 6, 2015 at 10:02 AM, Mandeep Baluja rocke...@gmail.com
javascript: wrote:
what is the error you are getting give me the snapshot.
On Wednesday, May 6, 2015 at 6:44:12 AM UTC+5:30, Sundarvelan wrote
Select b3:m5 press f5 - click special option-tick blank-go into home
tab delete cells and shift cells left you will get your data.
Regards,
Mandeep Baluja
Email :-mandeep.bal...@snapdeal.com
mandeep.bal...@gmail.com
https://in.linkedin.com/pub/mandeep-baluja/88/7bb/b77
https
how is your sheet data.??? it contain a single column or multiple columns ??
On Wednesday, May 6, 2015 at 11:11:10 PM UTC+5:30, Chethan wrote:
Hi,
I need some help in modify the Macro. Current it combine multiple sheet in
one column. I need to copy each sheet to one column,
Like
Microsoft Excel uses the tilde (~) as a marker to indicate that the next
character is a literal. When you use the *Find and Replace*dialog box to
find or replace a character such as a tilde (~), an asterisk (*), or a
question mark (?), you must add a tilde (~) before the character in the *Find
Baluja
Email :-mandeep.bal...@snapdeal.com
mandeep.bal...@gmail.com
https://in.linkedin.com/pub/mandeep-baluja/88/7bb/b77
https://www.facebook.com/groups/825221420889809/
On Friday, May 8, 2015 at 12:42:30 PM UTC+5:30, Chethan wrote:
Respected sir,
I am using the following code
file is locked and even it seems to me that there is data validation
control present in those cells.
Check this Out.
Regards,
Mandeep Baluja
Email :-mandeep.bal...@snapdeal.com
mandeep.bal...@gmail.com
https://in.linkedin.com/pub/mandeep-baluja/88/7bb/b77
https://www.facebook.com/groups
Check this Out.
Regards,
Mandeep Baluja
Email :-mandeep.bal...@snapdeal.com
mandeep.bal...@gmail.com
https://in.linkedin.com/pub/mandeep-baluja/88/7bb/b77
https://www.facebook.com/groups/825221420889809/
On Saturday, May 2, 2015 at 12:52:24 PM UTC+5:30, Zafar Iqbal wrote:
Dear
All the best :) glad to help you.
Regards,
Mandeep Baluja
Email :-mandeep.bal...@snapdeal.com
mandeep.bal...@gmail.com
https://in.linkedin.com/pub/mandeep-baluja/88/7bb/b77
On Sunday, May 3, 2015 at 5:49:06 PM UTC+5:30, Mike B wrote:
Hi Mandeep,
Thank you very, very much your code
Rng.Offset(0, 1) = X
Rng.EntireRow.UnMerge
Set Rng = .FindNext(Rng)
Loop While Not Rng Is Nothing And Rng.Address FirstAddress
End If
End With
'
End Sub
Check this Out.
Regards,
Mandeep Baluja
Email :-mandeep.bal...@snapdeal.com
mandeep.bal...@gmail.com
https://in.linkedin.com/pub/mandeep
Dependent drop down list will be used to create there will be a no of
possible combination which depend on previous column value, I have sent the
same code earlier, you should search.
Regards,
Mandeep baluja
On Wednesday, May 13, 2015 at 3:46:14 PM UTC+5:30, rk sharma wrote:
Dear Nasir
Select cell go to Text to columns then use delimeter then select
underscore and then finish, you text will split into respective columns as
you require.
Regards,
Mandeep Baluja
On Tuesday, May 12, 2015 at 9:47:11 PM UTC+5:30, Nur wrote:
Dear all , I am having a text strings which
you should
use Sheet(Name).range(A1:A100) instead of Only Range and send me the
snapshot of error.
Regards,
Mandeep baluja
On Monday, May 18, 2015 at 4:31:22 PM UTC+5:30, Nitin Balodi wrote:
Hi Champs,
I am getting error in copying filetered cells. Below is the code snippet.
Point
Do you want to Create separate sheets on the basis of column.???
Regards,
Mandeep baluja
On Monday, May 18, 2015 at 1:42:30 PM UTC+5:30, Nasir Saikh wrote:
Hi Experts,
I want to split table from main table with their names available in column
For example.
I have a database
Can we have the sheet ???
On Monday, May 18, 2015 at 12:27:13 PM UTC+5:30, sswcharlie wrote:
Hi
XL2000
Have searched for this with no luck.
Have a column with figures entered by user and also some sub-totals as a
result of formula.
How do I have a formula to add all the entered
total of
E11:E220
Thanks
Charles
On Monday, May 18, 2015 at 7:05:40 PM UTC+12, Mandeep Baluja wrote:
Can we have the sheet ???
On Monday, May 18, 2015 at 12:27:13 PM UTC+5:30, sswcharlie wrote:
Hi
XL2000
Have searched for this with no luck.
Have a column with figures entered
On the button click create a new workbook and copy your data save your
workbook with .csv extension with the help of VBA code.
Regards,
Mandeep Baluja
On Tuesday, May 19, 2015 at 10:13:44 AM UTC+5:30, Ahmed Bayagon wrote:
Hello Guys,
I am trying to create a Button on Sheet1 named
check the attached macro
Sub Macro1()
Dim sht As Worksheet
For Each sht In ActiveWorkbook.Sheets
If sht.Name ActiveSheet.Name Then
sht.Activate
Union(Columns(1), Columns(3), Columns(5)).Copy
Set wb = Workbooks.Add
wb.Sheets(1).Paste
wb.SaveAs Filename:=C:\Users\Mandeep.baluja\Desktop\k.csv
Use this code basically it use the Autofilter technique to create sheets
and use of collection class to remove the duplicates.
Sub Macro60()
'Step 1: Declare your Variables
Dim MySheet As Worksheet
Dim MyRange As Range
Dim UList As Collection
Dim UListValue As Variant
Dim
Miscellaneous
Regards,
Mandeep baluja
On Monday, May 18, 2015 at 1:42:30 PM UTC+5:30, Nasir Saikh wrote:
Hi Experts,
I want to split table from main table with their names available in column
For example.
I have a database in the database name available A,B,C,D,E only then the
data
...@gmail.com
javascript: wrote:
Thanks Mandeep!!!
Thanks
N.Sundarvelan
9600160150
On Mon, May 18, 2015 at 11:21 AM, Mandeep Baluja rocke...@gmail.com
javascript: wrote:
Go to file option Click on open then export it to excel , you can export
any folder to a excel file.
Regards
Assign sheet names while defining a range to be copied. means you should
use Sheet(Name).range(A1:A100) instead of Only Range and send me the
snapshot of error.
Regards,
Mandeep baluja
On Monday, May 18, 2015 at 4:31:22 PM UTC+5:30, Nitin Balodi wrote:
Hi Champs,
I am getting error
chk dis out.
Regards,
Mandeep Baluja
On Thursday, April 16, 2015 at 5:52:30 PM UTC+5:30, sonu wrote:
Experts,
I want to convert file name in Excel .
for example I have 100 files in folder and I want to convert all file name
in excel.
please support.
--
J.Gaurav
Call-7838594954
Do you want to copy the results again and again after the result,and do not
want to replace the existing result..
On Thursday, April 9, 2015 at 6:37:11 AM UTC+5:30, modi89 wrote:
Group, please replace 'house1' with 'Red apples' and 'house2' with 'Green
apples'
On Wednesday, April 8, 2015
Want this ???
Regards,
Mandeep Baluja
Snapdeal.com
On Thursday, April 9, 2015 at 5:16:15 PM UTC+5:30, Rakesh kumar wrote:
Hi,
I want to put Avarage formulla with multiple conditions in same column.
Please see the attechment and put the formulla
Please do it on urgent basis
Check this out,
Want this result ??
Regards,
Mandeep baluja
Snapdeal.com
On Thursday, April 9, 2015 at 12:30:21 PM UTC+5:30, Vijayendra wrote:
Dear Experts,
Can you please help me to put vlookup or IndexMatch formula for multiple
column. Attached is the excel workbook.
--
ಧನ್ಯವಾದಗಳು
Check this out.
Regards,
MandeepBaluja
Learningzmypassion.
https://www.facebook.com/VBAEXCELSQL?ref=hl
https://www.linkedin.com/profile/view?id=312532939
On Thursday, April 9, 2015 at 2:45:14 PM UTC+5:30, Nirman Singha wrote:
Hello
I am facing a problem regarding linking to excel
use checkbox form control present in developer tap. assign the control to
a cell and you can get boolean values on your sheet.
Regards,
Mandeep Baluja
On Monday, April 13, 2015 at 12:32:14 PM UTC+5:30, Dhaval Shah wrote:
if i tick then wanna Yes and no tick then No
Warm Regards
it is giving correct result. please cross check again. as I checked
combining only APU NSC LOKI JUBA
On Monday, April 13, 2015 at 12:14:55 AM UTC+5:30, TAWHID wrote:
If you see at the bottom, It's adding all others sheets too. (Read Me,
test 1, test 2 ect are being added at the bottom.
cHANGE THIS LINE IN YOUR CODE BUT PLEASE DON'T CHANGE YOUR CRITERIA AGAIN
AND AGAIN FIRST IT WAS NAMED AS LOCATION , THEN YOU CHANGED IT TO TEST ,IF
YOU ARE CHANGING YOUR SHEET NEED YOU NEED TO CHANGE THAT IN YOUR CODE TOO
BRO.
If ws.Name Consolidate And ws.Name Read Me And ws.Name test
1
Welcome bro
Regards,
Mandeep
On Monday, April 13, 2015 at 9:32:10 PM UTC+5:30, sagarmitra75 wrote:
Hi everyone,
This is Sagar from Kolkata. I am a stock dealer , looking for a
financial analyst’s job. I have only basic knowledge of Excel and VBA
, and this forum appears to be
It's already working bro what is required now ???
On Sunday, April 12, 2015 at 9:40:24 PM UTC+5:30, TAWHID wrote:
Dear Experts,
Still I am straggling to finish it up.
I just want to consolidate Sheets ( APU, NSC, LOKI, JUBA) these four
sheets.
Any help please?
On Friday, 10
check this out. the value which is blank does not go into the bucket you
have set.
Regards,
Mandeep Baluja
On Wednesday, April 15, 2015 at 2:21:15 PM UTC+5:30, dinoabeer wrote:
Dear Experts,
I have been trying to figure out a way to populate the row D9 to AM9 based
on the table
check this file.
Regards,
Mandeep Baluja
On Saturday, April 4, 2015 at 4:46:52 PM UTC+5:30, SridharBL wrote:
Hi Experts!!,
I have task to save the dataentry done in one sheet to be saved in other
sheet.
In the attached file. Sheet Data Entry is where the data entry will
happen
what is the name of your application from which you're retrieving your data.
On Saturday, March 28, 2015 at 9:14:11 PM UTC+5:30, Avinash wrote:
Hi Experts,
i want a macro which can copy data from another application to excel.
below is the code which i am trying to use. i dont have any
Retreived by sumproduct and vlookup check this out.
Regards,
Mandeep Baluja
Learningzmypassion
On Sunday, April 5, 2015 at 5:47:05 PM UTC+5:30, Ashish_Bhalara wrote:
Dear experts,
Kindly see attached file in which I make formula in yellow cell that is if
match particular task
Want this ?
Regards,
MandeepBaluja
Learningzmypassion.
https://www.facebook.com/VBAEXCELSQL?ref=hl
https://www.linkedin.com/profile/view?id=312532939
On Wednesday, May 20, 2015 at 2:59:09 PM UTC+5:30, neeraj chauhan wrote:
Dear Experts,
Kindly find the sheet and do the needful formula
if the snapshot would be range of Excel you can check the Ron D burn blog
you can easily get the code from there.
Regards,
Mandeep baluja
On Friday, May 15, 2015 at 9:01:41 PM UTC+5:30, Nasir Saikh wrote:
Hi Experts,
Here can you please help me out with the code to paste snapshot
I have been looking for the same !!!
Regards,
Mandeep Baluja
On Thursday, May 21, 2015 at 11:01:39 AM UTC+5:30, Priti_Verma wrote:
Hi There,
Is there any job for vba developer.
Thanks
Priti
--
Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s
=TIME(2,DO:IT
Practice can teach you excel, because nobody knows the end of Excel.
Regards,
MandeepBaluja
Learningzmypassion.
https://www.facebook.com/groups/825221420889809/
https://www.linkedin.com/profile/view?id=312532939
On Thursday, May 21, 2015 at 8:21:02 AM UTC+5:30, rahulbhardwaj1986 wrote:
Hi
Check this attachment !!!
Regards,
MandeepBaluja
Learningzmypassion.
https://www.facebook.com/groups/825221420889809/
https://www.linkedin.com/profile/view?id=312532939
On Wednesday, June 3, 2015 at 1:23:37 AM UTC+5:30, Bill Q wrote:
See attachment. Essentially, there are two sheets here.
Simple write numbers 1 to last row in column adjacent to your data and then
copy and paste those numbers below below as given below, sort your data
based on last column, it will show blank rows between each row.
For example
Column A Column B
A1
B 2
C
Hey avinash ,
check this attachment.
Regards,
MandeepBaluja
Learningzmypassion.
https://www.facebook.com/groups/825221420889809/
https://www.linkedin.com/profile/view?id=312532939
On Sunday, June 7, 2015 at 4:26:57 PM UTC+5:30, Avinash wrote:
Hi All,
I required formula which can give
Put this code into your summary sheet and tell me how is it working ?
Private Sub Worksheet_Change(ByVal Target As Range)
R = Target.Row
c = Target.Column
If Not Intersect(Target, Range(d8:g15)) Is Nothing Then
If Target.Value Cells(R + 17, c) Then
MsgBox You have exceed the limit -
Welcome :D
On Tuesday, June 23, 2015 at 6:03:56 PM UTC+5:30, Kumar Bhanushali wrote:
*Dear Sir,*
It works ,,, Thanks A Lot!!
*Regards, Kumar Bhanushali*
*Re: $$Excel-Macros$$ Message POP up*
*Mandeep Baluja * to: excel-macros
23-06-15 05:49 PM
Sent by: *excel
Elaborate your query which to cells what output you required ??
Regards,
Mandeep baluja
On Thursday, June 25, 2015 at 3:46:11 PM UTC+5:30, Harisha P wrote:
HI,
How to check the name of two cells are same or not.
Please help me.
Thanks,
Harish
--
Are you =EXP(E:RT) or =NOT(EXP
Elaborate more ???
I want to put this formula in Ox:Oxxx.
in Sx:Sxxx, there is value.
which formula what is SX:SXXX what do you want ??? in your output.
Regards,
MandeepBaluja
Learningzmypassion.
https://www.facebook.com/groups/825221420889809/
Attachment please ??
Regards,
MandeepBaluja
Learningzmypassion.
https://www.facebook.com/groups/825221420889809/
https://www.linkedin.com/profile/view?id=312532939
On Wednesday, June 24, 2015 at 2:22:56 PM UTC+5:30, Kumar Bhanushali wrote:
*Dear Sir,*
I want to put this formula in
Check this Out ;)
Regards,
MandeepBaluja
Learningzmypassion.
https://www.facebook.com/groups/825221420889809/
https://www.linkedin.com/profile/view?id=312532939
--
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
Simply first get all the attachments(ALL) of specified outlook folder into
your destination folder, then you can easily compiled the xlsx files into
one workbook. you can easliy find a macro to merge all xlsx file reside in
folder to one workbook. if you don't have i will share the same.
Hey uday,
M Sure you want the data of this type confirm once ?? as i given in the
attachment as sample, You can easily do this but after to follow some
specific steps and then can be achieved with the help of macro.
Regards,
MandeepBaluja
Learningzmypassion.
As far i understand your Query It should be if E8 8000 than you want to
show the message that your values exceed the maximum value. And Confirm One
thing Qty left is coming from which criteria.
Regards,
Mandeep Baluja
On Tuesday, June 23, 2015 at 3:41:15 PM UTC+5:30, Mandeep Baluja
: $$Excel-Macros$$ Message POP up*
*Mandeep Baluja * to: excel-macros
23-06-15 03:41 PM
Sent by: *excel-...@googlegroups.com javascript:* Cc:
kumar.bhanushali
From: Mandeep Baluja rocke...@gmail.com javascript:
To: excel-...@googlegroups.com javascript:Cc:
kumar.bh
Right click your sheet and add this code.
Private Sub Worksheet_Change(ByVal Target As Range)
If Not Intersect(Target, Range(e8)) Is Nothing Then
If Target.Value 8000 Then
MsgBox You have exceed the limit
End If
End If
End Sub
Regards,
MandeepBaluja
Learningzmypassion.
,*
It's working, but I same code for multiple cells.
like from D8:D15, E8:E15, F8:F15 G8:G15.
*Regards, Kumar Bhanushali *
*Re: $$Excel-Macros$$ Message POP up*
*Mandeep Baluja * to: excel-macros
23-06-15 03:58 PM
Sent by: *excel-...@googlegroups.com javascript
Question mentioned is in between the code
Sub Get_unique_pincodes()
With ActiveSheet
lr = ActiveSheet.Cells(Rows.Count, 1).End(xlUp).Row
lc = .Cells(1, Columns.Count).End(xlToLeft).Column
Debug.Print lc
lc = lc - 1
For i = 4 To lc
.UsedRange.AutoFilter field:=i, Criteria1:=1
Many ways to do it ,
1) apply filter use criteria greator than 0
2) formula given to you below attachment
3) VBA
4) Sort it
Regards,
MandeepBaluja
Learningzmypassion.
https://www.facebook.com/groups/825221420889809/
https://www.linkedin.com/profile/view?id=312532939
On Wednesday, June
-- is used to convert it to numeric value it can give the result of true to
1 and false to 0. you were not getting the result just because the numbers
are stored as text which you are getting from the formula.
Regards,
MandeepBaluja
Learningzmypassion.
Oh Fuck !!! how did you do that ? Amazed to see this result :) way to go
Regards,
MandeepBaluja
Learningzmypassion.
https://www.facebook.com/groups/825221420889809/
https://www.linkedin.com/profile/view?id=312532939
On Wednesday, June 17, 2015 at 6:13:03 PM UTC+5:30, Paul Schreiner wrote:
send me the file with this code then I can understand the problem.
Regards,
Mandeep Baluja
On Wednesday, May 27, 2015 at 3:37:00 PM UTC+5:30, Sundarvelan wrote:
Dear Mandeep,
I'm getting error in the below line.
Please help.
lr = ActiveSheet.Cells(Rows.Count, 1).End(xlUp).Offset(1
drop down ??? It's a combo box
On Wednesday, May 27, 2015 at 4:27:22 PM UTC+5:30, Soumyendu Paul wrote:
Its a drop down with employee code
On May 27, 2015 10:29 AM, Mandeep Baluja rocke...@gmail.com
javascript: wrote:
Want this type of Combo box ??
Regards,
Mandeep Baluja
Regards
N.Sundarvelan
9600160150
On Wed, May 27, 2015 at 4:19 PM, Mandeep Baluja rocke...@gmail.com
javascript: wrote:
send me the file with this code then I can understand the problem.
Regards,
Mandeep Baluja
On Wednesday, May 27, 2015 at 3:37:00 PM UTC+5:30, Sundarvelan wrote:
Dear Mandeep
Use this code as your code contains a syntax error
Application.Run MU Format(Sheets(Main).Range(C6).Value, ddmmyy)
.xlsm !ThisWorkbook.T
Regards,
MandeepBaluja
Learningzmypassion.
https://www.facebook.com/groups/825221420889809/
https://www.linkedin.com/profile/view?id=312532939
On
Hey Ali,
In answer to your query you can simply do this by adding 100 in the Value,
But it doesn't seems to me your query is that much simpler . Please correct
me or explain your query in more details.
Regards,
MandeepBaluja
Learningzmypassion.
Send me your query.
On Sunday, May 31, 2015 at 11:06:23 PM UTC+5:30, ali abbas wrote:
My how do Add 100 in query. Plz do attach sample file
On May 31, 2015 10:15 PM, Mandeep Baluja rocke...@gmail.com
javascript: wrote:
Hey Ali,
In answer to your query you can simply do this by adding
What is the criteria for the best price Is it the min value from the price
column against a particular Item.??
Regards,
MandeepBaluja
Learningzmypassion.
https://www.facebook.com/groups/825221420889809/
https://www.linkedin.com/profile/view?id=312532939
On Monday, June 1, 2015 at
Check this attachment !!
Regards,
MandeepBaluja
Learningzmypassion.
https://www.facebook.com/groups/825221420889809/
https://www.linkedin.com/profile/view?id=312532939
On Monday, June 1, 2015 at 10:07:52 AM UTC+5:30, TAWHID wrote:
Dear Experts,
Need little help here. Please have a look
.
Could you please include Body of the mail in the attached macro file.
Thanks
N.Sundarvelan
9600160150
On Wed, May 27, 2015 at 5:02 PM, Mandeep Baluja rocke...@gmail.com
javascript: wrote:
Working find just enable microsoft outlook 14.0 librarary and set the
date as per your
Mail is too huge to reside in a cell.
On Wednesday, May 27, 2015 at 6:58:27 PM UTC+5:30, Sundarvelan wrote:
Sorry,
Im getting the attached error.
Thanks
N.Sundarvelan
9600160150
On Wed, May 27, 2015 at 6:44 PM, Mandeep Baluja rocke...@gmail.com
javascript: wrote:
check this out
/15, Mandeep Baluja rocke...@gmail.com javascript: wrote:
Want this type of Combo box ??
Regards,
Mandeep Baluja
Regards,
MandeepBaluja
Learningzmypassion.
https://www.facebook.com/groups/825221420889809/
https://www.linkedin.com/profile/view?id=312532939
Export it is the best option. Or just give your personal macro workbook to
him/her. he can use it by just opening the file and all the macros will be
available .
Regards,
MandeepBaluja
Learningzmypassion.
https://www.facebook.com/groups/825221420889809/
Want this type of Combo box ??
Regards,
Mandeep Baluja
Regards,
MandeepBaluja
Learningzmypassion.
https://www.facebook.com/groups/825221420889809/
https://www.linkedin.com/profile/view?id=312532939
On Tuesday, May 26, 2015 at 1:06:40 PM UTC+5:30, Soumyendu Paul wrote:
Dear All,
When you
before is for Each and every employee i have created a
number of PDFs.
Regards,
Mandeep Baluja
On Saturday, May 30, 2015 at 4:33:00 PM UTC+5:30, diya wrote:
Hi experts,
I have create a macro that changes the cell B5(do while Loop) in the
attached file and accordingly the other
Password cracked got a lengthy code.
Regards,
MandeepBaluja
Learningzmypassion.
https://www.facebook.com/groups/825221420889809/
https://www.linkedin.com/profile/view?id=312532939
--
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
Hey Bill,
Please correct me if I am wrong. You wan't to retrieve multiple values
corresponding to same item number. The only thing which goes over my head
is open PO(o) Can we have a sample file with the output required.
Regards,
MandeepBaluja
Learningzmypassion.
201 - 300 of 454 matches
Mail list logo