Hello All,
Can anyone help me to build Skyline Charts?
Or may be helping me by sharing macro for building Skyline Charts?
Looking forward to your help.
Thank you
Regard's
Manish Seta
--
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) !
Dear Experts,
I need to design a macro w.r.t Salary Structure in excel as per following
requirement.
Current Salary Structure is follows:-
S.No. Category Emp. Name Basic HRA Conv. Med. CCA SPA Take Home Bonus EPF ESIC
CTC
1 1 RK 24,115 12,058 7,235 - 7,235 34,392 85,035 4823 2894 0 92,752
2
Hi all,
Required is SQL codes for the below data and results
Cust_IDProd_RangeA1P1A1P2A1P3A2P4A2P5Required result is A1P1/P2/P3A2P4/P5
Please help its bit urgent
--
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 th
On Thursday, March 6, 2014 4:03:30 PM UTC+5:30, manish jaiswal wrote:
>
> Cust#Sold to Cust#Sold to - Name Comm# Inv#No Invoice Date Item Code
> Business 7000666325 SANDEEP ENTERPRISES 6562501469 01.03.2014 A39 HD Karbonn
> Tab 7000666218 B.R. ENTERPRISES 6580015382 01.03
Cust#Sold to Cust#Sold to - Name Comm# Inv#No Invoice Date Item Code
Business 7000666325 SANDEEP ENTERPRISES 6562501469 01.03.2014 A39 HD Karbonn
Tab 7000666218 B.R. ENTERPRISES 6580015382 01.03.2014 A34 HD STAR Karbonn
Tab 7000663581 SHREENATHJI DISTRIBUTOR 6675032273 01.03.2014 A37 HD K
using vlookup and requirement is pick data from other sheet.
I have data in 10 column and first column is unique column.i want pick only
limited column like 4 6 9 column.and requirement is only one time use
vlookup formula and pick all data in other sheet by unique column.
--
Are you =EXP(E:RT
wthat is pkg in macro?
--
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,
Hi ,
i am new on this group, would like to be good in excel and VBA, i would
need your help.
Thanks
manish.
--
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
Oh ya... It is working SAM and ashish... Thanks to you both buddy... :)
On Sun, Dec 1, 2013 at 10:06 PM, Sam Mathai Chacko wrote:
> As Ashish mentioned, you need to correct the dates on the top row.
>
> Regards,
> Sam Mathai Chacko
>
>
> On Sun, Dec 1, 2013 at 8:58 PM
;
> On Sun, Dec 1, 2013 at 8:48 PM, manish mishra wrote:
>
>> When i am dragging it towards right why is it copying all ??
>>
>>
>>
>> On Sun, Dec 1, 2013 at 8:46 PM, manish mishra
>> wrote:
>>
>>> can it be done with index match ??
>>
When i am dragging it towards right why is it copying all ??
On Sun, Dec 1, 2013 at 8:46 PM, manish mishra wrote:
> can it be done with index match ??
>
>
>
> On Sun, Dec 1, 2013 at 8:37 PM, ashish koul wrote:
>
>> try this
>> =VLOOKUP($A2,Sheet2!$A$1:$CC$80,M
can it be done with index match ??
On Sun, Dec 1, 2013 at 8:37 PM, ashish koul wrote:
> try this
> =VLOOKUP($A2,Sheet2!$A$1:$CC$80,MATCH(Sheet1!B$1,Sheet2!$1:$1,0),0)
>
> On Sun, Dec 1, 2013 at 7:52 PM, manish mishra wrote:
>
>> Whats Wrong with the applied formulae
testing of GL / Cost Mgmt / Inventory Costing and sub ledger accounting
(SLA)
• Knowledge / Experience in the Food Industry a Plus
CONTACT : manish@gmail.com
Thanks and REGARDS
HMG America
--
Join official Facebook page of this forum @
https://www.facebook.com
Congr8ss Rajan...
On Wednesday, August 3, 2011 10:52:02 PM UTC+5:30, Ayush Jain wrote:
>
> Hello Everyone,
>>>
>>> Rajan Verma has been selected as 'Most Helpful Member' for the month of
>>> July'11
>>> He has posted 170 posts in July 2011 and helped many people through his
>>> expertise. He h
An easy solution would be Sumif Function. See attached.
Regards,
Manish
On Tue, Nov 29, 2011 at 2:53 PM, smitha.kumari
wrote:
> Hi,
>
> ** **
>
> PFA the expense sheet and suggest a formula to solve the problem as
> mentioned in the attachment.
>
> ** **
&g
Hi Hemant,
Go to File>Excel Options>Proofing>Auto Correct Options, there uncheck
'internet and network path with hyperlink'. This will resolve creating
hyperlink automatically.
Regards,
Manish
maverickpan...@gmail.com
On Mon, Nov 21, 2011 at 5:09 PM, hemant wrote:
> Hi
Hi Excel Group Members,
I was hoping if anyone can share project feasibility report (sample)
specifically for real estate in Indian Context. I have to work on
feasibility study of a township project.
This may carry following details -
1. Profitability Statement (Feasibility)
2. Cash Inflow / Out
Congratulations Rajan... :)
-
Manish
On Aug 5, 9:37 pm, neil johnson wrote:
> Congratulation Rajan.
>
> On Fri, Aug 5, 2011 at 8:57 AM, Haseeb Avarakkan
>
>
> > wrote:
> > Congratulations Raja
Any help Pls...
-
Manish
On Jul 20, 2:43 pm, Manish wrote:
> Thanks Ashish,
>
> Is it possible to attach the picture saved in computer??
> Like, If I will mention the path of the image file in column E, and
> excel will send that image in the body of outlook mail.
>
> Also
option is available in MS Outlook, But is it possible to send
mail thru excel with such permissions??
Regards,
Manish
On Jul 19, 9:35 pm, ashish koul wrote:
> The easiest way to send an image in the body of outlook mail is to add the
> image on any photo sharing website like photobucket.co
”.
Please suggest.
Thanks,
Manish
-- Forwarded message --
From: ashish koul
Date: Aug 21 2010, 3:27 pm
Subject: $$Excel-Macros$$ sending e mail based on data in column in
excel
To: MS EXCEL AND VBA MACROS
in reference select Microsoft outlook library
Sub bdaymessages()
Dim
Hi Skanda,
you can do one thing, first select the numbers and then go to
Format > Format cells > number tab > custom > 0
In case any query, please feel free to contact.
Thanks & Regards,
Manish Singh Bankoti
On Fri, Jun 17, 2011 at 3:46 AM, Skanda wrote:
> Hi,
&
Hello EE,
Pls suggest.
Is it not possible ??
If its possible, I am ready to pay to devlop this module for me.. :)
awaiting for your reply..
Regds,
Manish Pansari
+91 9810 88 8281
On Jun 10, 4:28 pm, Manish wrote:
> Dear Team Member,
>
> Thanks for all of your support and assistant
from
web for next 15 days?? Also since it will change on rotetional basis
(add one more day, everyday).
Please suggest ame any other way or your suggestion will highly
helpful.
Awaiting for your respons.
Thanks,
Manish
Simran
can you attach the sample file ..
On Tue, Jun 7, 2011 at 12:00 AM, Mahesh parab wrote:
> Hi
>
> check
>
> http://www.rondebruin.nl/mail/tips2.htm
>
> On Mon, Jun 6, 2011 at 11:48 PM, Mahesh parab wrote:
>
>> Hi
>>
>> which version of Excel you are using ?
>> in 2007 its .SendUsingAc
Hello Group Members,
Is it possible to add file name in consolidated sheet???
Pls suggest..
Regds,
Manish
-- Forwarded message --
From: ashish koul
Date: Oct 28 2010, 7:36�pm
Subject: $$Excel-Macros$$ How to consolidate the data using macro
To: MS EXCEL AND VBA MACROS
try
el but don't know how to do that? For e.g. I
want to import "item" table with only the records whose item code
starts with FG and only "code" and "unit price" fields.
Can an
el but don't know how to do that? For e.g. I
want to import "item" table with only the records whose item code
starts with FG and only "code" and "unit price" fields.
Can an
Hi Paul,
Thanks aton
It's working perfect
And I done it for userform2... :)
Learned alot
Thanks once again for your continuous help/guidance :) :) :)
Regds,
Manish
On Feb 7, 10:16�pm, Paul Schreiner wrote:
> Manish,
>
> I'm sorry... I've been away f
Any help pls.
-
Manish
On Feb 7, 12:12 pm, Manish wrote:
> Dear Paul & EE,
>
> I want to write the value of userform in same PRA worksheet in column
> T:AA in same row.
>
> For example: if user enter the value is in PRA Sheet column M8,
> userform will write the value i
("PRA").Cells(CellRange.Row, "Z") = TextBox7.Value
Sheets("PRA").Cells(CellRange.Row, "AA") = TextBox16.Value
Can anyone please incorporate it in my excel file.
I am mailing my file on excel-macros@googlegroups.com
Regds,
Manish Pansari
On Feb 1, 7:26 pm, Manish wrot
Hey... Gr8...
Thanks for reply...
You all are just Wow !!! !!
Regds,
Manish
On Feb 6, 2:01 pm, "Ms-Exl-Learner ."
wrote:
> Hi Bhushan,
>
> Sumproduct can be used when the result is Numeric Value.
>
> Have a look in the attached excel for r
Also Sumproduct is useful for numaric value.
Is there any other formula, that will work as SUMPRODUCT for text??
Pls suggest.
On Feb 5, 11:05 am, Manish wrote:
> Is it possible to hide the complete row based on lookup value??
> For example in your solution, if i lookup value x than i w
blank rows.
pls suggest the code OR upload the example file for reference.
Thanks !!
-
Manish
On Feb 2, 6:41 pm, ashish koul wrote:
> @bushan
>
> mail your file to id excel-macros@googlegroups.com and attach the file
>
>
>
>
>
> On Wed, Feb 2, 2011 at 4:42
suggest the code OR upload the example file for reference.
Thanks !!
-
Manish
On Feb 1, 11:23�pm, "Ms-Exl-Learner ."
wrote:
> Hi Bhushan,
>
> Have a look in the attached files.
>
> I never suggest array formula when the same can be do
Thank Paul,
I don't have ops to attach file on group. Can I send you my file
through mail on your personal mail id?
-
Manish
On Jan 31, 7:57 pm, Paul Schreiner wrote:
> Was able to finish writing scripts to load all tables (1,384,800 records).
> Now just have to wait to get a "
,
Manish
On Jan 25, 6:38�pm, Paul Schreiner wrote:
> I've got a macro running right now, so I cannot test the code, but I can
> describe it!
>
> Right-click on your sheet name "tab" and select "View Code".
> In the VBA editor panel, in the Top-left pull-down, sel
Thanks Paul.
My column is selectable.
If user select/edit in the cell e.g. B3, i want to open the user form
and want to write user form value in same row i.e. row3 in column C to
H. And also i want to put total CtoH in column B.
Thanks in advance.
Regds,
Manish
On Jan 25, 5:54 pm, Paul
, I want to write the data of user form in same sheet active
row column C to H.
I know the write the user form data in new worksheet, but I don’t know
the code to write the data in active row and also the code for open
the Userform, if my cell is locked.
Pls help.
Thanks in Advance…
Regds,
Manish
Hey Thanks Manoj...
Now its working and serve my purpose.. :)
Regds,
Manish Pansari
+91 9810 88 8281
On Jan 19, 3:02 pm, Manoj kumar
wrote:
> ok ...just checked the function, the reason why it is taking much time to
> process the values because the column range is too large(here
>
y to learn language. :)
Thanks experts in advance.
Regds,
Manish Pansari
--
--
Some important links for excel users:
1. Follow us on TWITTER for tips tricks and links :
http://twitter.com/exceldailytip
2. Join our Link
Any Help Pls..
-
Manish
On Jan 18, 5:42 pm, Manish wrote:
> Thanks Manoj.
>
> It’s really what I was looking for. But it is taking too much time to
> process the result.
> Is it possible to make it faster ??
>
> My excel getting stuck/Not Responding, while I change/add t
Thanks Manoj.
It’s really what I was looking for. But it is taking too much time to
process the result.
Is it possible to make it faster ??
My excel getting stuck/Not Responding, while I change/add the data or
copy the formula in another cell.
Pls suggest. Thanks in advance.
Regds,
Manish
is it possible or not??? :(
any help pls.
-
Manish Pansari
On Jan 14, 11:21�am, Manish wrote:
> Dear Group Friends,
>
> I have two work sheet. Sheet1 contain bill number in column B, and
> sheet2 contain bill number and PRA No in column A and column B.
>
> My pro
3 M-02, M-10
FDN/04 M-04, M-08
I know the concatenate formula. but for that i have to apply it
manually.
Please assist me, how can i make it automatic. When I entered new PRA
No. in sheet2, Sheet1 PRA Nos. get automatically update.
Thanks for your regular help and suggestion.
Regds,
Mani
Congratulations Dilip... :)
Regds,
Manish Pansari
On Jan 5, 7:19 pm, Kal xcel wrote:
> Hi Dilip,
>
> Many many congratulation to you. This group needs you. Keep it up.
>
>
>
> On Wed, Jan 5, 2011 at 4:45 PM, SUMIT VYAS wrote:
> > Dear Mr. Dilip
>
> > *C
Thanks Ashish
Thanks Dave.
-
Manish
On Jan 13, 7:14 am, Dave Bonallack wrote:
> Hi Manish,
> Place this code in the appropriate VBA sheet window
>
> Private Sub Worksheet_SelectionChange(ByVal Target As Range)
> If Target.Column = 2 Then Cells(Target.Row, 3).ClearContent
advance.
Thnxs,
Manish
--
--
Some important links for excel users:
1. Follow us on TWITTER for tips tricks and links :
http://twitter.com/exceldailytip
2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid
Thanks :)
Its working well. . .. . . .
Thanks alot to all supportive members
Regds,
Manish
On Dec 31 2010, 5:02 am, ashish koul wrote:
> hi manish
>
> check this link you can hide all the sheets and make user to click on
> enable macro to make that sheet visib
Wish you all Very Happy New Year !! :)
Regds,
Manish
On Dec 31 2010, 3:21 pm, lucky singh wrote:
> Wish u the same dudue
>
> does any one has excel greetings for new year if yes den plz do forward it
> to me
>
> Regards,
> Lucky
>
> On Fri, Dec 31, 2010 at
Again, unless i will not enable the macro, i can change in the locked
cell :( :(
How can I enable the macro automatically, if the user open the xl
file. I hope my requirement is clear and hope such option is available
in VBA.
Regds,
Manish
,
Manish
On Dec 30, 1:10 pm, ashish koul wrote:
> b is column no 2
> g is column no 7
>
> target.row will select the row
>
>
>
>
>
> On Thu, Dec 30, 2010 at 1:39 PM, ashish koul wrote:
> > **Private Sub Worksheet_Change(ByVal Target As Range)
> > If Targ
Hi Premal,
Today, i uploaded one new file on our group "Excel_tutor.xls"
Try this, it will help you...
Regds,
Manish
On Dec 30, 9:32 am, Premal wrote:
> Hi,
> I am very new to VBA. I know C++.I have few questions related to Excel
> programming.
> 1) I have two xls files
Thanks Ashish,
This is perfect as i want.
I need some more help, If i want to lock only column B to G (not want
to lock entire row) than what will the code.
I want to understand the diff in codes. :)
Thanks once again for your help.
Regds,
Manish
On Dec 30, 10:31 am, ashish koul wrote
Any help/suggestion ???
Thanks,
Manish
On Dec 29, 3:03 pm, Manish Pansari wrote:
> Dear EE,
>
> Is it possible to lock the entire row/selected cell based on condition
> in particular Cell.
> for example, I want to lock the row based on value in column A. If
> macro found valu
There is no option available. :(
pls suggest...
Regds,
Manish Pansari
--
--
Some important links for excel users:
1. Follow us on TWITTER for tips tricks and links :
http://twitter.com/exceldailytip
2. Join our
uggest me the code.
Thnxs,
Manish
--
--
Some important links for excel users:
1. Follow us on TWITTER for tips tricks and links :
http://twitter.com/exceldailytip
2. Join our LinkedIN group @ http://www.linkedin.com/
Hi Anand,
Thanks for your valuable suggestion.
Pls fwd me the link for ebook. I want ebook on Excel VBA.
Thanks in advance !! :)
Regds,
Manish Pansari
On Dec 9, 12:28 pm, anandydr wrote:
> Hi,
>
> If you do a google search for the term MS Excel VBA tutorials you will
> find a lot
Excel Experts,
Is it possible to send message (SMS) through MS Excel.
If yes, Pls give me an idea or some sample macro file.
Thanks,
Manish Pansari
--
--
Some important links for excel users:
1. Follow us on
email. :)
Thanks in advance.
Regds,
Manish Pansari
+91 9810 88 8281
On Nov 29, 11:54 am, in.vaib...@gmail.com wrote:
> Hi Again,
>
> I can generate in PDF for that u will require to have Office 2007, but
> password protection is not possible at present.
>
> Is it OK.
>
>
Any help pls
On Nov 25, 10:53 am, Manish Pansari wrote:
> Hi Paul,
>
> Thanks a ton for your help.
>
> I am financial guy and I know only 20% coding in VBA. I am on the way
> to learn VBA.
>
> I get an idea with following code. I need one textbox in same form
>
UserForm1.Show
End Sub
User Form:
Private Sub OKButton_Click()
ActiveCell = ListBox1.Value
Unload Me
End Sub
I don't have rights to shere my file on group. How can i shere my file
with you?? Thanks in advance.
-
Manish
On Nov 24, 7:53 pm, Paul Schreiner wrote:
> Sorry
Hi,
Any help please
Thanks
On Nov 24, 11:17 am, Manish Pansari wrote:
> Hi All members,
>
> I have data in more than 2000 rows. I created drop down list through
> data validation option in excel. But its very hard and difficult to
> search the required name through long li
open and I can search the value (Colm
A:A Value) and insert it in active cell. My idea is like MS Outlook
contact book, when we want insert contact, we can search and select
the required contact.
Pls help me.
-
Manish
Hi Jose,
I am very new in excel macros...
Can you pls share your macro file with me, I am also want to
transparent one user form in my module.
Thanks in advance.
Manish
pansari.man...@gmail.com
On Nov 18, 3:11 pm, Alfred WALLACE wrote:
> Hi to all gurus (day gurus, or night gurus !)
>
thanks a lot this works like . this is the best ive ever seen
regards
manish
On Jun 4, 4:30 pm, Swapnil Palande wrote:
> Hi Manish,
>
> Actually I am not getting what exactly you want.
>
> Do you want the sheets name as submenu item in menu bar. In that case please
> find
thanks a lot swapnil it works like zip
manish
On Jun 4, 4:30 pm, Swapnil Palande wrote:
> Hi Manish,
>
> Actually I am not getting what exactly you want.
>
> Do you want the sheets name as submenu item in menu bar. In that case please
> find attached excel for solution.
>
&
sheet Menu Bar").Controls("MyTools")
For i = 1 To ActiveWorkbook.Worksheets.Count - 1
myarray() = ActiveWorkbook.Worksheets(i).Name
.AddItem myarray()
Next i
End With
End Sub
regards
manish
On Jun 4, 4:30 pm, Swapnil Palande wrote:
> Hi Manish,
>
> Actually I am not getting what exactly you want
dear swapnil
this coding is working and gives a POPUP MENU SHOWING number of
worksheets. Is there other way to add worksheets in a combobox in the
menu you created so that if we click that particular sheet we can
navigate to the clicked sheet using your menu
regards
manish
On Jun 3, 6:33 pm
ol
For i = 1 To ActiveWorkbook.Worksheets.Count - 1
myarray() = ActiveWorkbook.Worksheets(i).Name
.AddItem Text:=myarray(), Index:=i
Next i
DropDownLines = i + 1
.DropDownWidth = 75
.ListHeaderCount = 0
End With
End Sub
thanks in advance
r
Dear Excel Guru's,
I want to create an macro, by that in a single click, my excel sheet
will get translated in whatever language i will select. Is it possible
through macro. give me some hint so i will develop some code and will
take further help from your side.
Regds,
M
. Specific Name for example "Manish", if in column ‘A’ name Manish is
appeared than macro will delete the row.
Hope my text is self explanatory and it’s possible to set two
criteria to delete row.
Please help me, this will save my lot of time and will make easy my
daily activity.
Thanks
than macro will indicate that "The same name is as another
sheet" and user can define a new name through user box for new
worksheet.
I think it is possible through macro. Please help me.
Thanks in advance.
Reg
Hello friends,
Any one tell me how i can use spelling check option in user form? I
devloped one macro in which i want to use spelling check option user
form. Is it possible? Please assist me.
Thanks in advance.
Regds,
Manish
master sheet is linked only with one worksheet.
My problem is, I want to write the name of worksheet and row number in
master sheet, in which that particular row figure is linked. Is it
possible through any formula, if you please help me.
Thanks in advance.
Regds,
Manish
it possible through Excel, if yes, how?
-
Manish
On Dec 16, 4:30 pm, ashish koul wrote:
> hi
>
> check the attchment
>
> i made it for my own purpose it send the email to all the email ids
> mentioned in col b
>
> with different attachmnet as in col e and col f
>
>
Hello all,
I have one problem in excel macro, but i m not be able to upload my
file on our group. :(
How i can move forward to solve my problem... ..
My mail ID is pansari.man...@gmail.com, mail me if you want to help me
out this proble . :)
Thnxs,
Manish
Yes
Sheet4 YesYes
How I can do this, pls help me. I want to assign separate macro
commend for hide/Unhide and print sheet.
Thnxs in advance.
-
Manish
good reply
manish
- Original Message
From: Ayushj
To: MS EXCEL AND VBA MACROS
Sent: Wed, October 14, 2009 8:36:33 AM
Subject: $$Excel-Macros$$ Re: Plz help in this problem (excel)
Hi Abdul,
You can use ceiling function to get the desired output.
CEILING(number,significance
Thanks alot guys... .. .. :)
I get it . ...
-
Manish
On Oct 12, 8:59 pm, Harmeet Singh wrote:
> Thanks & Regards,
>
> Harmeet Singh
>
> Sent via BlackBerry Wireless
>
>
>
> -- Forwarded message --
> From: Harmeet Singh
> Date: Mon,
in different category
like "To" & "Cc". Can through macro I can mark a single mail to more
than one person? How its possible? Can anyone please suggest me the
CODE or upload a sample file for code.
T
Hi Praveen,
I think either you can define all 40 links in one workbook and than
you link that cell reference in macro.
Otherwise, Its better to upload a example sheet of the same.
-
Manish
On Oct 11, 12:13 pm, Praveen Khunte wrote:
> Hi Everyone
> There is a specific requirement I came
Hello Friends,
I want to run a macro continuously after every five minutes. Is there
any option, by using that I can set macro run time and can run macro
automatically?
Thanks,
Manish
reen field only".
Any one can pls help me tht how can I devlope the same. If any one can
attach a sample file, than it will be more easy for me to learn and
understand.
Thanks a ton...
-
Manish
pans
Hi everyone..
Any one can provide me the password crecker for MS Office/Excel.
Actually I forget my own MS file password. :(
-
Manish
On Oct 1, 3:08 pm, Anish Shrivastava wrote:
> Hi Ram,
>
> Actually I got tht passware from my frnd. It works nicely to crack MS Office
> passwords
ive forgot password to the new project & macro i have created in VB
excel. how to recover that macro password. can someone please tell me
the method to find it.
regards
ma
is wasted it is ultimately waste of life."
Planning plays important role in exploring potential of time. Hence it is
said "FAILING TO PLAN IS PLANNiNG TO FAIL
Good Day
Manish
--~--~-~--~~~---~--~~
--
Relations & medicine play the same role in our life. Both care for us in
pain.
Only difference is that relationship doesn't have an expiry date..!
Hence, person cannot be wealthy untill he has something which money cannot
buy.
Regards
--~--~-~--~~~---~--~~
---
“When you are in light every one will follow you-but-When you are in dark
nobody will follow you, Not even your own shadow- THAT IS TRUTH of life”
Hence- in life you don't need too many relationship, you need only
relationship which has life in it.
--~--~-~--~~~---~--~
TRY is a small word that can make a big difference... If we TRY, we only
RISK FAILURE, but if we don't even TRY then We'll ENSURE FAILURE...!
Hence a very good and meaningful punch line
"If I think I can, I CAN,
but,
if I think I can't, I am Right.
We can do the subtotal in one cell only.
Find the attached excel file for the solutions
Manish Purohit
Imagination is more important than knowledge. Knowledge is limited.
Imagination encircles the world.
_
From: excel-macros@googlegroups.com [mailto:excel-mac...@googlegroups.com
Sub Insertequals()
Dim cel As Range
For Each cel In Selection
If IsNumeric(cel.Value) Then
cel.Value = "=" & cel.Value
End If
Next
End Sub
Manish Purohit
Imagination is more important than knowledge. K
Hi Dhananjay,
Find the attached excel file with the solution.
You can use N( ) to treat any string as 0.
Manish Purohit
Imagination is more important than knowledge. Knowledge is limited.
Imagination encircles the world.
_
From: excel-macros@googlegroups.com [mailto:excel
hi
use this formula in B1 cell.putting value in a1 cell.
=IF(ISERROR(FIND("-",A1)),A1,CONCATENATE("-",SUBSTITUTE(A1,"-","")))
On 8/4/09, Putta Madaiah wrote:
>
> Hi All,
>
> Can any one tell me the formula to get the value as in Required answer as
> against Original Value.
>
> *Origi
Could you attaché the excel file.
Manish Purohit
Imagination is more important than knowledge. Knowledge is limited.
Imagination encircles the world.
-Original Message-
From: excel-macros@googlegroups.com [mailto:excel-mac...@googlegroups.com]
On Behalf Of Telenochek
Sent: 25 July 2009
You can use replace all and in find area put ".com*" (without quotes) and in
replace area put ".com".
Manish Purohit
Imagination is more important than knowledge. Knowledge is limited.
Imagination encircles the world.
-Original Message-
From: excel-macros@googlegrou
Distance distance Distance
BhopalDistance 0 Distance
Distance
Delhi Distance Distance 0
Distance
BangaloreDistance Distance Distance 0
--
Manish Kurrey
NITIE
Hi,
I think it will work better without using any variable.
Try using the below code
Sub PasteAsValue()
Range("A1").Copy
Range("A1").PasteSpecial xlPasteValues
End Sub
Regards,
Manish Purohit
Imagination is more important than knowledge.
Thanks ruchi
--- On Fri, 6/5/09, god is gr8 i love u wrote:
> From: god is gr8 i love u
> Subject: $$Excel-Macros$$ tip for the day
> To: excel-macros@googlegroups.com
> Date: Friday, June 5, 2009, 10:55 PM
> Hi Everyt one
>
> I am Ruchi
>
> Tip 4 the
> competition
>
> F11 is a short
Select all cell which u want to remove Total Charge then
do Ctrl+H ,write " total charge" in find row and in replace it with ("
")blank.
On 5/12/09, subs wrote:
>
>
> hi
>
> i have data like this in the column of the excel table
>
> total charge: apl total charge:ppg total
1 - 100 of 109 matches
Mail list logo
