u can try this code...
*Sub UnhideAllSheets()*
*Dim wsSheet As Worksheet*
* *
*For Each wsSheet In ActiveWorkbook.Worksheets*
*wsSheet.Visible = xlSheetVisible*
*Next wsSheet*
*End Sub*
Best,
MKV
On Wed, Aug 24, 2011 at 12:54 PM, jayendra gaurav wrote:
>
> Team,
Me Too... Thanks...
Regards,
Manoj Kumar
On Mon, Aug 22, 2011 at 9:33 AM, pankaj gmail account
wrote:
> Please forward same to me also
>
> Thanks Pankaj
>
> 2011/8/20 Venkat CV
>
>> You are welcome
>>
>> *Best Regards,*
>> *Venkat *
>> *Chenn
Hi,
you can use this formula as well in cell B2:-
=LOOKUP(99^99,--("0"&MID(A2,MIN(SEARCH({0,1,2,3,4,5,6,7,8,9},A2&"0123456789")),ROW(INDIRECT("1:"&LEN(A2))
Best,
Manoj Kumar
On Tue, Jul 5, 2011 at 2:06 PM, MITTAL AJAY wrote:
> I
Congrats Ashish, keep it up.
Best,
Manoj Kumar
On Thu, Jun 2, 2011 at 10:29 PM, Ayush Jain wrote:
> Hello Everyone,
>
> Ashish Koul has been selected as 'Most Helpful Member' for the month of
> May'11
> He has posted 67 posts in May 2011 and helped many peop
Dear experts
Can you tell me what is use of snerios in excel.
Regards
Manoj
On 5/24/11, Rajan_Verma wrote:
> Send your File..
>
>
>
> From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com]
> On Behalf Of Chandra Shekar
> Sent: Monday, May 23, 2011 11:33 AM
> To: excel-macr
Awesome Rajan,
Can you please share your code with us, if possible???
I'm working on the same kind of stuff and your code might be helpful in
that.
Thanks,
Manoj Kumar
On Sat, Apr 9, 2011 at 12:30 AM, rajan verma wrote:
>
> HI Karan..
> find the attached sheet.. hope it will
I want to thanx to all member and specially Dilip who give some usefull
suggestion and tricks .
Regards
Manoj Kumar
On Thu, Mar 31, 2011 at 10:34 AM, Dilip Pandey wrote:
> Hi Manoj,
>
> You can subscribe to this group by following the below link:-
> http://groups.google.com/group/
Dear
I want to join your groups so plz suggest me how its possible on this mail
id.
Regards
Manoj
--
--
Some important links for excel users:
1. Follow us on TWITTER for tips tricks and links :
http://twitter.com/
Dear Member,
Can you tell me how can i add this groups of excel and VBA macros can
you tell me
Regards
Manoj
--
--
Some important links for excel users:
1. Follow us on TWITTER for tips tricks and links :
http://t
Dear Sajid Memon
Thanks you
Regards
Manoj
On 3/28/11, SAJID MEMON wrote:
>
> Dear Manoj
> you should visit tallysolutions.com for learn online
> tutorial by your tallyERP.9 serial number. From there you can learn better.
>
> Regards
>
> Sajid Memon
>
>> Date: Sun, 27 Mar 2011
helllo,
I want to learn tally so can you tell me is there any tally groups
like excel groups so their i can learn tally so plz tell me and sugges
me i m waiting for your response.
Regards
Manoj
--
--
Some important
Please find the attached...
Regards,
Manoj Kumar
On Tue, Feb 8, 2011 at 10:56 AM, San Pat wrote:
> Hi All,
>
> I am trying to extract a texts from the* parentheses.
>
>
> I have attached the sample file. I want to extract texts from the
> **parentheses
> f
Wow Rajan... that was very simple...
Regards,
Manoj Kumar
On Mon, Feb 7, 2011 at 10:27 PM, rajan verma wrote:
> Hi
> Find attachment
>
> Rajan
>
>
> On Mon, Feb 7, 2011 at 2:26 AM, Manoj kumar <
> manoj.vishwakarma...@gmail.com> wrote:
>
>> Hi C.G,
>
Hi,
use Len function..
=LEN(cell_reference)
Regards,
Manoj Kumar
On Fri, Feb 4, 2011 at 1:17 AM, Jorge Marques wrote:
> Hi, is there anyway of counting words ou letters in a specific cell?thank
> you ver
Use the attached sheet..
This can be done through VBA.. I have used the code provided by Yogesh
Gupta's blog :-
http://www.yogeshguptaonline.com/2009/07/excel-functions-convert-numbers-into.html
Regards,
Manoj Kumar
On Thu, Feb 3, 2011 at 4:44 PM, solomon raju wrote:
> Hi All,
&g
Congrats Man
Regards,
Manoj Kumar
On Thu, Feb 3, 2011 at 10:31 AM, anil panchal wrote:
> Congrats ashish.
>
> On Thu, Feb 3, 2011 at 1:19 AM, hanumant shinde > wrote:
>
>> Congrats ashish.
>>
>> He is really wonder boy. i have seen his many posts
Please find the attached
Regards,
Manoj Kumar
On Wed, Feb 2, 2011 at 1:09 PM, solomon raju wrote:
> Hi All,
>
> How can we extract month in text. Can someone define some formula for
> this.
>
> Attached my question in clear.
>
One could be this solution(attached)...
Regards,
Manoj Kumar
On Mon, Jan 31, 2011 at 6:22 PM, ashish koul wrote:
> check the attachment
>
>
> On Mon, Jan 31, 2011 at 4:04 PM, Nemi Gandhi wrote:
>
>> PLEASE HELP.
>>
>>
now check...
Regards,
Manoj Kumar
On Fri, Jan 28, 2011 at 12:14 PM, Usha Negi wrote:
> Thank you very much for your reply. But I checked subtotal for all zones it
> does not match. also I want to have subtotal after every quarter. Kindly see
> attached file.
>
> Thanks
> Ush
Hi Usha,
check the attached file, see if this helps u out...
Regards,
Manoj Kumar
On Fri, Jan 28, 2011 at 10:35 AM, Usha Negi wrote:
> Dear All,
>
> Good morning!
>
> I want to do subtotal on quarterly basis in the attached excel sheet. Could
> you please help me out on
please send us a sample file...
Regards,
Manoj Kumar
On Fri, Jan 28, 2011 at 4:30 AM, SK wrote:
> Hello Experts,
>
> I have a file which has 11 tabs. The 10 have same template with first
> row being the heading. The 11th sheet is suppose to be used as a
> summary report sheet
can u pls attach a sample file...
Regards,
Manoj Kumar
On Tue, Jan 25, 2011 at 9:05 AM, Susan wrote:
> Hi,
> I’m trying to copy a list from column A2 to A30 (which was created
> using Data Validation), on sheet 2 to column C2 to C30 on sheet 1.
> I’ve tried everything, but error
.Select
Selection.PasteSpecial Paste:=xlPasteValues, Operation:=xlNone,
SkipBlanks _
:=False, Transpose:=True
End Sub
Regards,
Manoj Kumar
On Tue, Jan 25, 2011 at 8:42 AM, Manoj b wrote:
> Hello All,
>
> Please can somebody advise me macros for paste special-transpose wherein i
> c
Hope this may help you...
Regards,
Manoj Kumar
On Mon, Jan 24, 2011 at 1:04 PM, Chidurala, Shrinivas <
shrinivas.chidur...@citi.com> wrote:
> Dear All,
>
> Please can any one help me to extract date in given securities by way of
> VBA code and formula.
>
> *Se
please send us an attachment..
Regards,
Manoj Kumar
On Thu, Jan 20, 2011 at 9:51 AM, solsbee wrote:
> I am doing a data dump into and excel spreadsheet and the date format
> that I get is MMDD. I am trying to sum the data by two criteria
> using the sumifs function, but I keep g
updated functions for ur reference...
Regards,
Manoj Kumar
On Wed, Jan 19, 2011 at 2:56 PM, Manoj kumar wrote:
> Hi Manish,
>
> Attached is the file with another function and it is much faster than the
> first one...
>
>
> Best of Luck...
>
>
> Regards,
> Manoj K
use either of them :-
=(B1-A1)+1
=DATEDIF(A1,B1,"d")+1
Regards,
Manoj Kumar
On Wed, Jan 19, 2011 at 2:01 PM, sudhir kumar wrote:
> Hi
>
> All Dear members
>
> Plz help on the following point.
>
> I want count no. of Days between two Dates.
>
> Examp
Hi Manish,
Attached is the file with another function and it is much faster than the
first one...
Best of Luck...
Regards,
Manoj Kumar
On Wed, Jan 19, 2011 at 2:16 PM, Dave Bonallack
wrote:
> Hi Manish,
> Please attach the solution you have. Perhaps one of us may be able to speed
&
now chk...
Regards,
Manoj Kumar
On Tue, Jan 18, 2011 at 5:36 PM, Amit Desai wrote:
> There are no formula or data validation in file!!
>
>
>
> Best Regards,
>
>
>
> Amit Desai
>
> Assistant Manager, GKS
>
> Direct +91 22 6672 9855
>
> Mobile
see if this helps you...
Regards,
Manoj Kumar
On Tue, Jan 18, 2011 at 1:03 AM, wrote:
> Dear Masters,
>
> I have one issue..
>
> I am creating one file & wants to use data validation with list (giving
> name to a range of vendor). My data sheet contains few columns. Co
the B column of
the table.
And I think this is the only mistake u have made in the formula
Some links :-
http://www.timeatlas.com/5_minute_tips/general/learning_vlookup_in_excel
http://www.techonthenet.com/excel/formulas/vlookup.php
I think this help u out....
Regards,
Manoj Kumar
On Mo
Attached for ur reference
Regards,
Manoj Kumar
On Mon, Jan 17, 2011 at 12:16 PM, jocky Beta wrote:
>
> Hi,
>
> I made a Excel sheet with help of V lookup using the Data validation, but
> my formula shows unknown error. hence pls explain me the step by
> step proc
Hey Manish,
Hope this might help you
Cheers,
Manoj Kumar
On Mon, Jan 17, 2011 at 10:43 AM, Manish wrote:
> is it possible or not??? :(
> any help pls.
>
>
> -
> Manish Pansari
>
> On Jan 14, 11:21�am, Manish wrote:
> > Dear Group Friends,
> &g
HI,
This might help u...
Regards,
Manoj Kumar
On Mon, Jan 17, 2011 at 1:03 AM, hanumant shinde
wrote:
> Hi Friends,
>
> I want to use IF condition like i used below but its no working.
> I used below formula.
> ={IF($A$8:$A$14="a",1,"")}
>
> f
Thanks and Wish you* Happy Makar Sankranti* to u as well
Regards,
Manoj Kumar
On Fri, Jan 14, 2011 at 10:55 AM, Chandra Singh Bora wrote:
> * आपको *
> * और *
> * आपके *
> *
If changes need to be made to the formula, the entire array has to
be highlighted, the edits can then be made and the Ctrl+Shift+Enter used to
confirm it.
*Syntax :-*
*=TRANSPOSE(Range)*
Regards,
Manoj Kumar
On Thu, Jan 13, 2011 at 11:15 PM, Ms-Exl-Learner . wrote:
> Hi All,
>
> I
See if this helps you out...
Regards,
Manoj Kumar
On Thu, Jan 13, 2011 at 8:58 PM, Dilip Pandey wrote:
> Hi Kalyan,
>
> Attached file has been solved per your requirement(s). :)
> Let me know if this works.
>
> Best Regards,
> DILIPandey
>
> On Thu, Jan 13, 2011
for how
many dates you want. Click Series, type 14 in the 'Step value' box and click
OK.
If you want a series of dates for the 15th of each month. Enter a starting
date, right-drag the Fill Handle for how many dates you want. Click 'Fill
months' and click OK.
Regards,
Manoj K
Sorry, ignore the previous mail.. pls find the attached one...
On Tue, Jan 11, 2011 at 12:20 PM, Manoj kumar <
manoj.vishwakarma...@gmail.com> wrote:
> Hi Ramesh,
>
> Attached is the sample file for your reference.. hope it meets ur
> requirements to the nearest...
>
&
, whenever the value in cell A7 is negative i.e less
than 0 a message will pop up saying *"Your Stock is less than what is
needed, Please Distribute Accordingly"*.
Have a good day :))
Regards,
Manoj Kumar
On Sat, Jan 8, 2011 at 1:06 AM, Ramkesh Maurya wrote:
> Dear All,
>
Thanks :)
Regards,
Manoj Kumar
On Sat, Jan 8, 2011 at 2:58 PM, Maries wrote:
> Congrats Mr.Manoj..
>
> -- Forwarded message --
> From: ayush jain
> Date: Sat, Jan 8, 2011 at 2:49 PM
> Subject: $$Excel-Macros$$ Excel Puzzle of the week - Winner is Manoj
quot; " & E4 & " " & F4 & " " & G4 &
" " & H4 & " " & I4), " ", ",")
Regards,
Manoj Kumar
On Fri, Jan 7, 2011 at 6:23 AM, ashish koul wrote:
>
> check the attachement
>
>
how about this...
=MONTH(1&A1)
Regards,
Manoj Kumar
On Thu, Jan 6, 2011 at 12:05 PM, ayush jain wrote:
> Wow AshishSuperfast...I liked it..
>
> Dear group,
> Do you have better answer to beat ashish :P
>
>
> On Thu, Jan 6, 2011 at 11:57 AM, ashish koul wrote:
Hi,
Though not a macro... but still works the same...pls chk the attached
Regards,
Manoj Kumar
On Wed, Jan 5, 2011 at 3:52 PM, Jorge Marques wrote:
> Hi guys, i´m need your help, i have a list of brands, that i need to put
> values of sales of the various shops , from cell B2:B15, and
Congrats Dilip...
Best Regards,
Manoj Kumar
On Mon, Jan 3, 2011 at 8:50 AM, ashish koul wrote:
> congrats dilip
>
>
> On Mon, Jan 3, 2011 at 4:48 PM, vidyut more wrote:
>
>> hi Dilip ji
>> Congratulations to you and Hatsoff u
>>
>> On Mon, Jan
Congrats man...
Regards,
Manoj Kumar
On Mon, Jan 3, 2011 at 2:06 PM, NOORAIN ANSARI wrote:
> Congratulations Ashish, Keep it up...
>
> Thanks,
> Noorain Ansari
>
> On Sun, Jan 2, 2011 at 1:07 AM, Rajasekhar Praharaju <
> rajasekhar.prahar...@gmail.com> wrote:
>
try this..
Function convertMonthName2Number(monthName As String) As Integer
' try to convert month name to actual date type
Dim dtestr As String
dtestr = monthName & "/1/2000"
Dim dte As Date
On Error Resume Next
dte = CDate(dtestr)
If Err.Number <> 0 Then
convertMonthName2Number = -999
Exi
also just forgot to mention,replace the inverted comas with proper (just
type them)...
Regards,
Manoj Kumar
On Tue, Dec 21, 2010 at 2:35 PM, Manoj kumar wrote:
> just remove "Option Explicit" and it is good to go...
>
>
> Regards,
> Manoj Kumar
>
>
> On Tue,
just remove "Option Explicit" and it is good to go...
Regards,
Manoj Kumar
On Tue, Dec 21, 2010 at 11:23 AM, poojari sreevijay wrote:
> Hi team,
>
> Could any one please advise where i have gone wrong.
>
> The attached is the screenshot.
>
Check if this works for you.
Regards,
Manoj Kumar
On Tue, Dec 21, 2010 at 1:08 PM, Rohan Young wrote:
> Hi Experts,
>
> Please help me out the problem is if i check my status from master sheet
> for knowing how many projects are under process, when i select the statusfrom
>
Pls find the attached...
Regards,
Manoj Kumar
On Wed, Dec 8, 2010 at 12:34 PM, Manjunath C wrote:
> Hi Team,
>
> I need to fill the highlighted(brown) coloumn with numbers 1 to 90 randomly
> by clicking the button "Press" each time.
> Finally we need the data
Try this link out...
http://www.yogeshguptaonline.com/2009/07/excel-functions-convert-numbers-into.html
Regards,
Manoj Vishwakarma
On Tue, Dec 7, 2010 at 5:52 PM, Radhe Sham wrote:
> Hi Ashish,
>
> Many thanks for the kind help in providing valuable information about
> Openexcel.
>
> Proba
hellloo experts
i want to use sum fuction in macro but without giving a cell referance
i want sum in a column
On 8/21/10, Jai wrote:
> Hello Experts
>
> Can you Tell me that how can Hide the One Cell in Excel in Sheet.
>
> --
> Thanks For Mail.
>
> --
> --
hiii tell me how can i use sum function in macro
tell me
On 8/22/10, Kishan Reddy, K wrote:
> You can use Edit -> goto (special) command to select specific cells in
> a particular range.
>
> check this command.
>
> Once you feel comfortable, record a macro.
>
> Then, if you require any further en
hiii tell me how can i use sum function in macro
tell me
On 8/22/10, Kishan Reddy, K wrote:
> You can use Edit -> goto (special) command to select specific cells in
> a particular range.
>
> check this command.
>
> Once you feel comfortable, record a macro.
>
> Then, if you require any further en
29, 2010 at 2:48 PM, Manoj kumar <
> manoj.vishwakarma...@gmail.com> wrote:
>
>> Guys,
>>
>> Can anyone help me on this?
>>
>>
>>
>> Thank You...
>>
>>
>>
>>
>> On Mon, Jul 26, 2010 at 11:22 AM, Manoj kumar <
&g
Guys,
Can anyone help me on this?
Thank You...
On Mon, Jul 26, 2010 at 11:22 AM, Manoj kumar <
manoj.vishwakarma...@gmail.com> wrote:
> Hi,
>
> I need to open an internal webpage after a phone number is entered into a
> spreadsheet then submit these details on the webp
Hi,
I need to open an internal webpage after a phone number is entered into a
spreadsheet then submit these details on the webpage and the result is paste
on the spreadsheet. Is there a way of doing this?
Thanks in advance!
Manoj Kumar
--
M.K.V
---
"The state of your life is nothing
Can anyone help me please...
Thanks,
Manoj Kumar
On Mon, Apr 19, 2010 at 1:01 AM, Manoj Kumar
wrote:
> Hi Guys,
>
> I need a macro to calculate total distance between two states or
> cities or both from a distance search engine.For example:-
> http://www.mapquest.com/.
>
>
Hi Guys,
I need a macro to calculate total distance between two states or
cities or both from a distance search engine.For example:-
http://www.mapquest.com/.
Appreciate ur help.
Thanks,
Manoj Kumar
--
--
Some
Hi Anil,
Please find the attached sample sheet for your reference
Regards,
Manoj Kumar
On Thu, Feb 25, 2010 at 8:54 AM, anil kumar wrote:
> Hello Everybody,
>
> My question is that suppose we have the below table
>
> Col A Col B Col C
> x a
Hi Sir
I have a list of several thousands email in it but there are so many
emails same
I have sorted the list but cannot delete all the files which are
copied of the above row
please help
--
--
Some important lin
Hi all
I have some data in cell a2, a3, a4 and also b1,b2,b3,b4
Now I want to multiply these no with each other with a single drag.
Please help
--
--
Some important links for excel users:
1. Follow us in TWITTER
101 - 163 of 163 matches
Mail list logo