all the times you can,To all the people
> you can,As long as ever you can.” - John Wesley*
> ---------
>
>
> On Saturday, October 7, 2017 7:48 AM, Ram Prakash Palaniswamy <
> ramcb...@gmail.com> wrote:
>
>
> I have a master excel file (
I have a master excel file (ABC.xls) which has n number of rows and
columns.
And also i have another excel file (DEF.xls) which has limited number of
same data from the master excel file (ABC.xls).
I need a macro code for if i update some values in the master excel file
(ABC.xls), automatica
hye bro.. PFA
With video on youtube
https://www.youtube.com/watch?v=iJSdaoGAG-A
and confirm me
On Friday, March 31, 2017 at 5:30:44 PM UTC+5:30, sourav devrani wrote:
>
> Hey Champs Please see my data validation query.
> and please let me know when you solved it.
>
--
Are you =EXP(E:RT)
Hi champs,
script error how to off & print option off ??
--
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.
hey hi change the data base not working pls explain me ...? bro...
On Tuesday, February 28, 2017 at 11:05:50 AM UTC+5:30, a.gowri wrote:
>
> PFA
>
> On Mon, Feb 27, 2017 at 4:18 PM, Ram ji
> > wrote:
>
>> hey anyone solve the query
>>
>> --
>> A
hey anyone solve the query
--
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
Hey ,
I am Ram ji from Noida , currently I am working as Business Analyst in
BT data and surveying services india pvt. ltd. Keen to learn more about
Excel macros and vb code.
Thanks
Ram ji
On Saturday, June 9, 2012 at 12:51:59 AM UTC+5:30, Ayush Jain wrote:
>
> Hey all new and c
Just change custom formatting --
Select data range
right click
go to format cell
go to customer in number tab
paste this - dd/mm/
[image: Inline image 1]
On Mon, Jul 11, 2016 at 10:54 AM, Izhar wrote:
> Please open the file, I've given everything in the attach file
>
> --
> Are you =EXP(E:
+5:30, Mandeep Baluja wrote:
>
> Create a calculated field and set the format of text according find the
> result attachment.
>
> Thanks
> *Mandeep baluja <http://vbaexcelsql.blogspot.in/>*
>
> On Monday, November 17, 2014 2:11:34 PM UTC+5:30, ram gopal yadav wrot
calculate the change in pivot itself and hide
the blank automatically.
Please find the enclosed template file
Looking forward for your response asap.
Regards.
RAM GOPAL YADAV
Contact-08130155401
--
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) !
i have 20 digit number in my excel sheet, but when i move this number into
another cell then it display in 9.71E+15 like this. i want to move this
number using macro programming and display excatly number not 9.71E+15
value.
how i can do this?
--
Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel?
Hi,
I need help urgently
how to copy value from an object (i have copy objects from web page)
Thanks in advance
--
Regards,
Santy
--
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
Hi,
can u please share some example sheet.
On Tue, Jun 18, 2013 at 9:25 PM, Manjunath Narayanappa <
manjunath.narayana...@aon.co.uk> wrote:
> Dear expert,
>
>
>
> I have a spreadsheet where every month I need to delete more than 500 rows
> manually. Is there any macros automatically data shou
Exactly Priti you are right but your formula is not working ... as i
observe that you are just want increase your post count ..
in this group we will try to provide top best solution not a temporary
solution
I totally agree with sunny...
On Wed, May 8, 2013 at 5:04 PM, Sant Ram wrote
Exactly Priti you are right but your formula is not working ... as i
observe that you are just want increase your post count ..
in we will provide top best solution not a temporary solution
I totally agree with sunny...
On Wed, May 8, 2013 at 11:26 AM, priti verma wrote:
> Hi Sunnny ,
> somet
You can also you use formula
like =SUBSTITUTE(E2,",","")
On Tue, May 7, 2013 at 1:30 PM, Ahmed Honest wrote:
> Hi Danial :
>
> Press Ctrl + H and then
>
> in find what box keep comma , and in replace leave it empty and click
> Replace All it shall help...
>
>
>
>
>
>
>
> On Tue, May 7, 2013 a
Hi maksood,
you can use series function with column selection..and in step value put 7
and Stop value put end date
[image: Inline image 1]
On Tue, May 7, 2013 at 6:05 PM, maksood alam <786maks...@gmail.com> wrote:
> Hi guys,
>
> I have to select two dates, start date and end date. e.g. start d
Hi Amar,
If you are using Database function ..please ensure that all header name are
same i.e.. database,field, and criteria...
Your formula is working fine.. but you have changed header name see cell H11
Regard,
Santy
On Wed, Apr 24, 2013 at 3:29 PM, अनिल नारायण गवली
wrote:
> Dear Amar,
>
prospects.*
*
*
*And i m very much thankful to u if u can suggest me someone in delhi who
taught the course or some online mentor.*
Thanks Again
On Sunday, 23 September 2012 09:57:47 UTC+5:30, ram gopal yadav wrote:
>
> Hi all,
>
> Please tell me the books or video links useful
Ram Gopal Yadav
Research Analyst-Agri Commodities
Noida
New to VBA -- need help how to start i.e, from basic
Hope i will be learn VBA..
On Saturday, 9 June 2012 00:51:59 UTC+5:30, Ayush Jain wrote:
>
> Hey all new and current posters,
>
> Welcome to excel group,one of the la
Hi all,
Please tell me the books or video links useful for learning macros and VBA.
Looking for valuable advice. Thanks in advance.
Regards.
RAM GOPAL YADAV
Mobile No's:- 08130155401,
--
Join official facebook page of this forum @
https://www.facebook.com/discussexcel
FORUM RULES
---
ram xls wants to stay in better touch using some of Google's coolest new
products.
If you already have Gmail or Google Talk, visit:
http://mail.google.com/mail/b-3eef7fee2f-d708a7464d-N2KpHZIBXSmpNn-XvDhHYwvWYUk
You&#x
>
> Can you help on below. I want to convert
> the data in the big table below in the Following
> Format..Any formulas to do that?
>>
>> I
>>
>> Ozip.DestzipM
>>
>> 8810. 7188 33.8
>> 8816. 7188 28.07
>>
> And so on
>
>> I want to convert below bi
Congrates for fice year...
And thanks
Regards
Ram
On Mar 23, 2012 12:12 AM, "NOORAIN ANSARI" wrote:
> जहाँ Excel के दीवानों की, है बहूत घनी आबादी.
> जहाँ Question,Answer करने की,है खूब आज़ादी.
> जहाँ के पोस्ट को follow कर-कर के,कितनो का Career खुशहाल हो गया.
>
Happy holy to all
On Mar 8, 2012 2:21 PM, wrote:
> Dear all,
>
> Wish you Happy holi.
>
> Sandeep Chhajer.
> Sent on my BlackBerry® from Vodafone
>
> --
> FORUM RULES (986+ members already BANNED for violation)
>
> 1) Use concise, accurate thread titles. Poor thread titles, like Please
> Help, U
Sam
Awesome as always! Thanks again
On Feb 27, 2012, at 10:30 AM, Sam Mathai Chacko wrote:
> No it isn't, it's just that it's a safe practice Maries
>
> On Mon, Feb 27, 2012 at 8:29 PM, Maries wrote:
> Hi Sam,
>
> Is "Double Minus" required?
>
>
> On Mon, Feb 27, 2012 at 5:47 PM, Sam M
Ashish
Can u pls give instructions on how to use this
On Feb 21, 2012, at 11:31 AM, ashish koul wrote:
> Hi group
>
> Please try the updated add-in. Its free . Hope you will like it
>
> http://www.excelvbamacros.com/2012/01/my-menu-functions-and-help.html
>
> --
> Regards
>
> Ashish
Hi Noorain
Can u give a macro for this urgently
On Jan 13, 2012, at 9:55 AM, NOORAIN ANSARI wrote:
> Dear Lokesh,
>
> Please try it..
>
> Sub Copy_and_Delete_Text()
> Dim rng, rng1, rng2 As Range
> Dim i, j As Long
> Set rng = Sheet1.Range("A1:A" & Sheet1.Range("A65536").End(xlUp).Row)
> rng.
Happy Birthday Noorain
Sent from my iPhone
On Jan 3, 2012, at 9:34 AM, NOORAIN ANSARI wrote:
> Thank you very much to all of you.
>
>
> --
> Thanks & regards,
> Noorain Ansari
> http://excelmacroworld.blogspot.com/
> http://noorain-ansari.blogspot.com/
>
> On Mon, Jan 2, 2012 at 8:22 PM, Ra
ding breaking or bypassing any security
> measure.
>
> 4) Acknowledge the responses you receive, good or bad.
>
> 5) Cross-promotion of, or links to, forums competitive to this forum in
> signatures are prohibited.
>
> NOTE : Don't ever post personal or confidential data in a workbook.
Hi all,
Kindly tell me that from where i can learn advanced excel in
noida(U.P).
please tell me the best institute/faculty in noida from where i can
lear macro and VBA
Thanks in advance.
Ram Gopal
8130155401
ot.com
>
> To post to this group, send email to excel-macros@googlegroups.com
>
> <><><><><><><><><><><><><><><><><><><><><><>
> Like our page on faceboo
congratulation Rajan,Ashish,Dilip,Venkat,Sunny (XLS
S),Noorain..
On Wed, Aug 3, 2011 at 10:52 PM, 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
congratulation ayush
On Tue, Jul 26, 2011 at 9:22 AM, Ayush wrote:
> Dear members,
>
> I am glad to share that this forum has achieved two major milestones this
> month. The number of members have reached 8000 and 1000 posts in a month
> which is highest in forum history.
> The credit goes to ea
use formula
=IF(iserror(ur formula),"",ur formula))
On Sun, Jul 24, 2011 at 5:50 PM, vijayajith VA wrote:
> Hi,
>
>
> I have one questions.Usually while doing reports what are errors you will
> get ?
>
>
> Thanks
>
> --
>
> -
*Experience required for the Job:* 2 - 4 years
*Annual Salary of the Job:* 2.0 - 3.0 Lacs
*Job Location:* Delhi/NCR
*Dear Candidate,*
Hi,
We have an urgent requirement of MIS/Sr MIS Executive at our head office at
Okhla.
Company profile: CPM India is leading organization in sales marketing which
thanks ranjan
it's work fine...
On Tue, Jul 12, 2011 at 9:21 PM, rajan verma wrote:
> Use =Inword(YourDigit) after installing attached add ins
>
>
> On Tue, Jul 12, 2011 at 9:10 PM, Ram Naresh Verma
> wrote:
>
>> Hi Groups member,
>>
>> I want if i ente
Hi Groups member,
I want if i enter any numaric value in a cell, now i have to convert it into
spelling in english. Please suggest i have to make manual work for it every
time.
--
Regards,
Ram Naresh
--
--
Some
MS Excel Expert (Macro / VBA)
2 Opening(s)
Shanti Consultants
*
*
Summary
*Experience:*
3 - 6 Years
*Location:*
Delhi, Delhi/NCR, Noida
*Compensation:*
Rupees 3,00,000 - 6,00,000
*Education:*
UG - B.Sc - Computers,BCA - Computers PG - PG Diploma - Computers
*Industry Type:*
Oil an
Hey,
please provide the SUMPRODUCT , SUBSTITUTE and ARRAY formula's
how to use and instruction
--
Regards,
Santy C
--
--
Some important links for excel users:
1. Follow us on TWITTER for tips tricks and links :
Hey,
try my attachment
i think my formula is very simple so please try
Regards,
Santy C
On Mon, Jul 4, 2011 at 10:13 PM, Haseeb Avarakkan <
haseeb.avarak...@gmail.com> wrote:
> Hello,
>
> If you want to count the unique numbres in a range, use this with just
> Enter, *
Hey Boss,
Congratulation.
On Sun, Jul 3, 2011 at 8:15 PM, ashish koul wrote:
> Thank You All..
>
> On Sat, Jul 2, 2011 at 10:37 AM, Brajesh Kumar Porwal <
> brajeshkumarpor...@gmail.com> wrote:
>
>> *Congratulations Ashish keep it up
I want to have a formula so that in one cell if i type 1,00,00.00 i.e.
one lac it can be converted in words in other cell.pls advice.
--
--
Some important links for excel users:
1. Follow us on TWITTER for tips tricks
Hi Excel Masters,
Could any one have MS-Excel Bible by john walkenbach e-book.
if so could please send it to me at 06n...@gmail.com.
Thanks in advance,
Nani Ram
--
--
Some important links for excel users:
1
--
Thanks and Regard
ramkumar.m
HAVE A NICE DAY FRNDS:)
--
--
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 @ h
Hi All,
Does anybody have games in excel sheet, if so please send me.
Thanks,
Naniram
--
--
Some important links for excel users:
1. Follow us on TWITTER for tips tricks and links :
http://twitter.com/exceldailyti
Hi Excel Lovers.
Could any one have this book "Excel 2007 Power Programming with VBA" by *John
Walkenbach*.
If not this book, can any one provide me material to learn basic VBA on
Excel.
Thanks,
Naniram
--
--
Some
Hi Members,
i have huge data with hyperlinks.
Is there any shortcut key or formula to remove all hyperlinks at once.
Thanks,
Naniram
--
--
Some important links for excel users:
1. Follow us on TWITTER for tips tri
nice documents
Thanks,
Naniram
On Sat, Mar 13, 2010 at 10:43 AM, big smile wrote:
>
>
> --
>
>
>
> -- Subject: Short Keys
>
>
>
>
>
>
>
>
>
> --
>
> Mother Teresa:- If we cannot love the person whom we see, how can we love
> god, whom we cannot see ?
>
> --
>
> -
I am working Fees section. I want Student due list easily taken with
excel format how any idea, fees details all in excel format only
--
--
Some important links for excel users:
1. Follow us on TWITTER for tips tric
Dear all,
I need your help in formula, i need correct formula to get daily total
salary and ot amount..
please help me.. i have send the attachment too..
Thank®ards,
Ram
Dear all,
I need your help in formula, i need correct formula to get daily total
salary and ot amount..
please help me.. i have send the attachment too..
Thank®ards,
Ram
Thanks paul.. As i too didn't get any idea than which you have specified
belwow, i too used the macro function to check.
Anyways thanks once again paul:)
Regards,
Ram.
On Mon, Apr 13, 2009 at 6:36 AM, Paul Schreiner wrote:
> Well... to answer your EXACT question,
> there isn
Hi,
Is there any function to find whether the word entered in a cell is fully in
upper case or lower case or in mixed case?
Can any one please help me as soon as possible...
--
Thanks and Regard
ramkumar.m
HAVE A NICE DAY FRNDS:)
--~--~-~--~~~---~--~~
--
there any way to do
this..??
Please help me. Can we do this without VBA.
Thanks
Ram.
--~--~-~--~~~---~--~~
Visit the blog to download Excel tutorials at
http://www.excel-macros.blogspot.com
To post to this group, send email to excel-macros@googlegroups.com
For
Hello all,
Pls explain me what do mean by array in excel??
Thanks.
--~--~-~--~~~---~--~~
Visit the blog to download Excel tutorials at
http://www.excel-macros.blogspot.com
To post to this group, send email to excel-macros@googlegroups.com
For more options, visit
Hi all,,
I have attached the file, and explained the proble there only. I wanted to
pick amount from another table by formula. I tried with vlookup i didnt get
answer. Pls help me.
Regards,
Ram.
--~--~-~--~~~---~--~~
Visit the blog to download Excel tutorials
Hello all,
Could you pls explain me how to lock cells in the below scenario:
- How to lock single cell
- How to lock range of cells
- how to hide the formula only for formula based cells.
Regards,
Ram.
--~--~-~--~~~---~--~~
Visit the blog to download Excel
58 matches
Mail list logo
