Dear Champs
I want to learn excel & VBA so can you send me the notes for the same.
Thanks & Regards
Manoj Kumar
--
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/disc
Please add my number in what'sup group 9910243729
Thanks
Manoj
On Thu, Aug 11, 2016 at 11:24 AM, Manoj Garg wrote:
> Please add 9927199217
>
> On Aug 11, 2016 8:51 AM, "Kishore P V K" wrote:
>
>> Please add 9348264783
>>
>> On Wed, Aug 10, 2016 at 11:50 PM, mukesh kumar > > wrote:
>>
>>> Please
;
>>> *http://excelmacroworld.blogspot.com/*<http://excelmacroworld.blogspot.com/>
>>> *http://noorain-ansari.blogspot.com/*<http://noorain-ansari.blogspot.com/>
>>>
>>> On Mon, Jan 16, 2012 at 11:51 PM, Manoj Kumar
>>> wrote:
>>>
>>
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
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
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
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
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
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
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
&
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
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
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
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
.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
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
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
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
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
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.
>>
>>
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.
>
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
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
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
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,
>
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
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
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
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
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/
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/
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
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
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
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
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
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,
Dear Avinash.
Sub gg()
For a = 1 To Sheets.Count
Sheets(a).Activate
Range("a1:dd5").Select
Selection.Font.Bold = True
Next
End Sub
Regard
Manoj
On Sun, Jun 17, 2012 at 11:39 PM, Avinash wrote:
> Dear Experts,
>
> I have 1 workbook and there are 10 subsheets in that workbook.
> i hav
Tkanks Krishna
On Thu, Jun 21, 2012 at 12:09 PM, Maries wrote:
> Nice Collection Thanks
>
>
> On Wed, Jun 20, 2012 at 9:11 PM, Anil Gawli wrote:
>
>> Hi Krishna,
>>
>> Thanks 4 sharing ...
>>
>> Regards,
>> Gawli Anil
>>
>> On Wed, Jun 20, 2012 at 8:35 PM, NOORAIN ANSARI > > wrot
more
> columns to it just by adding column name with , and the same column in
> group by seperated by ,)
>
> Regards,
> Lalit Mohan
>
> On Friday, 29 June 2012 15:14:18 UTC+5:30, Manoj Kumar wrote:
>
>> Dear Experts,
>>
>>
>> I have data in month wise da
ROM [Mar'12];
> union
> SELECT distinct [Store ID]
> FROM [Apr'12];
> union
> SELECT distinct [Store ID]
> FROM [May'12];
>
> Regards
> Prince Dubey.
>
>
>
>
> On Friday, 29 June 2012 15:14:18 UTC+5:30, Manoj Kumar wrote:
>>
>> De
Dear Sudhir
Please find the attachment...
Regard
Manoj
On Mon, Jul 2, 2012 at 10:58 AM, SUDHIR VERMA wrote:
> Dear All,
>
> Please look at attachment and help me.
>
>
> thanking u
>
> Regards
>
>
> Sudhir
>
> --
> FORUM RULES (986+ members already BANNED for violation)
>
> 1) Use concise, ac
Thanks Noorain Ji...
its working..
On Wed, Jul 11, 2012 at 1:28 PM, NOORAIN ANSARI wrote:
> Dear Manoj,
>
> You can also try
> =IF(ISERROR(SEARCH(C9,B9))=TRUE,"Not Found","Found")
>
> On Wed, Jul 11, 2012 at 1:01 PM, Manoj Kumar
> wrote:
>
-
>> =TRIM(IFERROR(LEFT(RIGHT(A3,LEN(A3)-FIND(" ",A3,1)),FIND("
>> ",RIGHT(A3,LEN(A3)-FIND(" ",A3,1,""))
>> Third word:-
>> =RIGHT(A3,LEN(A3)-FIND("#",SUBSTITUTE(A3,"
>> ","#",LEN(A3)-LEN(S
oorain Ansari
> www.noorainansari.com
> www.excelmacroworld.blogspot.com
>
>
>
> On Mon, Jul 16, 2012 at 3:26 PM, Manoj Kumar
> wrote:
>
>> Dear Expert,
>>
>> Please help me to make report
>> I have data in 1 sheet I want make report in sheet 2.
>>
>> Regard
ri.com
> *Please* *Consider the environment. Please don't print this e-mail unless
> you really need to.*
>
>
> On Mon, Jul 16, 2012 at 3:41 PM, Manoj Kumar
> wrote:
>
>> Thanks Noorain Ji...
>>
>>
>> On Mon, Jul 16, 2012 at 3:39 PM, NOORAIN ANSARI &g
Hi.
Please provide me Excel 2003 & 2007 Short Key
Regard
Manoj
--
--
FORUM RULES (986+ members already BANNED for violation)
1) Use concise, accurate thread titles. Poor thread titles, like Please Help,
Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get
quick att
Thanks dear..€.
On Thu, Jul 19, 2012 at 12:50 AM, NOORAIN ANSARI
wrote:
> Dear Manoj,
>
> Please find attached short cut for excel 2003,2007 and 2010.
>
>
> On Thu, Jul 19, 2012 at 1:18 PM, Manoj Kumar
> wrote:
>
>> Hi.
>>
>> Please provide me Excel 2
ok
thanks
On Fri, Jul 20, 2012 at 6:00 PM, NOORAIN ANSARI wrote:
> Manoj Please change reference of range, As per need otherwise it will show
> same result.
>
>
> On Fri, Jul 20, 2012 at 5:55 PM, Manoj Kumar
> wrote:
>
>> Dear Noorain Ji,
>>
>> when
Dear Smitha,
Please find the attachment..
it will help you...
Regard
Manoj
On Thu, Jul 26, 2012 at 11:44 AM, Smitha S R wrote:
> Hi,
>
> Please help in conditional formatting or use of if formula in the
> following case. Excel attached.
>
> Closing Stock Verification stock required 1 1 if
Hi,
Please provide value from use Indirect..
Regard
Manoj
--
FORUM RULES (986+ members already BANNED for violation)
1) Use concise, accurate thread titles. Poor thread titles, like Please Help,
Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get
quick attention
*Cong Noorain! Ji*
On Sat, Aug 4, 2012 at 4:16 AM, dguillett1 wrote:
> Good work!
>
> Don Guillett
> Microsoft Excel Developer
> SalesAid Software
> dguille...@gmail.com
>
> *From:* Ayush Jain
> *Sent:* Friday, August 03, 2012 12:40 PM
> *To:* excel-macros
> *Subject:* $$Excel-Macros$$
Dear group
I want to make a barcode in excel. So i how make a barcode plz help me on
this.
Thanks
Manoj
--
Join official facebook page of this forum @
https://www.facebook.com/discussexcel
FORUM RULES (1120+ members already BANNED for violation)
1) Use concise, accurate thread titles. Poor t
Thanks dear
Manoj
On Aug 9, 2012 8:58 PM, "NOORAIN ANSARI" wrote:
> Dear Manoj,
>
> One easy way to create bar code in excel
>
> Please visit here
> http://strokescribe.com/en/create-barcode-excel-2007-activex.html
>
> On Thu, Aug 9, 2012 at 8:31 PM,
Hi Sundarvelan,
Tri it..
=Text(a1,"ddd")
Regard
Manoj
On Fri, Aug 17, 2012 at 3:12 PM, Kuldeep Singh wrote:
>
> Hi Sundarvelan,
>
> Please share a sample worksheet.
>
> Regards,
> Kuldeep Singh
>
>
> On Fri, Aug 17, 2012 at 3:09 PM, Sundarvelan N wrote:
>
>> Dear friends,
>>
>> I need to find
Hi,
Please help me to collect data in attached file..
Regard
Manoj
--
Join official facebook page of this forum @
https://www.facebook.com/discussexcel
FORUM RULES (1120+ members already BANNED for violation)
1) Use concise, accurate thread titles. Poor thread titles, like Please Help,
Urg
unjal**
> *
>
>
> On Wed, Aug 22, 2012 at 2:50 PM, Manoj Kumar
> wrote:
>
>> Hi,
>>
>> Please help me to collect data in attached file..
>>
>>
>> Regard
>> Manoj
>>
>> --
>> Join official facebook page of this forum @
right if required.
>
> ---
> Ms.Exl.Learner
> ---
>
>
>
> On Wed, Aug 22, 2012 at 3:41 PM, Manoj Kumar
> wrote:
>
>> i need the formula witch divide randomly A3, in cell A4 to A8
>> when i add A4 to A8 it show 200..
>>
>>
>>
s.Count
>
> For i = 1 To EndCol
> For j = 1 To Cells(2, i).Value
> Cells(3 + j, i).Value = Cells(3, i).Value / Cells(2, i).Value
> Next j
> Next i
> End Sub
>
> ---
> Ms.Exl.Learner
> ---
>
>
> On Wed,
Dear Rakesh,
Use *=SUMIFS(Sheet1!$D$2:$D$18,Sheet1!$B$2:$B$18,A2)*
Regd
Manoj
On Mon, Sep 3, 2012 at 1:00 PM, Rakesh Kumar Sharma
wrote:
> Hi Experts,
>
> I need the actual remit amt agnst tracking on sheet2 when data was found
> repeated on sheet1 with positive or nigative amt.
> See the att
Dear Expert,
Please help me to find rank in attached file..
Regard
Manoj
--
Join official facebook page of this forum @
https://www.facebook.com/discussexcel
FORUM RULES (1120+ members already BANNED for violation)
1) Use concise, accurate thread titles. Poor thread titles, like Please Help
Dear Pravin,
Please provide ans..
Regard
Manoj
On Mon, Sep 3, 2012 at 4:15 PM, Pravin Gunjal wrote:
> Pl use a meaningful subject for immediate response on your issues
>
>
> On Mon, Sep 3, 2012 at 3:59 PM, Manoj Kumar wrote:
>
>> Dear Expert,
>>
>> Please
ls explain properly.
>
> Regards
> Amresh
>
>
> On Mon, Sep 3, 2012 at 4:30 PM, Manoj Kumar wrote:
>
>> Dear Pravin,
>>
>> Please provide ans..
>>
>> Regard
>> Manoj
>>
>>
>> On Mon, Sep 3, 2012 at 4:15 PM, Pravin Gunjal wr
Dear Kuldeep,
Amresh put formule in value but i change range in percentage it's working..
Regard
Manoj
On Mon, Sep 3, 2012 at 4:45 PM, Manoj Kumar wrote:
> Thanks for all
>
> Amresh's formula is ok for me..
>
> Regard
> manoj
>
> On Mon, Sep 3, 2012 at 4:3
ok kuldeep it's my mistake...cell N4 value is wrong...
Regard
Manoj
On Mon, Sep 3, 2012 at 4:47 PM, Manoj Kumar wrote:
> Dear Kuldeep,
>
> Amresh put formule in value but i change range in percentage it's working..
>
> Regard
> Manoj
>
>
> On Mon, Sep
Dear Amresh,
if we need unique agency and unique city how can we find...
Regard
Manoj
On Wed, Sep 5, 2012 at 11:04 AM, Amresh Maurya wrote:
> Hi Pravin,
>
> find the attached solution.
>
> use this small formula.
>
> =COUNTA(C3:C39)
>
> Regards
> Amresh
>
>
> On Wed, Sep 5, 2012 at 10:50 AM, P
Dear amar,
Please tell what is passing marks...
Regard
Manoj
On Wed, Sep 5, 2012 at 1:06 PM, amar takale wrote:
> Hi All Experts,
> Pl solved challenging formula for passing.
>
> Appreciate the help very much
>
> --
> Join official facebook page of this forum @
> https://www.facebook.com/disc
Dear Amar,
Please Use it...
=IF(OR(F11<$F$10,G11<$G$10,H11<$H$10,I11<$I$10,J11<$J$10,K11<$K$10,L11<$L$10),"Failed","Pass")
Regard
Manoj
On Wed, Sep 5, 2012 at 1:10 PM, Manoj Kumar wrote:
> Dear amar,
>
> Please tell what is passing marks...
j,
> If failed minmum one subject then show failed (required output in yellow)
> (looking Minmum marks on Row numbers 10) F10:L10.
> If anyone got marks less than minimum marks then show failed.
>
> On Wed, Sep 5, 2012 at 1:10 PM, Manoj Kumar wrote:
>
>> Dear amar,
>>
d output in
>>> yellow) (looking Minmum marks on Row numbers 10) F10:L10.
>>> If anyone got marks less than minimum marks then show failed.
>>>
>>> On Wed, Sep 5, 2012 at 1:10 PM, Manoj Kumar
>>> wrote:
>>>
>>>> Dear amar,
>&g
Dear Mangesh,
you can use text to colum
Regard
Manoj
On Mon, Sep 10, 2012 at 4:34 PM, Mangesh Vimay wrote:
> Hi Friends,
>
> I need your help to divide the string into three parts.
> The description and sample is given below :
> [image: Inline image 1]
> Waiting for your response.
>
> Thank
Dear Expert.
Please tell me how can i re-size all slide in one time..
Regard
Manoj
--
Join official facebook page of this forum @
https://www.facebook.com/discussexcel
FORUM RULES (1120+ members already BANNED for violation)
1) Use concise, accurate thread titles. Poor thread titles, like
Dear Expert,
i want know about subtitute. anybody tell me about subtitute function..
Regard
Manoj
--
Join official facebook page of this forum @
https://www.facebook.com/discussexcel
FORUM RULES (1120+ members already BANNED for violation)
1) Use concise, accurate thread titles. Poor thread
ep Singh
> wrote:
>
>>
>> Hi see below links:
>>
>>
>> http://office.microsoft.com/en-us/excel-help/substitute-function-HP010062578.aspx
>>
>>
>> http://www.techonthenet.com/excel/formulas/substitute.php
>>
>> Regards,
>> Kuldee
my requirement is pending please help...
On Mon, Sep 24, 2012 at 12:34 PM, Manoj Kumar wrote:
> Dear Expert,
>
> i am making my presentation, i use macro to do same size of all picture
> after i want all picture show in center of slide...
>
>
> Please help me..
>
&g
Hi,
Is there an way to autocomplete the words from the custom list. When
someone type the first word, the word should be automatically filled and
display the rest word in should be in selection.
Regards,
Manoj
--
Join official facebook page of this forum @
https://www.facebook.com/discussexc
Tuesday, September 25, 2012 3:24:58 PM UTC+5:30, Manoj Kumar wrote:
>>
>> Hi,
>>
>> Is there an way to autocomplete the words from the custom list. When
>> someone type the first word, the word should be automatically filled and
>> display the rest word in
e you dropdown for cell and user have to select
> value from drop down.
>
> Regards,
>
> Swapnil.
>
> On Tue, Sep 25, 2012 at 5:16 PM, Manoj Kumar wrote:
>
>> Not able to understand clearly. can you please the solution in the
>> attached file.
>>
>>
cells.
>
>
>
> Other solution is use "Data Validation". It will not give you auto
> complete option. It will give you dropdown for cell and user have to select
> value from drop down.
>
>
>
> Regards,
>
>
>
> Swapnil.
anybody please help me.
On Thu, Sep 27, 2012 at 11:58 AM, Manoj Kumar wrote:
> Dear Expert,
>
> i am making Power point presentation i have a macro to do same size of
> all pitcher. but all pitcher showing in different aria.
>
> i want to do all picture in center of slide.
Dear Export,
I have one folder "x" witch has contain mail's, every mail contain an excel
file,
i want to copy all excel file from folder "x" to onther folder with
different name..
Regard
Manoj
--
Join official facebook page of this forum @
https://www.facebook.com/discussexcel
FORUM RULES (1
day, October 3, 2012 12:47:18 PM UTC+5:30, Manoj Kumar wrote:
>>
>> Dear Export,
>>
>> I have one folder "x" witch has contain mail's, every mail contain an
>> excel file,
>> i want to copy all excel file from folder "x" to onther folde
Dear vabz,
Thanks.
but it's not working..
Regard
Manoj
On Wed, Oct 3, 2012 at 1:15 PM, Vabz wrote:
> Hi
>
> PFA Files..
>
> Cheers..
>
> Rgds//Vabs
>
> On Wednesday, October 3, 2012 12:47:18 PM UTC+5:30, Manoj Kumar wrote:
>>
>> Dear Export,
&
e you can,
> As long as ever you can.” - John Wesley
> *-----
>
>
> --
> *From:* Manoj Kumar
> *To:* excel-macros@googlegroups.com
> *Sent:* Wed, October 3, 2012 3:52:31 AM
> *Subject:* Re: $$Excel-Macros$$ Re: Ex
you can,
> As long as ever you can.” - John Wesley
> *-----
>
>
> --
> *From:* Manoj Kumar
> *To:* excel-macros@googlegroups.com
> *Sent:* Wed, October 3, 2012 7:34:09 AM
>
> *Subject:* Re: $$Excel-Macro
Dear Expert,
Request you to kindly help me on this matter...
Please find the attachment..
I want id witch has on max dateeg:- if "name1" max date is 3-Oct it show
9564
Regard
Manoj
--
Join official facebook page of this forum @
https://www.facebook.com/discussexcel
FORUM RULES (1120+ me
Dear Viper,
Please can you solve it without erry..please help..
On Fri, Oct 5, 2012 at 11:47 AM, The Viper wrote:
> pfa
>
>
> On Fri, Oct 5, 2012 at 10:58 AM, Manoj Kumar
> wrote:
>
>> Dear Expert,
>>
>>
>> Request you to kindly help me on th
sistance.
>
> ---
>
> <><><><><><>
>
> *Ms.Exl.Learner*
> <><><><><><>
>
>
>
>
>
>
>
> On Fri, Oct 5, 2012 at 11:51 AM, Manoj Kumar
> wrote:
>
>> Dear Viper,
>>
>
Hi experts
I want to learn automation in excel first of all tell me. What is
automation. how I use in excel. Please give any notes and suggestions to
learn. Waiting for reply.
Thanks
Manoj
--
Join official facebook page of this forum @
https://www.facebook.com/discussexcel
FORUM RULES (1120+
und knowledge about Excel VBA , some of them are below :*
>
> * *
>
> *This Forum as well **J***
>
> *www.ExcelFox.Com*
>
> *www.excelpoweruser.wordpress.com*
>
> *http://excelvbaprogramming.wordpress.com/*<http://excelvbaprogramming.wordpress.com/>
>
>
> *
Waiting for reply
On Oct 10, 2012 11:52 PM, "Manoj Kumar" wrote:
> Actually I don't know about the coding in vba where I can learn coding for
> vba. I know only record macro. I want to do coding in my way. What I want
> I get it from my data.
>
> Thanks
>
Hi,
This is manoj kumar from new delhi..
I am add my new id on this group..
Regard
Manoj
On Saturday, June 9, 2012 12:51:59 AM UTC+5:30, Ayush Jain wrote:
>
> Hey all new and current posters,
>
> Welcome to excel group,one of the largest online community of excel Fans!
>
>
Dear Expert.
Please help me..
File attached below..
Regard
Manoj
--
Join official facebook page of this forum @
https://www.facebook.com/discussexcel
FORUM RULES (1120+ members already BANNED for violation)
1) Use concise, accurate thread titles. Poor thread titles, like Please Help,
Urgent
-- Forwarded message --
From: Manoj Kumar
Date: Thu, Oct 18, 2012 at 12:29 PM
Subject: Need formula to update status
To: excelvbacli...@googlegroups.com
Dear Expert,
Please Find the attachment..
Please provide me a formula to update status in coll "F"
Regard
Manoj
Thanks
On Thu, Oct 18, 2012 at 1:05 PM, Vabz wrote:
> Hi
>
> PFA..
> Cheers..
> Rgds//Vabs
> On Thursday, October 18, 2012 12:32:21 PM UTC+5:30, Manoj Kumar wrote:
>
>>
>>
>> -- Forwarded message --
>> From: Manoj Kumar
>> D
Hi expert
I want ABC in a column. So can u help me on this. In a column ABC from a
to z.
Thanks
Manoj
--
Join official facebook page of this forum @
https://www.facebook.com/discussexcel
FORUM RULES (1120+ members already BANNED for violation)
1) Use concise, accurate thread titles. Poor t
Hi
it's really work thanks a lots experts.
Regards
Manoj
On Oct 20, 2012 10:05 PM, "Manoj Kumar" wrote:
> Hi expert
>
> I want ABC in a column. So can u help me on this. In a column ABC from a
> to z.
>
> Thanks
> Manoj
>
> --
> Join o
Hi,
U Can buy Acer Aspire S3-I5..
Regard
Manoj
On Mon, Oct 22, 2012 at 4:49 PM, wrote:
> **
> Wooww! Gud input..
>
>
> Cheers//Vabs
> Sent on my BlackBerry® from Vodafone
> --
> *From: * CoRe
> *Date: *Mon, 22 Oct 2012 04:17:49 -0700 (PDT)
> *To: *
> *Cc: *
> *Subj
Dear Expert,
>
> I have data witch has Text and Number i want to do saperate text and
> number in next collume.
>
> man25oj kuma112r ro444ha25n 25s26on7
>
>
>
> Regard
> Manoj
>
--
Join official facebook page of this forum @
https://www.facebook.com/discussexcel
FORUM RULES (1120+ members
Please confirm it is possible without macro
Regard
Manoj
On Tue, Oct 23, 2012 at 12:17 PM, Vabz wrote:
>
> Hi
>
> PFA Att
>
> It contains various methods..
>
>
> Chherz//Vabz
>
> On Tuesday, October 23, 2012 11:19:06 AM UTC+5:30, Manoj Kumar wrote:
>>
1 - 100 of 163 matches
Mail list logo
