In the autofilter panel,you are selecting cells that begin with "M".In the next
box,choose cells that do NOT begin with "MN"
Paul-
“Do all the good you can,
By all the means you can,
In all the ways you can,
In all the places you can,
At all the times you c
Dear Paul,
Thank you for the clarification, it is great help.
I am now able to make it work for various users.
Thanks a ton.
gargeeDate: Tue, 11 Aug 2015 12:41:11 +
From: schreiner_p...@att.net
To: excel-macros@googlegroups.com
Subject: Re: $$Excel-Macros$$ Help with saveas file code
The
The user's "My Documents" folder is USUALLY set up in the C:\users\useridfolder.
There's several ways of getting the login account name, but I think something
like:
MyDocsPath = Environ("USERPROFILE") & "\My Documents"
should give you the path to the user's My Documents folder.
Paul--
Hello Sarah, I can help you.
You could better detail what you need?
Regards,
Basole.
2015-07-06 12:33 GMT-03:00 Sarah Cartwright :
>
>
> Hi-
> I am in need of assistance with VBA code development to create a shareable
> template that can automatically generate a graph based on a user-friendly
pls check
On Wed, May 20, 2015 at 2:58 PM, Neeraj wrote:
> Dear Experts,
>
>
>
> Kindly find the sheet and do the needful formula
>
> --
> 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.
=IF(C5<0,0,IF(C5>380,C5-B5,IF(AND(D5>0,D5<=380),C5,"NA")))
Drag down...
On Wed, May 20, 2015 at 11:22 AM, ankit sharma wrote:
> Dear Experts i want a formula that fulfill my both conditions pls solve
> this.
>
> --
> Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s
> =T
Dear Sir,
My company has two shifts say Ist shift working =6:00 to 14:00 ans
second shift 14:00 to 22:00
i have large data of employees (rotating shifts) and want to calculate
which employee worked in which shift
Excel is on that format
EmployeeCode Shift
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 Index&Match formula for multiple
> column. Attached is the excel workbook.
>
> --
> ಧನ
Cheers!!
On Mon, Mar 16, 2015 at 4:53 PM, Vijayendra Rao
wrote:
> Dear Vaibhav,
>
> Thank you very much for your quick support. This is very helpful.
>
> Regards,
> Vijayendra
>
> 2015-03-13 20:27 GMT+05:30 Vaibhav Joshi :
>
>> PFA with #N/A handler...
>>
>> On Fri, Mar 13, 2015 at 1:08 PM, Vija
Dear Vaibhav,
Thank you very much for your quick support. This is very helpful.
Regards,
Vijayendra
2015-03-13 20:27 GMT+05:30 Vaibhav Joshi :
> PFA with #N/A handler...
>
> On Fri, Mar 13, 2015 at 1:08 PM, Vijayendra Rao
> wrote:
>
>> Dear Experts,
>>
>> Can you please help me to put vlookup
PFA with #N/A handler...
On Fri, Mar 13, 2015 at 1:08 PM, Vijayendra Rao
wrote:
> Dear Experts,
>
> Can you please help me to put vlookup or any other formula for the the
> second row. Attached is the my file and request you to help on the same.
>
> Regards,
> Vijayendra
> 94491 67631
>
> --
> A
check this..
Cheers!!
On Fri, Mar 13, 2015 at 1:08 PM, Vijayendra Rao
wrote:
> Dear Experts,
>
> Can you please help me to put vlookup or any other formula for the the
> second row. Attached is the my file and request you to help on the same.
>
> Regards,
> Vijayendra
> 94491 67631
>
> --
> Ar
Use Data==> Filter to get non zero values...
On Wed, Mar 11, 2015 at 1:34 PM, Harish P Y wrote:
> Hi,
>
> Needed help with the file attached file.I want to get the data of only the
> non zero elements from abstract sheet to abstract 2 sheet.
> kindly help me in this regard. tried pivot table but
Do let us know if you need any help..
Cheers!!
On Sat, Mar 7, 2015 at 3:42 PM, Mukesh Gupta wrote:
> Thanks
> On 7 Mar 2015 14:46, "Vaibhav Joshi" wrote:
>
>> Hi
>>
>> check this.. www.excelzoom.com/how-to-create-a-calendar-in-excel/
>>
>> Cheers!!
>>
>> On Fri, Mar 6, 2015 at 8:02 AM, Mukesh
Thanks
On 7 Mar 2015 14:46, "Vaibhav Joshi" wrote:
> Hi
>
> check this.. www.excelzoom.com/how-to-create-a-calendar-in-excel/
>
> Cheers!!
>
> On Fri, Mar 6, 2015 at 8:02 AM, Mukesh Gupta
> wrote:
>
>> Dear Friedns,
>>
>> Kindly help me in creating a conditional formating calander just like
>>
Hi
check this.. www.excelzoom.com/how-to-create-a-calendar-in-excel/
Cheers!!
On Fri, Mar 6, 2015 at 8:02 AM, Mukesh Gupta wrote:
> Dear Friedns,
>
> Kindly help me in creating a conditional formating calander just like
> goole calander.
>
> My basis needs are as follows:-
>
>
> 1. Start Date
Hi
Share excel file for more clarity..
Cheers!!
On Wed, Feb 11, 2015 at 11:26 AM, Enock Wangila wrote:
> Hi Guys,
>
> Please help me find a solution to this challenge. I need a formula that
> helps me fill multiple cells in a different worksheet by entering a value
> in a single cell in anothe
Great..Cheers!
On Sun, Feb 8, 2015 at 1:20 PM, singla.kris...@gmail.com <
singla.kris...@gmail.com> wrote:
> Hi Vabz,
>
> Thank you very much That worked like wonder...
>
> Many thanks
>
> --
> 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) ! J
Hi Vabz,
Thank you very much That worked like wonder...
Many thanks
--
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 t
HI
Not clear on what you want, can you explain further...
Cheers!!
On Tue, Feb 3, 2015 at 11:15 AM, wrote:
> I'm pretty new at this and any help or direction is greatly appreciated.
>
> So here's what I'm trying to do.
>
> First you might wanna download my example file so you can follow along.
Hi,
check this file..
Put formula countif in next columncopy & paste down, you can see there is
Separate set of sequential numbering for Dr & Cr.
Once it is ok, copy & paste value for formula column & sort data AtoZ ..
Cheers!!
On Tue, Feb 3, 2015 at 5:25 PM, singla.kris...@gmail.com <
singla.
Send with Excel file where you want to do this.
Pramod
On 3 Feb 2015 17:25, "singla.kris...@gmail.com"
wrote:
> Hi,
>
> Can somebody please help me in a small macro. My sheet have a column with
> some values and I want to sort them alternately.
>
> Current
> Dr.
> Cr.
> Dr.
> Dr.
> Cr.
> Cr.
> C
You can do so using macro..else you need to use dependent columns for data
validation list.
+
*I did not do this for you. God is here working through me for you.*
On Tue, Dec 30, 2014 at 2:48 PM, Rakesh kumar
wrote:
>
> Hi,
> I need help on Dependent Data validation.
> and please try to sol
Hi
check this..
Sub PrintForms()
Dim StartRow As Integer
Dim EndRow As Integer
Dim Msg As String
Dim i As Integer
Sheets("Form").Activate
StartRow = Range("StartRow")
EndRow = Range("EndRow")
If StartRow > EndRow Then
Msg = "ERROR" & vbCrLf & "The startin
Dear Sir,
Can we do it by vba.
please help.
Thanks
Ashu Kenith.
On Wed, Dec 17, 2014 at 9:21 PM, Ashish Kumar
wrote:
>
> Welcome Ashu.
>
> --
> 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
Welcome Ashu.
--
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,
Urgent,
Dear Vaibhav/Ashish Sir,
Thanks for your help. I am looking for this only.
Thanks
Ashu Kenith
On Wed, Dec 17, 2014 at 9:10 PM, Ashish Kumar
wrote:
>
> Hi Ashu,
>
> Check this!!
>
>
> Regards
> Ashish
>
> --
> Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s
> =TIME(
Hi Ashu,
Check this!!
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 @
https://www.facebook.com/discussexcel
FORUM RULES
1) Use concise, accurate thread titles. Poor thread titl
Dear Sir,
I want only single formula. I have some blank Cells in A and B column in
sheet 2. Query is attached please check again.
--
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.
Hi Ashu,
Use Simple Vlookup function which is suggested by Vaibhav Sir.
and Delete NA# with help of filter.
It's simple.
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 @
https://www.
Dear Sir,
I have some Blank cells in A column and Some Blank Cells in B Column in
sheet 2.
I want to match the C column data from Sheet 1.
only single formula required. If we don't want to put any formula in A and
B column but some cells are blank in both columns.
It is possible.
Thanks
Ashu K
Dear Sir,
I have huge data, So i want only single formula. or can it done by vba help.
Thanks
Ashu Kenith
On Wed, Dec 17, 2014 at 8:35 PM, Ashu k wrote:
>
> Dear Sir,
>
> Thanks for your support. I dont want to get data in A and B column, I want
> to get data in C column only. Don't want to pu
Yes, only if class no. is also unique the same way Name.
Check this cell with blue color.
Cheers!!
+
*I did not do this for you. God is here working through me for you.*
On Wed, Dec 17, 2014 at 8:35 PM, Ashu k wrote:
>
> Dear Sir,
>
> Thanks for your support. I dont want to get data in A a
Dear Sir,
Thanks for your support. I dont want to get data in A and B column, I want
to get data in C column only. Don't want to put formula in A and B column.
It is possible. to get data from Sheet 1 without put any formula in A and B
column in Sheet 2.
pls help.
Thanks
Ashu Kenith
On Wed, De
Hi
Check this..cell with yellow colour has formula.
Cheers!!
+
*I did not do this for you. God is here working through me for you.*
On Wed, Dec 17, 2014 at 8:21 PM, Ashu k wrote:
>
> Dear Seniors,
>
> Please help. how can i get data from sheet 1
>
> Ashu Kenith
>
>
> On Wed, Dec 17, 2014 at
Dear Seniors,
Please help. how can i get data from sheet 1
Ashu Kenith
On Wed, Dec 17, 2014 at 6:30 PM, 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 Name
check this..
I have used concatenate formula with Indirect & address..
Final formula is in column N & individual formula in col O to W..
Cheers!!
+
*I did not do this for you. God is here working through me for you.*
On Mon, Dec 8, 2014 at 4:51 PM, Rakesh wrote:
> hello Experts,
>
> Need
Dear Paul,
Thank you same as working properly.
Thanks & Regards,
Sriram.
On Tue, Nov 25, 2014 at 5:04 PM, Paul Schreiner
wrote:
> Do you mean like:
> =IF(AND(C5>1.1,C8>1.1),0.8,C10/C4)
>
> *Paul*
> -
>
>
>
>
>
>
>
> *“Do all the good you can,By all the m
Do you mean like:
=IF(AND(C5>1.1,C8>1.1),0.8,C10/C4)
Paul
-
“Do all the good you can,
By all the means you can,
In all the ways you can,
In all the places you can,
At all the times you can,
To all the people you can,
As long as ever you can.” - John Wesley
-
Singh Dhunna
> *To:* excel-macros@googlegroups.com
> *Sent:* Monday, November 24, 2014 11:28 AM
> *Subject:* Re: $$Excel-Macros$$ Help Required.
>
> There is no difference between Vlookup in Excel 2003 and Excel 2007 and
> above. Please elaborate what is the actual issue.
>
you can.” - John Wesley
-
>
> From: sriram ji
>To: excel-macros@googlegroups.com
>Sent: Monday, November 24, 2014 11:42 AM
>Subject: Re: $$Excel-Macros$$ Help Required.
>
>
>
>Dear Excel guru&#
24, 2014 11:28 AM
>Subject: Re: $$Excel-Macros$$ Help Required.
>
>
>
>There is no difference between Vlookup in Excel 2003 and Excel 2007 and above.
>Please elaborate what is the actual issue.
>
>
>On Mon, Nov 24, 2014 at 9:55 PM, sriram ji wrote:
>
>Dear Ex
Dear Excel guru's,
I have 4 Data in 2003 excel format. I want to vlookup in 10 data,
its 2007 excel format... Am trying to vlookup in 2003 to 2007 excel format
the below attached error is came. Please solve the error...
[image: Inline image 1]
Thanks & Regards
Sriram G
On Mon, Nov 24, 2
There is no difference between Vlookup in Excel 2003 and Excel 2007 and
above. Please elaborate what is the actual issue.
On Mon, Nov 24, 2014 at 9:55 PM, sriram ji wrote:
> Dear Excel Guru's,
>
> Is there any possible to vlookup in 2003 excel to 2007 excel or above.. If
> possible please provid
ld of macros,
> then nevermind.
>
> *Paul*
> -
>
>
>
>
>
>
>
> *“Do all the good you can,By all the means you can,In all the ways you
> can,In all the places you can,At all the times you can,To all the people
> you
Hi Ravinder,
PFA
Regards
Ashish
On Sun Nov 16 2014 at 5:10:24 PM Ravinder Kumar <
ravinderbhardwa...@gmail.com> wrote:
> Hi All,
>
> Please help me in the attached data, please share also the way to resolve
> it.
>
> Regards,
> Ravindra
>
> --
> Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel?
Please try these query.
Query1.
SELECT Table1.Name, Table2.NAme
FROM Table1 INNER JOIN Table2 ON cstr(Table1.Name) =
cstr(left(Table2.NAme,len(Table1.Name)));
query2.
UPDATE Table1 INNER JOIN Query1 ON Table1.Name = Query1.Table1.NAme SET
Table1.Name = [Query1].[Table2]![NAme]
WHERE ((Not (Tabl
an,
To all the people you can,
As long as ever you can.” - John Wesley
-
From: Vijayendra Rao
>To: excel-macros@googlegroups.com
>Sent: Wednesday, October 15, 2014 11:14 AM
>Subject: Re: $$Excel-Macros$$ Help in Time Tracker
>
>
>
>Dear Paul,
>
>
*From:* Vijayendra Rao
> *To:* excel-macros@googlegroups.com
> *Sent:* Tuesday, October 14, 2014 3:30 AM
> *Subject:* Re: $$Excel-Macros$$ Help in Time Tracker
>
> Dear Paul,
>
> Thank you very much your help, i have applied your formulas in my sheet
> and it works perfect. I
-
From: Vijayendra Rao
>To: excel-macros@googlegroups.com
>Sent: Tuesday, October 14, 2014 3:30 AM
>Subject: Re: $$Excel-Macros$$ Help in Time Tracker
>
>
>
>Dear Paul,
>
>
>Thank you very much your help, i have applied your formulas in my sheet and it
Dear Paul,
Thank you very much your help, i have applied your formulas in my sheet and
it works perfect. I am facing problem in total hours, it is showing some
wrong figure.
Can you please help on this. Attached is the sheet.
2014-10-13 20:59 GMT+05:30 Paul Schreiner :
> As you undoubtely not
As you undoubtely noticed, the number 8.45 does NOT represent 8 hours and 45
minutes,
but 8 hours and .45 of an hour, which is 8 hours and 27 minutes.
you cannot simply subtract these number and interpret the numbers as time.
Now, to excel, a DATE is actually the number of days since 1/1/19
Joe,
Here you go.. check this attachment.
Cheers!!
+
*I did not do this for you. God is here working through me for you.*
On Tue, Oct 7, 2014 at 1:09 AM, Joe Coldwell
wrote:
> Hi everone, I've been trying to figure out how to do this for a few days
> now, and decided to ask for help.
>
>
Is an example: considering sheet1:
Sub TestButton()
Dim sht1 As Worksheet
Dim lastRow As Long
Set sht1 = Sheets(1)
lastRow = sht1.Cells(Rows.Count, 2).End(xlUp).Row + 1
sht1.Range("b" & lastRow) = sht1.[a1]
End Sub
rgds.
Basole
2014-10-06 16:39 GMT-03:00 Joe Coldwell :
>
Hi,
Check this one!
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 @
https://www.facebook.com/discussexcel
FORUM RULES
1) Use concise, accurate thread titles. Poor thread titles,
Hi,
Check this..!!
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 @
https://www.facebook.com/discussexcel
FORUM RULES
1) Use concise, accurate thread titles. Poor thread titles, lik
hi
when you want to move data to compile sheet?
when you save & close data or any other trigger?
+
*I did not do this for you. God is here working through me for you.*
On Wed, Sep 24, 2014 at 2:26 PM, 'Ankit Chandna' via MS EXCEL AND VBA
MACROS wrote:
> Hi,
>
> I want to record the macro'
Hi Amit,
PFA..!!!
Regards
Ashish Kumar
On 24 September 2014 16:22, Amit Desai (MERU)
wrote:
> Dear All,
>
>
>
> I would like to have a layered chart for 3 cities...So for each city there
> should be 3 main bars. These each Bar has to have 2 sub bars in side it...
>
>
>
> So for Mumb
At A7 sheet Homepage, select Office. GET FILE button to select the file and
get into
2014-08-30 22:10 GMT+07:00 Eugene Bernard :
> Mr Basole,
>
> Thanks for the attachements,
>
> I am getting an error msg as in the attachment, even after adding Ms-ado
> object library.
>
> [image: Inline image
Was precisely the error: problem with the file name. * xls.
To work well, every day change the name, for example: 31/08/2014 and rename
to (T3108.xls).
Then do the test with your file. If you have any problems, please send me
an example of your file (Tddmm.xls).
Regards,
Basole.
2014-08-30 12:
Dear Basole,
Please ignore my earlier mail,
I removed the slash in between dd/mm from the below statement from your
example
fileXLS = "T" & Replace(Format(Date, "dd/mm"), "/", "") & ".xls" like
below,
fileXLS = "T" & Replace(Format(Date, "ddmm"), "/", "") & ".xls" and example
sent by you
star
Mr Basole,
Thanks for the attachements,
I am getting an error msg as in the attachment, even after adding Ms-ado
object library.
[image: Inline image 1]
TIA.
Eugene
On Fri, Aug 29, 2014 at 11:06 PM, Ricardo® wrote:
> Ok, is attached files.
> To test, hold the 2 files in the same folder
>
Ok, is attached files.
To test, hold the 2 files in the same folder
Regards,
Basole.
2014-08-29 11:58 GMT-03:00 Eugene Bernard :
> Basole,
>
> Thanks for your solution.
>
> Can you please send me the working example along with excel file with
> sample data.
>
> I tried your code with my data,
Basole,
Thanks for your solution.
Can you please send me the working example along with excel file with
sample data.
I tried your code with my data, and i am getting an error message.
Regards
Eugene
On Saturday, August 23, 2014 7:04:59 PM UTC+5:30, Basole wrote:
>
> Hi,
>
> See this example
From: Ashish Bhalara
>To: "excel-macros@googlegroups com"
>Sent: Thursday, August 28, 2014 7:22 AM
>Subject: Re: $$Excel-Macros$$ Help in function to show only valid data
>
>
>
>Dear Paul, thanks to reply, I don't want to simple filter. The data source is
>
Dear Paul, thanks to reply, I don't want to simple filter. The data source
is from same Sheet and data should be automatic filter in the same sheet
output by changing date.
Regards.
Ashish Bhalara
9624111822
P*Please do not print this email unless it is absolutely necessary. Spread
environmental ü
I'm sure we're going to find that there's more to this requirement than you've
supplied.
What you asked SPECIFICALLY:
"I need a function help in attached sheet, in which Output result display only
if value is not equal to zero"
is... ambiguous.
In Excel, a function is something like =sum()
I
Hi,
See this example extracts the data from your file T2308.xls (T & date: and
change the name according to the current(or system date)), using ADO and
SQL statement.
regards.
Basole
2014-08-23 8:55 GMT-03:00 Eugene Bernard :
> Dear all,
>
> I am daily using the attached sample query file t
I'd use something like:
With the date to consider in A1, use:
=(YEAR(TODAY())-YEAR(A1))*12+MONTH(TODAY())-MONTH(A1)
Paul
-
“Do all the good you can,
By all the means you can,
In all the ways you can,
In all the places you can,
At all the times you can,
T
Hi
Check this
http://www.keynotesupport.com/excel-functions/networkdays-function.shtml
Cheers!!
On Mon, Aug 11, 2014 at 6:03 PM, pankaj khairanar
wrote:
> Dear Experts,
>
> Hope you are doing well!
>
> I want Required your help in below scenario.
>
> Actually I want to substract number of da
Hi
Use datedif formula: =DATEDIF(A1,A2,"m")
where a1 contains oldest date.
Cheers!!
On Mon, Aug 11, 2014 at 3:54 PM, Shrinivas Shevde
wrote:
> I wish to find out difference between two dates in terms of Months.
>
>
>
> e.g. 10th May 2014 & today = 3 months
>
> 10th May 1993 & today = 255 mo
Hi Srinivas,
PFA...!!
Regards
Ashish
On 11 August 2014 15:54, Shrinivas Shevde wrote:
> I wish to find out difference between two dates in terms of Months.
>
>
>
> e.g. 10th May 2014 & today = 3 months
>
> 10th May 1993 & today = 255 months
>
> 10th jan 1981 & today = 403 months
>
>
> --
thanks Ashish ji, i will try it
On Wed, Jul 30, 2014 at 1:16 PM, Ashish Bhalara
wrote:
> Dear Mahendraji,
> See the Attached file, it will helpful to learn VBA Macro.
>
> Regards.
> Ashish Bhalara
> 9624111822
> P*Please do not print this email unless it is absolutely necessary.
> Spread enviro
Hi Anil,
Try yourself with below online tutorial. if you need help, you can revert.
http://www.excel-pratique.com/en/vba.php
.
Enjoy
Team XLS
On Tue, Jul 29, 2014 at 1:46 PM, anil nim wrote:
> Dear all,
>
>
> I want to learn Macros and VBA from any professional, who
Jocky Beta
>To: excel-macros@googlegroups.com
>Sent: Sunday, June 29, 2014 11:41 PM
>Subject: Re: $$Excel-Macros$$ Help required on Macro
>
>
>Hi Team,
>
>Can anybody help me for converting above attached file to comfortable
>for office 2010 as this file is made in
Jun 2014 13:58:15 +0530
> Subject: Re: $$Excel-Macros$$ Help required on Macro
> To: jocky6...@gmail.com
>
> Does this work ?
>
>
> On Thu, Jun 26, 2014 at 1:46 PM, Jocky Beta wrote:
>
>> Hi all,
>>
>> Any hope regarding on the same.
>>
>
Welcom steve
Pramod
On 27 Jun 2014 01:18, "Steve Weaver" wrote:
> Pramod,
>
> Thank you . . . Works perfectly!
>
> Steve
>
>
> Sent from my iPhone
>
> On Jun 26, 2014, at 2:09 PM, Pramod Singh wrote:
>
> Hi Steve,
>
> Hope this will fine for you,
>
>
> Regards
> Pramod
>
>
> On Thu, Jun 26, 2014
Pramod,
Thank you . . . Works perfectly!
Steve
Sent from my iPhone
> On Jun 26, 2014, at 2:09 PM, Pramod Singh wrote:
>
> Hi Steve,
>
> Hope this will fine for you,
>
>
> Regards
> Pramod
>
>
>> On Thu, Jun 26, 2014 at 9:54 PM, SteveWeaver
>> wrote:
>> I am in the process of populatin
>> >
>> > But sheet provided by you is not working It's showing *"Can't exit
>> design
>> > mode because control Combobox5 can not be created" *error.
>> >
>> > could you please help me on this?
>> >
>> > Regards
.
>
> could you please help me on this?
>
> Regards
>
> -- Forwarded message --
>> From: Manoj Garg
>> Date: Wed, 25 Jun 2014 11:52:30 +0530
>> Subject: Re: $$Excel-Macros$$ Help required on Macro
>> To: excel-macros@googlegroups.com, Jo
gt; Date: Wed, 25 Jun 2014 11:52:30 +0530
> Subject: Re: $$Excel-Macros$$ Help required on Macro
> To: excel-macros@googlegroups.com, Jocky Beta
>
> pfa
>
>
> On Wed, Jun 25, 2014 at 11:05 AM, Jocky Beta wrote:
>
> > Hi Team,
> >
> > I got below attached s
can u share sample file
On Tue, Jun 24, 2014 at 11:42 AM, Prayank Vidyarthi <
prayank.vidyar...@gmail.com> wrote:
> Hi,
>
> If I have a pivot table (as shown below) in which destinations sold has
> been sorted as Top 5 and Month has been sorted as Top 3. I wanted to create
> 5 different line cha
Thanks Brother, But how you Did this.
Please explain the process.
On Tue, Jun 17, 2014 at 1:02 PM, Dhaval Shah wrote:
> fyi
>
> Warm Regards,
>
> Dhaval Shah
> M) 98240 35253
> *E-mail : todhavals...@gmail.com *
>
>
>
>
> On Tue, Jun 17, 2014 at 12:51 PM, Rakesh kumar
> wrote:
>
>> Hi Guys,
>>
fyi
Warm Regards,
Dhaval Shah
M) 98240 35253
*E-mail : todhavals...@gmail.com *
On Tue, Jun 17, 2014 at 12:51 PM, Rakesh kumar
wrote:
> Hi Guys,
>
> I want to use formula on pivot table data.
>
> Kindly help me.
>
>
> --
> Thanks £ Regards
> Rakesh Kumar
> +91-9650303464
>
>
>
> --
> Are yo
You really shouldn't expect much help from this group in this case, since it
violates
Forum Rule #3:
There are LOTS of places on Google that you can find people who willingly allow
someone to steal someone else's work.
(5,340,000 hits on "Break Excel password")
I know, you aren't trying to
Dear Vaibhav
After running macro try to shift heading & you can see data is copied below
heading
Can u please how to do the same
Regards
shrinivas
On Thu, Jun 12, 2014 at 10:35 AM, Shrinivas Shevde
wrote:
> Dear Be Tran Van
> Thanks for kind help will check today and back by evening
>
> regard
Dear Be Tran Van
Thanks for kind help will check today and back by evening
regards
Shrinivas
On Thu, Jun 12, 2014 at 10:28 AM, Shrinivas Shevde
wrote:
> Dear Vaibhav
> First of all thanks for the help.
> I was out of station for 2 days so I could not reply sorry for that
> I will check the sam
Dear Vaibhav
First of all thanks for the help.
I was out of station for 2 days so I could not reply sorry for that
I will check the same today and will be back by evening
Once again thanks
Regards
Shrinivas
On Thu, Jun 12, 2014 at 12:09 AM, Bé Trần Văn
wrote:
> See the attached file.
>
>
>
> 2
Hey Srinivas
Did this helped??
On Mon, Jun 9, 2014 at 9:27 PM, Vaibhav Joshi wrote:
> Hey check this..
>
> To run macro click blue button. After running macro try to shift heading &
> you can see data is copied below heading.
>
> This is on assumption FIFO. so already existing data wont be d
ok..
I will try to send you by tonight..
Cheers!!
On Mon, Jun 9, 2014 at 12:08 PM, Shrinivas Shevde
wrote:
> Dear Vaibhav
> Thanks for reply.
> As I mentioned earlier today I have 10 rows and I run the macro. I will
> get output.
> Tomorrow I will add more 12 rows and if I run the macro I wil
Dear Vaibhav
Thanks for reply.
As I mentioned earlier today I have 10 rows and I run the macro. I will get
output.
Tomorrow I will add more 12 rows and if I run the macro I will get output
and it will overwrite the last one .there are chances someone will change
the data and resend .What I want is
Cant understand what is this attachment
On Sat, Jun 7, 2014 at 4:07 PM, Vaibhav Joshi wrote:
> FYI
>
>
> On Sat, Jun 7, 2014 at 4:01 PM, Shrinivas Shevde
> wrote:
>
>> Dear Vaibhav
>> Where is attachment
>>
>> Regards
>> Shrinivas
>>
>>
>> On Sat, Jun 7, 2014 at 1:30 PM, Vaibhav Joshi wrote:
FYI
On Sat, Jun 7, 2014 at 4:01 PM, Shrinivas Shevde
wrote:
> Dear Vaibhav
> Where is attachment
>
> Regards
> Shrinivas
>
>
> On Sat, Jun 7, 2014 at 1:30 PM, Vaibhav Joshi wrote:
>
>> hi
>>
>> check this..
>>
>> It is dynamic..
>>
>> CHeers!!
>>
>>
>> On Fri, Jun 6, 2014 at 12:54 PM, Shriniva
Dear Vaibhav
Where is attachment
Regards
Shrinivas
On Sat, Jun 7, 2014 at 1:30 PM, Vaibhav Joshi wrote:
> hi
>
> check this..
>
> It is dynamic..
>
> CHeers!!
>
>
> On Fri, Jun 6, 2014 at 12:54 PM, Shrinivas Shevde
> wrote:
>
>> Dear All
>> Please help me for Macro
>> 1. I have a work book wh
hi
check this..
It is dynamic..
CHeers!!
On Fri, Jun 6, 2014 at 12:54 PM, Shrinivas Shevde
wrote:
> Dear All
> Please help me for Macro
> 1. I have a work book which content many sheet.
> 2.In a work book there is data sheet.(master sheet) sheet attached
> 3.In a master sheet there is data w
can anyone help me?
Thanks in advance
On Fri, Jun 6, 2014 at 12:54 PM, Shrinivas Shevde
wrote:
> Dear All
> Please help me for Macro
> 1. I have a work book which content many sheet.
> 2.In a work book there is data sheet.(master sheet) sheet attached
> 3.In a master sheet there is data which c
pls share sample file
On Mon, Apr 7, 2014 at 2:42 PM, Ashish Bhalara wrote:
> Dear experts,
>
> I want merge cell containing text value and want comma(,) between all cell
> value in cocatenate function but my query is that when cell value is blank,
> the comma should not be display. Is it possib
please share a sample workbook
On Sat, Apr 5, 2014 at 1:18 PM, Ashish Bhalara wrote:
> Dear experts,
>
> I want merge cell containing text value and want comma(,) between all cell
> value in cocatenate function but my query is that when cell value is blank,
> the comma should not be display. Is
Thanks Ravinder
From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com]
On Behalf Of Ravinder
Sent: Wednesday, April 02, 2014 5:11 PM
To: excel-macros@googlegroups.com
Cc: Soum
Subject: RE: $$Excel-Macros$$ Help Required Urgent
PFA
From: excel-macros@googlegroups.com
PFA
From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com]
On Behalf Of Neeraj Chauhan
Sent: Wednesday, April 02, 2014 4:43 PM
To: excel-macros@googlegroups.com
Subject: $$Excel-Macros$$ Help Required Urgent
Dear experts,
Kindly find the attached sheet.
_
101 - 200 of 1327 matches
Mail list logo
