Thank you so Much
What an idea sir ji,,
Amit Jaggi
- Original Message -
From: Daniel
To: excel-macros@googlegroups.com
Sent: Wednesday, February 24, 2010 9:43 PM
Subject: RE: $$Excel-Macros$$ Fw: Drop Down List
Hello.
Have a look at the attached file. I have
That's my goal as well. It is fun.
On Monday, April 13, 2020 at 5:02:28 AM UTC-4, RISHABH KESHARWANI wrote:
>
> Hi everyone,
>
> My self Rishabh want to build a career as an Excel Expert. I have used
> basic excel during my job. Tos do work in excel with formula
plies.
Regards
Kannan V
--
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 P
Hi,
Please find the below mail and help me as soon as possible...
regards
Kannan V
-- Forwarded message --
From: Kannan Excel
Date: Wed, Mar 12, 2014 at 4:13 PM
Subject: $$Excel-Macros$$ MIS MASTER DATA FORMAT
To: Google
Hi,
Please send any MIS master data format. Because
Hi Ganesh,
Use the below formula.
For Forecast 1 =SUMPRODUCT((MONTH($B$3:$DC$3)=MONTH(B$10))*$B$4:$DC$4)
For AHT
=SUMPRODUCT((MONTH($B$3:$DC$3)=MONTH(B$10))*$B$5:$DC$5)
Regards,
Excel Beginner
From: excel-macros@googlegroups.com [mailto:excel-macros
Dear Friends,
Please find the attached file of excel, I have a doubt in that excel.
I checked the excel there is no formula and VBA coding but it is showing
duplicates.
How to do this in other excel... Please help me
--
Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s
Dear Ganesh,
Thank you...
Now i understood...
On Wed, Apr 30, 2014 at 11:33 AM, Ganesh N wrote:
> HI Kannan,
>
> There is In-build option in excel to show the duplicates. Please find the
> below steps.
>
> Home->conditional formatting->highlight cells rules->
rkbook
>> Dim lastrow As Long
>> lastrow = ThisWorkbook.Sheets("Sheet1").Range("a65356").End(xlUp).Row
>> + 1
>> Set wkb = Workbooks.Open(filename)
>> wkb.Sheets("Summary Sheet").Range("e2:j2").Copy
>> Destination:=This
*Dear Friends,*
*Please tell which is the best one, Ms Excel or Ms Access?*
--
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
Dear Friends,
I want to know how to remove password in excel.
Please find the attached file and remove password.
--
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
>
> On Mon, May 26, 2014 at 11:28 AM, Kannan Excel wrote:
>
>> Dear Friends,
>>
>> I want to know how to remove password in excel.
>> Please find the attached file and remove password.
>>
>> --
>> Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do y
Sir,
i created a vba project file (macr0)
someone (friend) put unknown password for it (fun)
how can i recover
it contains imp data
i need urgentely
thanks,
Veer
--
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
Sir,
i sent attached file of my friend ration shop
& pls see out put data
he wanted a macro to generate output data
pls help
regards:
Veerendra
--
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 @
h
thanks a lot guruji
On Fri, Jul 18, 2014 at 9:12 PM, Vaibhav Joshi wrote:
> PFA excel with vba Macro!!
>
> Its more dynamic, click blue button & new sheet will get created.
>
> Cheers!!
>
>
> On Fri, Jul 18, 2014 at 10:30 AM, my excel wrote:
>
>> Sir,
1 PM, daya p wrote:
>
>> Sir,
>> i created 3 macro
>> & i want run all 3 macro at a time
>>
>> means macro1,macro2,macro3
>> macro1 for sheet2 report
>> macro2 for sheet3 report
>> macro3 for sheet4 report
>> pls suggest with example sir
thanks daya brother
On Sat, Jul 19, 2014 at 9:46 PM, my excel wrote:
> Thank you Guruji
>
>
> On Sat, Jul 19, 2014 at 9:19 PM, Vaibhav Joshi wrote:
>
>> Hi
>>
>> you can run macro thru one go by creating macro..
>>
>>
>> Sub AllMacro()
>&
Sir,
i have a excel file its contains customer mobile no
ex:
Jan Feb Mar …. ….. etc 919845098450 09888021555 9.19293E+11 919899989696
9.19845E+11 9.19845E+11 09595959595 +919449449460 9845098430 9845098430
94949494949
[image: Inline image 1]
Q: how to convert to 10 digit mobile no ?
i
just copy paste data to excel
if i select A column data hit on button A column data convert in to 10
digit no...
i want data as text also convert in to number & it must be 10 digit mobile
no
remove 91
remove 0
using = right 10
want in macro button
On Mon, Aug 4, 2014 at 2:03 PM, Vai
is any solution from expert?
On Tue, Aug 5, 2014 at 12:52 PM, my excel wrote:
> just copy paste data to excel
>
> if i select A column data hit on button A column data convert in to 10
> digit no...
>
> i want data as text also convert in to number & it must b
thank you
On Thu, Aug 7, 2014 at 10:00 AM, Vaibhav Joshi wrote:
> check this file.. press Alt + F8 to run macro
>
> Cheers!!
>
>
> On Wed, Aug 6, 2014 at 5:31 PM, my excel wrote:
>
>> is any solution from expert?
>>
>>
>> On Tue, Aug 5, 2014 a
ze.
>>>>
>>>> Cheers!!
>>>>
>>>>
>>>> On Sun, Aug 24, 2014 at 11:24 AM, veeru h
>>>> wrote:
>>>>
>>>>> Hi,
>>>>> I need a help. i am doing my brother small project i completed basic
Sir,
i need on copy data from a folder.
daily i receive 4-5 excel file email from my friends i download that file
in to a folder
on sunday i copied all files in to 1 file
sir need a macro button to copy of all that files in to single workbook
without any data change
using (open dialog window
Sir,
copy all data from folder into 1 workbook sheet wise
choose any folder containing excel file
open new work book run macro that macro it vl copy 1 file sheet to sheet1
than next to sheet2 & so on
thanks
On Sat, Sep 6, 2014 at 1:35 PM, Ashish Kumar
wrote:
> Hi,
>
>
> you
v Bhai,
>>
>> Its Classic, Superb!!
>>
>>
>>
>> Regards
>> Ashish
>>
>
> --
> 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.f
Sir,
i created an add-in for my excel work
but i am trying to write a condition it will only run in Computer Name=
PCEARTH
otherwise sub programs will be disabled automatically or not working
thanks
Sub CompName()
Dim tSName As String
Dim ThisComputerName As String
> here MYADDIN_NAME1.xlam is name of your adding file, replace with your
> adding file name & delete additional file name.
>
>
> Cheers!!
>
> +
> *I did not do this for you. God is here working through me for you.*
>
> On Mon, Sep 22, 2014 at 2:56 PM, my excel
Pramod is it possible to use this login form to excel add-in file
using this authorized user can use (run) add-ins macro
add-in name => ctools
macro names=> get SlNo, Top10, Reports etc
Sir, pls send code for add in if login success than only add-in macros
enable else disable
thanks
On Su
Guru Vaibhav Sir,
is it possible to use this login form to excel add-in file
using this authorized user can use (run) add-ins macro
add-in name => ctools
macro names=> get SlNo, Top10, Reports etc
Sir, pls send code for add in if login success than only add-in macros
enable else disable
mill
wrote:
> Hi,
>
> I am not sure who this is "myxlg...@gmail.com". Please use a different
> mail to solve your queries, as it may confuse me to look for an appropriate
> answer and ask question to the experts.
>
>
>
> On Sun, Nov 2, 2014 at 7:05 PM, my excel
Dear Friends,
Please tell what are the skills required for MIS executive.
--
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
sir, this code from bahri in c# php something
sir pls help convert it to excel macro
thank you
GSM LAC/CID -> loc test
body {
font-family: Verdana, Helvetica, Geneva, Arial,
SunSans-Regular, sans-serif;
font-size:12;
}
td {
font-family: Verdana, Helvetica, Geneva, Arial,
SunS
rd($str[6])));
if ($retcode != 0)
exit("Error: Invalid return code $retcode. Maybe the LAC/CID is
invalid");
$lat = ((ord($str[7]) << 24) | (ord($str[8]) << 16) | (ord($str[9]) << 8) |
(ord($str[10]))) / 100;
$lon = ((ord($str[11]) << 24) | (ord($str[12]) &
;z=15";,
lat.ToString().Replace(',','.'),
lon.ToString().Replace(',','.'));
p.Start();
p.WaitForExit();
}
else
Cons
ies by yourself
>> only ??? without getting help of someone,
>> because you're the only efficient programmer in vba here.And I am new in
>> this field.Can you recommend the best book for vba to me too.
>>
>> --
>> Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Exc
Position: Backend (audit analyst /data analyst)
Location: Gurgaon
Duration: Long Term
EXP : 0-3 years
Salarys 15- 25 Salary per annum
Looking for 3-4 candidates
--
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
WelCome Manju,
Keep posting and learn more and more.
Why you need this thru marco/VBA? Are you familiar with VBA or macor
--
On Sat, Aug 27, 2016 at 11:12 AM, Manju Keerthi
wrote:
> Hi,
>
> I am a beginner in excel i need your help to solve the following scenario
> i need to cr
1).*
>
>
>
>
>
> It is urgent please respond ASAP.
>
>
>
> Thanks in advance
>
>
>
> Thanks,
>
> Keerthi
>
> --
> 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 o
t;
>> *No drop down required”*
>>
>>
>>
>> *And the macro should run automatically when the user start enter the
>> data in user column(cell 1).*
>>
>>
>>
>>
>>
>> It is urgent please respond ASAP.
>>
>>
>>
>>>> *Scenario*
>>>>
>>>>
>>>>
>>>> We need two columns namely User, drop down
>>>>
>>>>
>>>>
>>>> *“IF user enter data in User column(cells) a automatic drop down needs
>>>> to crea
g messages only.
>
> Is there any way to shut off the feature where Outlook adds single quotes
> around an email address when replying?
>
> Thanking You,
>
> Regards
>
> --
> Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s
> =TIME(2,DO:IT,
For list of file name, use enclosed code.
--
On Fri, Sep 2, 2016 at 10:33 PM, Izhar wrote:
>
> Please open the file and see the question
>
> --
> 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
Please add 886006795
--
On Sat, Sep 3, 2016 at 8:17 AM, Ankit Monga wrote:
> Pls add my number 9560718272
>
> On Sep 3, 2016 7:19 AM, "Suhas" wrote:
>
>> Hi, Please add me to the whatsapp excel group. My Nbr +91 9791760609
>>
>> --
>> Are you =EXP
You need to add "Microsoft Outlook 14.0 Object Library" in references
--
On Sat, Sep 3, 2016 at 10:10 PM, Izhar wrote:
>
> Please see the question in the attachment
>
> --
> Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s
> =TIME(2,DO:IT,N:
If the row count is really 60lac than I strongly suggest you to please use
MS-Access for any DB (like MYSql or MSSQL) as Excel have rows limit (10lac
only.)
--
On Tue, Sep 6, 2016 at 1:24 PM, Malungo Tomson Banda <
malungotoms...@gmail.com> wrote:
> I need help breaking a numerical d
Brother, you have to add Outlook reference as well
[image: Inline image 1]
--
On Tue, Sep 6, 2016 at 9:18 AM, GENIUS wrote:
> Sir
>
> I'm waiting for your reply very anxiously
>
> --
> Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s
>
Hi Pirerre,
Please help me understand -
1. Is this in excel only?
2. There is any unique identifier if the blocks are more than one.
Suggestions -
1. We can you us Text to column than use some formulas to make table
2. You can extract value thru using LEFT,RIGHT formula
--
On Wed, Sep 7
-installed/
--
On Wed, Sep 7, 2016 at 3:09 PM, Pravin Lal wrote:
> Dear All,
>
> I have an urgent requirement to extract ONLY the tabluar data in a PDF
> into excel. How can this be done??? Any thoughts?
>
> Text in the PDF should not come into the excel only the data presented in
>
elp me understand -
>> 1. Is this in excel only?
>> 2. There is any unique identifier if the blocks are more than one.
>>
>> Suggestions -
>> 1. We can you us Text to column than use some formulas to make table
>> 2. You can extract value thru using LEFT,RI
sorry typo error,
Can you please upload some sample ASCII file if possible
--
On Wed, Sep 7, 2016 at 8:32 PM, Learner Excel wrote:
> Can you please upload some same ASCII same file if possible
>
> --
>
> On Wed, Sep 7, 2016 at 8:25 PM, Pierre wrote:
>
>> the data is a
ile if possible
>>
>> --
>>
>> On Wed, Sep 7, 2016 at 8:32 PM, Learner Excel wrote:
>>
>>> Can you please upload some same ASCII same file if possible
>>>
>>> --
>>>
>>> On Wed, Sep 7, 2016 at 8:25 PM, Pierre wrote:
>>&g
Attachment missing
--
On Thu, Sep 8, 2016 at 9:59 PM, GENIUS wrote:
> Sir
>>
> Thanks for your follow up, I enable which you have mentioned in the last
> mail but there is another message please see the attachment
>
> right now I have three version of excel i.e. 2007,
ut there is another message please see the attachment
>>
>> right now I have three version of excel i.e. 2007,2010 & 2013, I opened
>> the file in excel 2010 and I also have Microsoft outlook 2010
>>
> --
> Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna
dsheet with two tab:
> Sheet1 has three variable:
>
> NameFirstNameLastName
> abc_xyz abc xyz
> rpm_xyz rpm xyz
>
> Sheet2 has one variable:
>
> Name
> abc_xyz
> rpm_xyz
>
> I need to write an excel formula in
the attachment then how do I automate this task whenever i put a figure
> in column A and run the macro it calculates 17% in column B for more
> details please see the attachment
>
> --
> Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s
> =TIME(2,DO:IT,N:
t;>
>>>>> please add the my number 9811503853
>>>>>
>>>>> On Friday, 5 August 2016 14:16:39 UTC+5:30, Prabhu Pinky wrote:
>>>>>>
>>>>>> Creating WhatsApp group for VBA macro... Pls msg me your contact, if
>&
Please refer below url
https://gist.github.com/jkatricak/801024
http://windowssecrets.com/forums/showthread.php/107929-VBA-code-to-HTML
http://dailydoseofexcel.com/archives/2011/09/20/roll-your-own-html-from-excel-vba/
--
On Sat, Sep 10, 2016 at 12:18 PM, Devendra Sahay <
devendrasahan
Hey please refer enclosed sample workbook (excel table to html code)
--
On Sat, Sep 10, 2016 at 4:35 PM, Dheeraj Bankoti wrote:
> hi
> is any expert there in group who can short out the issue..
>
> Regards
> -- Forwarded message --
> From: Dheeraj Ba
Please go thru below url
http://dailydoseofexcel.com/archives/2015/02/13/converting-an-excel-range-to-html-the-hard-way/
--
On Sat, Sep 10, 2016 at 9:49 PM, Learner Excel wrote:
> Hey please refer enclosed sample workbook (excel table to html code)
>
>
>
> --
>
> On Sat,
tsapp to get added in this group. if anyone missed or not yet added
> even you requested earlier.
>
> Thanks & Regards,
> Prabhu R
>
> --
> 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 thi
No,
you can not add more thn 250 ppls
--
On Tue, Sep 13, 2016 at 2:03 PM, Pol Ktk wrote:
> is there any option in whatsup appln to add unlimited members(in single
> group)
> paid or free ?
>
> On 11 September 2016 at 11:50, Learner Excel wrote:
>
>> Thanks Prabhu!..
Hey,
If you are good in VBA coding then you can search "pdf to excel convert
vba" and take reference.
Please see below the some useful urls-
https://www.linkedin.com/groups/1871310/1871310-74131482
http://quickvba.blogspot.in/2010/12/import-pdf-in-excel.html
http://www.vbaexpr
attached query.
>>
>> --
>> *Kalyan Chattopadhyay*
>>
>>
>> *Executive Corporate MIS*
>>
>> *Joy Cosmetics*
>>
>> --
>> 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) ! J
s two instances of the word "GEORGE".
>
> Thanks.
> .
>
> --
> 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 RULE
ace
> where I can research each individual step in VBA?
>
> Thanks,
>
> Daniel
>
> --
> 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
&
egards,
> Chandru
>
>
> Sent from my Samsung Galaxy smartphone.
>
> --
> 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
S
> 10307973 L
> 10307978 XS
> 10307978 S
> 10307978 M
> 10307978 L
> 10307979 XS
> 10307979 S
> 10307979 L
> 10307980 XS
> 10307980 S
> 10307980 XL
> 10307981 XS
> 10307981 S
> 10307981 M
> 100000307981 L
you need?? elaborate
>>>
>>>
>>> On Tue, Oct 11, 2016 at 12:51 PM,
>>> wrote:
>>>
>>>>
>>>>
>>>> Need a help in formating an equation for the nested if..
>>>>
>>>> --
>>>> Are you =EXP(E:RT) o
oops attachment missing
--
On Tue, Oct 11, 2016 at 5:49 PM, Learner Excel wrote:
> Hi Enclosed solution with simple vlookup.
>
> It would be great if you can share the tariff plan calculation logic so
> that we are create this more dynamic
>
> --
>
> On Tue, Oct 11
1 is 1500 and
>>> the rate for 2 pax is 1700, same way for room no 202,203 and 204 the
>>> rate for 1 pax is 1200 and rate for 2 pax is 1400 here i am attching a file
>>> in which upon entering the room no and pax the value should be
>>> automatically generated in
gt; On Fri, 12/9/16, XLS time wrote:
>>
>> Subject: Re: $$Excel-Macros$$ Re: VBA Macro - Whatsapp Group
>> To: excel-...@googlegroups.com
>> Date: Friday, December 9, 2016, 8:38 AM
>>
>> 8860067995
>> --
>>
>> On Fri, Dec 9, 2016
Hi,
need help on filter countif formula not showing only filtered calculation(
count )
but count visible working fine
here in attached file i put formula
but when i put filter on pname showing all other count
solution pls
Thanks
--
Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you
Sir,
when i browse not showing .csv files & excel worksheet
thank you
On Wed, Mar 11, 2015 at 11:59 PM, Bé Trần Văn
wrote:
> Try using the Merge File.
>
> See instructions in File.
>
> 2015-03-11 20:02 GMT+07:00 :
>
>> Sir,
>>
>> i need a macro to impo
Sir,
Very Nice
Thank You very much
On Thu, Mar 12, 2015 at 11:43 AM, Mahesh Patil wrote:
> Hi,
> Collect all excel files under one folder. Use attached file to merge all
> excel files.
> Regards,
> Mahesh Patil
> On Mar 11, 2015 6:32 PM, wrote:
>
>> Sir,
>
workbook)
> when i put colorcode in (color code.xlsm) box
>
> result will display on 1 form
> pls solve my friend query sir
>
>
> thanks
>
> --
> 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
.net. Could please assist me how to do this.
> >
> >
> > --
> > Thanks & Regards,
> > Rupesh Patil,
> > (9970196189),
> > Ayushman Pvt. Ltd.
> >
> > --
> > Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s
> &
any macro solution ?
On Thu, Aug 27, 2015 at 10:18 PM, My Excel wrote:
> Sir,
>
> need help on serial no generate (like attached file)
>
> using auto increment loop
>
> start from 1200 to
>
> better if possible 1 crore in 1 sheet
> thanks,
>
>
Columns, Type:=xlLinear, Step:=1, Trend:=False
End With
End Sub
On Sat, Aug 29, 2015 at 11:53 AM, Abhishek Jain
wrote:
> Your query is not clear...please elaborate.
>
>
>
> On Sat, Aug 29, 2015 at 9:24 AM, My Excel wrote:
>
>> any macro solution ?
>>
>&
Hi Expert's,
need help. It will great appreciated if someone can send me the macro
i have data in ms access & sqlite multiple files
regularly i received data in excel
ms access & sqlite data received once in a month
i convert access & sqlite data which data present in excel
Nice & good example dude...
On Tue, Mar 6, 2012 at 1:19 PM, Abhishek Jain wrote:
> Anyone...?
>
>
> On Thu, Mar 1, 2012 at 6:57 PM, Abhishek Jain wrote:
>
>> Hi friends,
>>
>> For the sake of learning I just keep doing some thing or the other,
>> mos
y.gif]***
>
> ^^ஜ۩۞۩ஜ▬▬▬ ▬^^
>
> * *
> *
> *
>
>
>
> -- Forwarded message --
> From: Deba Ranjan
> Date: Thu, Mar 1, 2012 at 5:58 PM
> Subject: $$Excel-Macros$$ Userform Filter
> To: NOORAIN ANSARI , David Grugeon <
> grug...@gmail.
ost to this group, send email to excel-macros@googlegroups.com
generate the same with the excel vba..
--
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 or may not be answered.
2
workbook. Forum
owners and members are not responsible for any loss.
--
To post to this group, send email to excel-macros@googlegroups.com
ta in a workbook. Forum
owners and members are not responsible for any loss.
--
To post to this group, send email to excel-macros@googlegroups.com
thanks for the speedy reply sir..how about using VBA for finding the
differences between the columns and pasting them(only the DIFFERENT
ones-Receipt no & amount which are not matched to a new sheet one down the
other...
On Thu, May 3, 2012 at 12:08 AM, Mr excel wrote:
> hi all,
> i
:21 AM, Mr excel wrote:
> thanks for the speedy reply sir..how about using VBA for finding the
> differences between the columns and pasting them(only the DIFFERENT
> ones-Receipt no & amount which are not matched to a new sheet one down the
> other...
>
>
> On Thu, May 3, 2
onsecutiveDelimiter:=False,
> Tab:=True, _
>
> Semicolon:=False, Comma:=False, Space:=False, Other:=True,
> OtherChar _
>
> :=":", FieldInfo:=Array(Array(1, 1), Array(2, 1)),
> TrailingMinusNumbers:=True
>
> .Parent.Activate**
signatures are prohibited.
NOTE : Don't ever post personal or confidential data in a workbook. Forum
owners and members are not responsible for any loss.
--
To post to this group, send email to excel-macros@googlegroups.com
t to this group, send email to excel-macros@googlegroups.com
nfidential data in a workbook. Forum
owners and members are not responsible for any loss.
--
To post to this group, send email to excel-macros@googlegroups.com
excel.xlsx
Description: applicatio
le for any loss.
--
To post to this group, send email to excel-macros@googlegroups.com
-
To post to this group, send email to excel-macros@googlegroups.com
To unsubscribe, send a blank email to excel-macros+unsubscr...@googlegroups.com
Respected Sir,
I have many 500 rows in my excel sheet
i want sort all row ascending order.
for exp
1 row 102 103 105 110 120
2 row 103 102 110 105 120
how i convert it into
1 row 102 103 105 110 120
2 row 102 103 105 110 120
able).
>>
>> Please help me
>>
>> WebRep
>> Overall rating
>>
>>
>> --
>>
>> --
>> Some important links for excel users:
>> 1. Follow us
e formula also is very helpful to me in another scenario..
Really my joy knew no boundaries..
On Fri, May 6, 2011 at 6:46 AM, ashish koul wrote:
> try this one
>
> On Thu, May 5, 2011 at 9:11 PM, ashish koul wrote:
>
>> see if it helps
>>
>>
>> On
wrote:
>
> change
> "dd-mmm-" to
>
> "dd-mmm'" in formula
>
>
> On Sat, May 7, 2011 at 7:47 AM, Mr excel wrote:
>
>> dear ashish,,
>>
>>That is excellent & great.Thanks a lot .The formula u provided is
>> ve
Got it ashish bhayya..thanks a lot.played with the formula and got the
desired result..
Thanks a lot.
On Wed, May 11, 2011 at 8:37 PM, Mr excel wrote:
> what i meant is instead of the period,the formula is showing as a result
> the formula should return only the month with the year.
; Regards,Anil Bhange
>
> IP Phone - 512320 | Mobile - 90290 32123
>
>
>
> *From:* excel-macros@googlegroups.com [mailto:
> excel-macros@googlegroups.com] *On Behalf Of *Mr excel
> *Sent:* Wednesday, May 11, 2011 8:37 PM
> *To:* excel-macros@googlegroups.com
> *Subject:
It is the same worksheet bhayya which i had attched previously.Just need to
change the formula or add a routine for my requirement.
Thanks in advance.
On Sun, May 15, 2011 at 9:43 AM, ashish koul wrote:
> can you attach the sample sheet
>
> On Sat, May 14, 2011 at 6:20 PM, Mr exc
If i put my executive name, his weekly and monthly perfomance will come
automatically
On Sat, May 21, 2011 at 5:31 PM, kannan excel wrote:
> Hi rajan,
>
> i am maintain our office Productivity tracker.
> my boss asked our executive weekly and monthly perfomance sheet.
>
> now i
1 - 100 of 1222 matches
Mail list logo
