I included a small file, with sample data in it, and the macro I'm working
on.
--
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, accu
Sub CopyPastVal()
Cells.Copy
Selection.Copy
Selection.PasteSpecial Paste:=xlPasteValues
Application.CutCopyMode = False
End Sub
Thanks, David
On Sunday, December 17, 2017 at 12:12:31 AM UTC-8, Ravi K wrote:
>
> Thanks David.
> Will try to incorporate this into the macro.
>
> Cheer
Sub chkdt()
Application.ScreenUpdating = False
Application.Calculation = xlCalculationManual
Dim rw, cl, i, q As Double 'rw - no of used rows, cl - no of used column, i
- lookup for row,q - lookup for column
Dim dif, t, dt As Long
t = 4
dt = 5
rw = ThisWorkbook.Sheets("MINUTES").Range("A" & Rows.
Thanks David.
Will try to incorporate this into the macro.
Cheers
Ravi
On 17 Dec 2017 7:20 am, "who" wrote:
> Might try this too. Thanks, David
>
> Sub CopyPasteAll()
> Cells.Select
> Selection.Copy
> Selection.PasteSpecial Paste:=xlPasteValues
> ActiveSheet.Paste
> Applicat
Might try this too. Thanks, David
Sub CopyPasteAll()
Cells.Select
Selection.Copy
Selection.PasteSpecial Paste:=xlPasteValues
ActiveSheet.Paste
Application.CutCopyMode = False
ActiveCell.Select
End Sub
On Friday, December 15, 2017 at 10:14:17 PM UTC-8, Ravi K wrote:
>
> Hi
Please clarify below:
1. You wants to show all indus id with last two entry
Or
2. You want to see last two entry of any one indus id you choose (by drop
down option...)
Regards,
Prabhu.R
On 18-Sep-2017 7:16 PM, "Neeraj Gmail" wrote:
Dear experts,
Kindly find the sheet I want to put last two
Check if it helps ...
[image: Inline image 1]
Regards,
ZAFAR IQBAL
+966 (14) - 325 1654, 325 3484, 325 4148 - Ext - 2011
On Sat, Jul 15, 2017 at 5:31 PM, Srinivas G wrote:
> Hi Friends,
>
> I want to help in Excel
>
> ramu Ramu False
> Raju Raju True
> mohan Mohan
http://tutorialway.com/use-sumif-function-in-excel/
useful website
--
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
Find the attachment.
On Fri, Dec 16, 2016 at 6:01 PM, Rajesh Janardanan
wrote:
> An urgent requirement ... your help would be much appreciated .
>
> On Fri, Dec 16, 2016 at 1:10 PM, Rajesh Janardanan
> wrote:
>
>> Folks,
>>
>> Can you please help me in using index and match in the attached shee
An urgent requirement ... your help would be much appreciated .
On Fri, Dec 16, 2016 at 1:10 PM, Rajesh Janardanan
wrote:
> Folks,
>
> Can you please help me in using index and match in the attached sheet to
> use to calculate distance between the cities ?
>
> regards
> raj
>
--
Are you =EXP(E
Replace =vl+VLOOKUP(E2,B2:C339,2,FALSE)
first of all on this point, vlookup will not work, use instead Index and
match* =INDEX(B1:B339,MATCH(E2,C1:C339,0))*
*Regards*
*Deepu*
On Friday, 17 June 2016 12:52:48 UTC+5:30, vikas khen wrote:
>
> Hi all,
>
>
>
> Need your help on attached excel she
Hi
PFA,
Regards,
Sachin
On Friday, June 17, 2016 at 12:52:48 PM UTC+5:30, vikas khen wrote:
>
> Hi all,
>
>
>
> Need your help on attached excel sheet as my vlookup formula is not
> reflecting the value.
>
--
Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s
=TIME
Hi All,
I am trying to make pivot table using VBA.but I am getting runtime error 5 or
so. Can someone suggest me a code to make pivot cache and then table.
Thanks
Abhishek Bhalla
From: "amar takale"amartak...@gmail.com
Sent:Thu, 25 Feb 2016 10:20:12 +0530
To: excel-macros@googlegroups.com
Subje
>
> Your Date is not date but to convert a date to number you can simply
> multiply it with one this scenario works most of the cases but not for all.
>
For Example your date is in A1 put formula in b1 = A1*1
Regards,
Mandeep baluja
ticket closed
--
Are you =EXP(E:RT) or =NOT(EXP(E:RT))
Dear sir
I cannot understand kindly brief/example
From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com] On
Behalf Of Mandeep Baluja
Sent: Thursday, January 14, 2016 6:15 PM
To: MS EXCEL AND VBA MACROS
Subject: Re: $$Excel-Macros$$ Re: Help Required
Multiply date
] *On Behalf Of *Mandeep Baluja
> *Sent:* Thursday, January 14, 2016 4:50 PM
> *To:* MS EXCEL AND VBA MACROS
> *Subject:* $$Excel-Macros$$ Re: Help Required
>
>
>
> PFA !! Ticket closed
>
> Regards,
>
> Mandeep baluja
>
> --
> Are you =EXP(E:RT) or =NOT(EXP(
Dear sir,
Thanks sir !!
Kindly share the formula.
From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com] On
Behalf Of Mandeep Baluja
Sent: Thursday, January 14, 2016 4:50 PM
To: MS EXCEL AND VBA MACROS
Subject: $$Excel-Macros$$ Re: Help Required
PFA !! Ticket
>
> PFA !! Ticket closed
>
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, accurate thread titles. Poor
You can use this formula also:
*=IF(ISERROR(MATCH(MID(E2,FIND("/",E2)+1,LEN(E2))+0,$A:$A,0)),"No","Yes")*
Regards,
Pawan
On Tuesday, 22 December 2015 17:08:03 UTC+5:30, Ganesh N wrote:
>
> Dear team,
>
> I want to find the any of the given list of value matches (part) in the
> particular cell u
>
> Check this attachment !! 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. Poor t
> Hi Sam
> Thank you very much for your quick response
> Later i researched on the particular question and i concluded a result
> which may be seen in the attach workbook...but thank you very much for your
> quick response
>
> --
> *Izhar Ul Haq*
>
>
>
> Cell# 009203069072597
>
--
Are
Thanks Mandeep ji,
I do know that cell has a limit of characters, but my each returning value
has only 3 characters and max possible matches are 10 per lookup value, so
the maximum characters per cell would be 30. I guess that's not the issue
there.
Nevertheless, I would look into the alternate y
>
> Boss, First thing you should know is the Cell limit is limited,So in case
> Your the length of Concatenated lookup values characters is greater than
> cell limit it will turned out be #VALUE Error or The best one "MICROSOFT
> EXCEL IS NOT RESPONDING" :)
You can use a different approach/Ma
I've tried so many times in the past but failed to do so, the reason was,
when I tried to search a file in which I have to find something I typed the
word with the extension of the software which was unsuccessful but now I
tried to search without the extension I find whatever I required. In the
[mailto:
> excel-macros@googlegroups.com] *On Behalf Of *Anand Tiwari
> *Sent:* Tuesday, August 04, 2015 4:24 PM
> *To:* excel-macros@googlegroups.com
> *Subject:* Re: $$Excel-Macros$$ RE: Help required
>
>
>
> Hi Neeraj
>
>
>
> Please use this,
>
Thanks Anand
From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com] On
Behalf Of Anand Tiwari
Sent: Tuesday, August 04, 2015 4:24 PM
To: excel-macros@googlegroups.com
Subject: Re: $$Excel-Macros$$ RE: Help required
Hi Neeraj
Please use this,
Alt+D+E then
Hi Neeraj
Please use this,
Alt+D+E then Delimited next click Date and choose format DMY then finish.
*Regards,*
*Anand Tiwari*
On 4 August 2015 at 16:14, Neeraj Chauhan
wrote:
> Dear experts I want to change the date format
>
>
>
> Date
>
> I want this format
>
> 31/7/2015
>
> 31-Jul-15
>
Dear experts I want to change the date format
Date
I want this format
31/7/2015
31-Jul-15
--
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
That formula is doing the same as required !!
Regards,
MandeepBaluja
Learningzmypassion.
https://www.facebook.com/groups/825221420889809/
https://www.linkedin.com/profile/view?id=312532939
On Wednesday, July 1, 2015 at 9:22:39 AM UTC+5:30, Kumar Bhanushali wrote:
>
>
> *Dear Mandeep,*
>
> Ple
Hi Rohit,
Check this :-
http://answers.microsoft.com/en-us/office/forum/office_2010-excel/has-anyone-come-across-an-the-help-viewer-has/45771784-b014-414d-b872-8304e1b99dae
Regards,
MV
On Thursday, June 11, 2015 at 2:41:44 PM UTC+5:30, Rohit Jadhav wrote:
> Hi
> I'm not able to access any hel
Thanks sir
its working and I want this
From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com] On
Behalf Of Mandeep Baluja
Sent: Wednesday, May 20, 2015 3:25 PM
To: excel-macros@googlegroups.com
Subject: $$Excel-Macros$$ Re: Help Required
Want this ?
Regards
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 for
Brother the code which you have given it is for excel.
I am talking about MS Access
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 d
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
Thanks dude
but I need code to make separate sheet for each LOB as these needs to
assign work to each individual.
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 exampl
Why you're not using the pivot table feature to create this, Create pivot
and use this column in row field to create separate sheets. only 6 are
required, but if you still wish you can use the code for the same.
Health Personal Accident Engineering Miscellaneous - Package Liability
Miscel
Thanks Mandeep for reply.
Below is the column in which we required separate Tablefor each LOB.
*LOB Name* Health Personal Accident Engineering Health Personal
Accident Health Miscellaneous - Package Health Health Personal Accident
Health Health Health Personal Acciden
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 data
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 Mandee
Thanks alot Mandeep ji.
its working.
br//
rakesh
RAKESH SHARMA
NPI –Team
Ericsson India Pvt. Ltd.
4th Floor, Gupta Towers, Commercial Block, Rail Head
Jammu & Kashmir, INDIA
Phone 01912477440/ 01912477473/441
Fax 01912477442
Mobile +91 9906115140
rakesh.kumar.d.sha...@ericsson.com
www.ericsson.
when you select your blank cells just see the buttons in home tab where
insert,delete,format button is showing you need to press delete ->delete
cells -> shift cells to left .
On Wednesday, May 6, 2015 at 12:17:59 PM UTC+5:30, rk sharma wrote:
>
> Thanks Mandeep ji,
>
> but dear i didn't und
Thanks Mandeep ji,
but dear i didn't under stand what your are talking about this line
*go into home tab delete cells and shift cells left you will get your data*
Pl help
RAKESH SHARMA
NPI –Team
Ericsson India Pvt. Ltd.
4th Floor, Gupta Towers, Commercial Block, Rail Head
Jammu & Kashmir, IND
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://www.facebook
Dear Kumar,
Deciding min Max level based on 3 month data is bit unscientific,you need
to have at least 6 months data. Based on data provided by you, I have
answered your queries.
As mentioned by you GEOFORCE is external warehouse. It is not clear if the
stock at other location is replenished from
Hi,
Any one looked at it?
On Wednesday, April 15, 2015 at 3:13:43 PM UTC+1, kumar wrote:
>
> Hi,
>
> Just want to solve the questions with analysis.
> please find the enclosed attachment and answer the question. I also trying
> to solve. But needed Gurus help.
>
> Thanks
>
--
Are you =EXP(E:RT
Ok Sir, I am trying.
Regards
Ashu Kenith
--
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 title
Dear Mandeep Sir,
All are enabled.
PFA the attachment.
Please provide Support.
Regards
Ashu Kenith
--
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 RULE
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 2.
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. Exa
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 D
Dear Mandeep Sir,
Query is still pending from last 2 months. Last time you said that,
you will send the answer shortly.
Revert awaited from your side.
Please help.
Regards
Ashu kenith.
On 1/15/15, Ashu k wrote:
Dear Mandeep Sir,
Please Help on the same issue. Can i explain again my query.
P
Dear Mandeep Sir,
I am big fan of yours..!
Regards
Ashu Kenith
--
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 ti
Hey Will Sob it's my pleasure, Vabz I want too add you into my network as i
have started learning Excel techniques and admire your logics of Macros.
Regards,
MandeepBaluja
Learningzmypassion.
https://www.facebook.com/VBAEXCELSQL?ref=hl
https://www.linkedin.com/profile/view?id=312532939
On Mon
Hi Mandeep,
Logic used in macro is rilli cool...
Cheers!!
On Mon, Mar 16, 2015 at 1:46 PM, Mandeep baluja
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 So
Hey Will
Check this attachment..in any of given columns it will check occurrence of
10 , 13 & 17 in any order...
Hope you like it,.,.
Cheers!!
On Mon, Mar 16, 2015 at 5:34 PM, Will Sob wrote:
> Gosh l like this method thanks a lot. This is the best l have seen most
> appreciated
>
> On Mon,
Gosh l like this method thanks a lot. This is the best l have seen most
appreciated
On Mon, Mar 16, 2015 at 8:16 AM, Mandeep baluja
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
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) com
Yes it is by macros l like your code but it just won't work
On 16 Mar 2015 07:27, "Will Sob" wrote:
> Thanks for responding yes in a single row. H l would like to know
> about both methods of you can most appreciated
> Tell me two things
>
> is the triplet combination your searching in single
Thanks for responding yes in a single row. H l would like to know about
both methods of you can most appreciated
Tell me two things
is the triplet combination your searching in single , single row one by one
it can be achievedd with concatenate
but if you are trying to search the combination
Tell me two things
is the triplet combination your searching in single , single row one by one
it can be achievedd with concatenate
but if you are trying to search the combination triplet like the I5
contain 10 , d6 contain 13,d7 contain 17 is this countable or not . ??
On Monday, 16
thanks for your reply: l have loads of values, l am trying to build a
template where when l place numbers it should tell me how many triplet
combination exist within a range
10, 13, 17
1,19, 22
7, 21,22
On Mon, Mar 16, 2015 at 4:25 AM, Mandeep Baluja
wrote:
> send me the values which you are t
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 > wrote:
>
>> Check this attachment achieved with a macro. Change your num
thanks but it is not working when l use other values
On Sun, Mar 15, 2015 at 7:11 PM, Mandeep baluja
wrote:
> Check this attachment achieved with a macro. Change your numbers
> combination as per your requirement.
>
> Regards,
> MandeepBaluja
> Learningzmypassion.
> https://www.facebook.com/VBA
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 So
l'm sorry please see attachment
On Sun, Mar 15, 2015 at 2:45 AM, sahemur khan wrote:
> 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) combination has appeared wit
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) combination has appeared within the range D5:I32
>
>
>
>
>
>
>
>
>
>
> Are you =EXP(E:RT) or =NOT(EXP(E:RT)) i
Hi
If it's still valid please answer. I suppose in sample sheet WW is the
base. You want to create sheets named as in column B with charts (only?)
corresponding to data next to name in B? I can't see macro in sample so I
can't solve problem with graph name changing.
Waiting for response then
Dear Friend Dhaval,
Thanks for your comments. As per the given requirement i thought this would
be the suitable coding. May be I am not understand you exact requirement
properly. If possible could you please let me know you requirement clearly
once again so that I can try to help you to solve the
Try this...
Press Alt + F8 & Run macro, on prompt enter date for which you are updating
data..macro will copy data from daily data sheet to main sheet...
Cheers!!
On Mon, Mar 2, 2015 at 3:53 PM, Dhaval Shah wrote:
> ANY OTHER WAY TO USE OPTION OF PIVOT TABLE ??
>
> Warm Regards,
>
> Dhaval Sh
ANY OTHER WAY TO USE OPTION OF PIVOT TABLE ??
Warm Regards,
Dhaval Shah
M) 98240 35253
*E-mail : todhavals...@gmail.com *
On Mon, Mar 2, 2015 at 3:52 PM, Dhaval Shah wrote:
> THANKS DEAR FOR U R EFFORTS BUT ITS NOT USE FULL TO ME BECAUSE WHILE I
> UPDATE ITS PASTE WRONGLY
>
> Warm Regards,
>
THANKS DEAR FOR U R EFFORTS BUT ITS NOT USE FULL TO ME BECAUSE WHILE I
UPDATE ITS PASTE WRONGLY
Warm Regards,
Dhaval Shah
M) 98240 35253
*E-mail : todhavals...@gmail.com *
On Mon, Mar 2, 2015 at 12:24 AM, michael vinoth
wrote:
> Hi Dhaval Shah,
>
> Please find the attached macro file.
>
> Re
Hi Dhaval Shah,
Please find the attached macro file.
Regards,
MV
On Saturday, February 28, 2015 at 2:41:50 PM UTC+5:30, Dhaval Shah wrote:
>
> Dear Friends
>
> Pls find attached file of my work
>
> In sheet two sheets one is main sheet & another is daily data
>
> in main sheet yellow mark is
Hello
Correct me if mistaken. You want to sum time in column 1 with time in
column 2 in column 3 in format like hh hrs mm minute. If yes in column 3
add simply column 1 and column 2 (you can round it). Change format of
result by pressing ctrl+1 and typing in custom type: *hh "hrs" mm "minute"*
you can,
To all the people you can,
As long as ever you can.” - John Wesley
-
>
> From: Enock Wangila
>To: excel-macros@googlegroups.com
>Sent: Wednesday, February 11, 2015 10:13 AM
>Subject: Re: $$Excel-Mac
gt;> From: Enock Wangila
>>To: excel-macros@googlegroups.com
>>Sent: Wednesday, February 11, 2015 9:15 AM
>>Subject: $$Excel-Macros$$ Re: Help with excel data fill formula
>>
>>
>>
>>
>>
>>Hi,
>>
>>
>>Thank you Paul for the respons
__
> From: Enock Wangila
>To: excel-macros@googlegroups.com
>Sent: Wednesday, February 11, 2015 9:15 AM
>Subject: $$Excel-Macros$$ Re: Help with excel data fill formula
>
>
>
>
>
>Hi,
>
>
>Thank you Paul for the response. It is what I
Hi,
Thank you Paul for the response. It is what I was looking out for. Just one
more question, could the formula fill up the cells without having to drag
it? If one exists, will much appreciate.
Cheers.
--
Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s
=TIME(2,DO
times you can,
To all the people you can,
As long as ever you can.” - John Wesley
-
From: Enock Wangila
>To: excel-macros@googlegroups.com
>Sent: Wednesday, February 11, 2015 5:54 AM
>Subject: $$Excel-Macros$$ Re: Help with excel data fill formula
>
>
>
>
>
>Here is an il
> Here is an illustration of what I am requesting for. I hope it helps make
> the case clearer.
>
Cheers
--
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
FOR
Dear Mandeep Sir,
Please help.
kindly send the macro.
Regards
Ashu Kenith.
On Thu, Jan 15, 2015 at 6:41 PM, Ashu k wrote:
> Dear Mandeep Sir,
>
> Please Help on the same issue. Can i explain again my query.
>
> Please help sir.
>
> Regards
> Ashu Kenith
>
> On Thu, Jan 15, 2015 at 12:30 PM, A
Dear Mandeep Sir,
Thanks a lot for your help.
I don't have an facebook account. So, request you to please share the macro
when you have time.
Thanks for your help and kind support.
Regards
Ashu Kenith
On Thu, Jan 15, 2015 at 9:33 PM, Mandeep Baluja
wrote:
> https://m.facebook.com/VBAEXCELSQL
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)) in
Dear Mandeep Sir,
Please Help on the same issue. Can i explain again my query.
Please help sir.
Regards
Ashu Kenith
On Thu, Jan 15, 2015 at 12:30 PM, Ashu k wrote:
> Dear Mandeep Sir,
>
> Please help.
>
> Regards
> Ashu Kenith.
>
>
> On Tue, Jan 13, 2015 at 6:37 PM, Ashu k wrote:
>
>> Dear M
Dear Mandeep Sir,
Please help.
Regards
Ashu Kenith.
On Tue, Jan 13, 2015 at 6:37 PM, Ashu k wrote:
> Dear Mandeep Sir,
>
> Thanks a lot for your help.
>
> one more help required.
>
> If the Merchant ID is same then paste the data (Order No., Item ID, Item
> Name, RTO Date) on mail body which w
Dear Mandeep Sir,
Thanks a lot for your help.
one more help required.
If the Merchant ID is same then paste the data (Order No., Item ID, Item
Name, RTO Date) on mail body which was belongs to Same Merchant ID.
Example : - Merchant ID is 12345 and 10 orders is placed by this merchant,
then pas
>
> Try this Ashu k ,
This must meet your requirements. Thanks to RonDBurn Blog.
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?
Dear Mandeep Sir,
Please Help.
Regards
Ashu Kenith.
On Wed, Jan 7, 2015 at 4:18 PM, Ashu k wrote:
> Dear Mandeep Sir,
>
>
> Solution was perfect. But i want Paste the data in Mail body.
>
> Please check below sample Email :-
>
>
> Dear Business Partner,
>
>
>
> This is to inform you that as p
Dear Mandeep Sir,
Please Help!!
Thanks
Ashu Kenith.
On Wed, Jan 7, 2015 at 4:18 PM, Ashu k wrote:
> Dear Mandeep Sir,
>
>
> Solution was perfect. But i want Paste the data in Mail body.
>
> Please check below sample Email :-
>
>
> Dear Business Partner,
>
>
>
> This is to inform you that
Dear Mandeep Sir,
Solution was perfect. But i want Paste the data in Mail body.
Please check below sample Email :-
Dear Business Partner,
This is to inform you that as per our logistic partner report you have
received RTO shipments with details as follow:
*Order No*
*Item ID*
*Item Name
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
Dear Mandeep Sir,
I don't want to send mail with attachment. I want send different mail to
different customers according to the merchant ID.
Subject and message body should be changed automatically with all the
details (order no., rto date, item name, item id) when i punch the merchant
id,order n
Dear Anil Sir,
Thanks for your reply. But, i dont want to send mail with attachment. I
want send different mail to different customers according to the merchant
ID.
Subject and message body should be changed automatically with all the
details (order no., rto date, item name, item id) when i punch
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
Dear Mr. Ashu,
Pls find attached as per you requirement.
P.S pls change the address of the attachment as you req.
.Add ("T:\Commercial\Common\Shailendra\Data" & Format(Now(),
"mm-dd-yy") & ".xls")
Warm regards,
Gawli Anil.
On Wed, Jan 7, 2015 at 1:24 PM, Ashu k wrote:
> Dear Mandeep Sir,
>
>
Dear Mandeep Sir,
PLease help. I want send mail to the customers. Example is attached.
Thanks
Ashu Kenith
--
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
>
> check this sheet.
Try to understand what I did For i = 2 To lr + 700 you can set 700 to any
number. Datarange is not set in your data that's why i running the loop to
lastrow+700 if your data will be greater just change 700 to 7 or to any
number it will give correct result to you
Dear Paul Sir,
Thanks for your help and explaining me..
Dear Mandeep Sir,
Thanks a lot for your help, Please check the attached sheet. Result was not
showing in Last cell.
Please help.
Thanks
Ashu Kenith.
On Wed, Jan 7, 2015 at 10:21 AM, Mandeep Baluja
wrote:
> Hey Ashu,
>
>
> Check this sh
>
> Hey Ashu,
Check this sheet .* Note :- be careful to check this macro can only give
you error if the number are actually numbers not the Text values as your
sheet contain 1 value which was text that is the only reason it gives error
as paul has explained to you mostly people copy numbers f
---------
From: Ashu k
>To: Mandeep Baluja ; excel-macros
>
>Sent: Tuesday, January 6, 2015 11:38 AM
>Subject: Fwd: $$Excel-Macros$$ Re: Help required for Match DATA
>
>
>
>Dear Mandeep Sir,
>
>
>Please help on this. The sheet is provided by you is
Dear Mandeep Sir,
Please help on this. The sheet is provided by you is providing NA#. Please
Help.
Thanks
Ashu Kenith
-- Forwarded message --
From: Ashu k
Date: Wed, Dec 31, 2014 at 11:52 AM
Subject: Fwd: $$Excel-Macros$$ Re: Help required for Match DATA
To: Mandeep Baluja
1 - 100 of 605 matches
Mail list logo