Hi Shrinivas,
A sample workbook with the parameters and the expected output will be
helpful for giving exact solution.
*Ms-Exl-Learner*
On 06-10-2012 9:01 AM, Shrinivas Shevde wrote:
Dear Excel Learner
First of all sorry for delay.
Thanks for the reply and this is exactly I want.
Can u
Congratulation ranjan.keep it up
On Sat, Oct 6, 2012 at 11:00 AM, xlstime xlst...@gmail.com wrote:
Congratulations Mr. Rajan Ji
On Wed, Oct 3, 2012 at 5:13 PM, NOORAIN ANSARI
noorain.ans...@gmail.comwrote:
I can say only...
यूँ ही बरकरार रखो भाई अपने
Dear Noorain Ansari,
Would you please tell why have you used the -- sing in the formula. for
you reference i have highlighted
the portion..
*=SUMPRODUCT(**--**(B4:B14=Karthik)*($C$4:$C$14=Collected))*
Thanking you
Regards,
Sanjib
--
-
--
Join official facebook page of this forum @
Really great that solve my purpose
Very very thanks.
On Sat, Oct 6, 2012 at 4:08 PM, Ms-Exl-Learner .
ms.exl.lear...@gmail.comwrote:
Hi Shrinivas,
Below is the revised code.
'*
Option Explicit
Sub PreserveData()
Dim bWs As
Dear experts,
I need to fill data in downward selected cell from upward cell as mention
in attached file, is there possible.
Thanks regards.
Ashish Bhalara
9624111822
P*Please do not print this email unless it is absolutely necessary. Spread
environmental üawareness.♣♣♣*
--
Join official
visit http://www.contextures.com/xlDataEntry02.html
*Fill Non Blank Cells From Above *
Step 1
Select the range.
http://3.bp.blogspot.com/-AAuPet5u7zM/TnBj_GdU1ZI/ArU/I9KTov6gsDQ/s1600/fill%2Bblank%2Bfrom%2Babove%2B1.JPG
Step 2
Press F5 -Special - choose Blanks
visit
http://www.excelbanter.com/showthread.php?t=182549
On Sat, Oct 6, 2012 at 2:22 PM, Sanjib Chatterjee
chatterjee.kolk...@gmail.com wrote:
Dear Noorain Ansari,
Would you please tell why have you used the -- sing in the formula. for
you reference i have highlighted
the portion..
http://peltiertech.com/WordPress/forms-controls-and-activex-controls-in-excel/
http://excelexperts.com/Form-Control-vs-ActiveX-Control
http://office.microsoft.com/en-us/excel-help/overview-of-forms-form-controls-and-activex-controls-on-a-worksheet-HA010237663.aspx
On Monday, October 1, 2012 9:11:00 PM UTC+4, prkhan56 wrote:
I posted this yesterday...it seems it did not get through..so posting once
again
Hello All,
I am using Excel 2010. I have a List of Names in Sheet name “List”
I have attached a file with two modules.
*Module1* Macro
run a loop and pass sheet names to sub routine create_pivot_table
Sub call_pivot()
Call create_pivot_table(Sheets(Participant1))
End Sub
Sub create_pivot_table(wk As Worksheet)
Application.DisplayAlerts = False
Dim pt As PivotTable
Dim PTCache As PivotCache
Dim wks As
Hello Ashish,
Thanks for the code.
Do I have to do the looping as follows:
Sub call_pivot()
Call create_pivot_table(Sheets(Participant1))
Call create_pivot_table(Sheets(Participant2))
Call create_pivot_table(Sheets(Participant3))
Call create_pivot_table(Sheets(Participant4))
Call
GOTTIT
the 2.5 is in units of 100 minutes
In B1 put = A1*100/24
Format B1 as hh:mm:ss
Regards
David Grugeon
On 7 October 2012 03:42, santosh subudhi santoshkumar.subu...@gmail.com wrote:
Hi Group,
I want to convert numbers into hrs and mins.
Suppose if I enter 2.5 in Cell A1 it
Sorry should be
In B1 put = A1*100/24/60
Regards
David Grugeon
On 7 October 2012 10:06, David Grugeon da...@grugeon.com.au wrote:
GOTTIT
the 2.5 is in units of 100 minutes
In B1 put = A1*100/24
Format B1 as hh:mm:ss
Regards
David Grugeon
On 7 October 2012 03:42, santosh
This group help me a lot for ma assignment time to time, I m really happy
to be the member of this group.
here again, I've some query require help from expert of this group. I
need to create a user input form.
I've a list of data in a particular excel spreadsheet, what I want is as
soon i
can you share the sample file
On Sun, Oct 7, 2012 at 11:03 AM, prabhat.shrivasta...@gmail.com
prabhat.shrivasta...@gmail.com wrote:
This group help me a lot for ma assignment time to time, I m really happy
to be the member of this group.
here again, I've some query require help from
Dear all,
Good Morning.
I want a macro which can create/ insert/ or delete worksheet according to the
list prepared in sheet1.
Like if I delete a name from the list the corresponding sheet will be deleted
or if I insert a name in the list it will create a sheet with the same name. It
will be
share the sample file
On Sun, Oct 7, 2012 at 11:22 AM, chhajersand...@gmail.com wrote:
Dear all,
Good Morning.
I want a macro which can create/ insert/ or delete worksheet according to
the list prepared in sheet1.
Like if I delete a name from the list the corresponding sheet will be
try this
Sub call_pivot()
Dim i As Long
For i = 2 To Sheets(List).Range(a65356).End(xlUp).Row
Call create_pivot_table(Sheets(Sheets(List).Range(a i).Value))
Next
End Sub
Sub create_pivot_table(wk As Worksheet)
Application.DisplayAlerts = False
Dim pt As PivotTable
Dim PTCache As
18 matches
Mail list logo