Hello Friends
I want that Column A & Column D this both contains if matches
With the same entry again then it should show me the error
That It is already exit in the Raw _ which matches the same
Ex
If I have already had one entry in Raw 6 – Where written RAVI + Shop
I am doing one entry again
Please add my number -- 9029969663 in Whats up Macro group
Thanks a lot.
On 1 September 2016 at 08:45, Devendra Sahay
wrote:
> Please add mine too, Its- 8527433364
>
> On Wed, Aug 31, 2016 at 2:33 PM, Lokesh Kumar
> wrote:
>
>> Please add my number in what'sup group 9718534717
>>
>> On Thu, Aug
-- Forwarded message --
From: big smile
Date: 20 August 2016 at 12:00
Subject: $$Excel-Macros$$ Lock some cell for edit with option to copy raw &
paste - Waiting for reply
To: excel-macros@googlegroups.com
Paul sir -- waiting for your reply.
& no body other have any i
-- Forwarded message --
From: big smile
Date: 20 August 2016 at 12:00
Subject: $$Excel-Macros$$ Lock some cell for edit with option to copy raw &
paste - Waiting for reply
To: excel-macros@googlegroups.com
Paul sir -- waiting for your reply.
& no body other have any i
Paul sir -- waiting for your reply.
& no body other have any idea. how to solve this ??
On 18 August 2016 at 21:00, big smile wrote:
> Sir
>
> What ever u think is best solution u send .
>
> My purpose is that I want some cell should not change without password.
> 90 % w
ou can.” - John Wesley*
> -
>
>
> On Thursday, August 18, 2016 8:21 AM, big smile
> wrote:
>
>
> Thank you Mr Paul for your reply.
>
> I understand that i should only lock particular cell & not full column.
>
> I have do
>
>
>
>
>
>
>
> *“Do all the good you can,By all the means you can,In all the ways you
> can,In all the places you can,At all the times you can,To all the people
> you can,As long as ever you can.” - John Wesley*
> ---
Respected Friends
Basices
I am doing policy entries details in excel
I want that the cell which I highlight with red colour-- can not
be change without putting password -eg.- 1
I put password --- 1
All red colur cell is formula which start with = sign
If I lock the cell & protect sheet then I can n
Yes good solution
Thanks a lot .. God Bless you
On 23 June 2016 at 21:30, Shaw McAllan wrote:
>
> Hiya,
>
> Can't you just use an AutoFilter? That way you can hide empty rows (or
> show them) whenever you feel the need.
>
> Cheers,
> -S
>
>
> On Monday,
Respected friends
I have send two emails -- Yesterday one & today one
kindly reply & give me the solution which is possible .
Hope to receive your fast reply
--
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
Respected Friends
ATTACHED FILE WILL CLEARLY EXPLAIN WHAT I WANT
KINDLY SOLVE IT AS EARLY AS POOSIBLE ..
I have 4 option to choose then after choosing all 4
I want that premium should come from the above table which shows arrow
If I change age 46 then
Option 1 Option 2 Option 3 Option 4 Premium
Hello Friends
This sheet is the calculation of Accident policy of New India Ass Co Ltd
I have to put the value in D column from D 10 to D 17
& then calculate the premium.
My query is that for example I am putting the value in only some D coumun
Ex -- D 10 + d 12 + d 14
the other raws automatical
Respected Paul Brother
Please do not say sorry. I thought that may be my query is not logical so
no body is
Answering so I requested again .
My 1 st query of conditional formatting is solved but
for 2 nd I will check & let you know If I have some any doubt.
One more excel query is pending ..
Hello friends
Can any body give me solution / feedback for my 2 queries send
--
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, accura
All are requested to take sort out or give solution to my this query please
.
Thanks ..
On 6 March 2016 at 17:16, big smile wrote:
> Hello Friends
> In the attached file I want the conditional formating
> based on the two conditions
> 1] Which is if f5 cells falls within 15 day
king.
> =ET($F8>=AUJOURDHUI();$F8<=AUJOURDHUI()+14;$K8="INF")
>
> 2) Don't know
>
> Le dimanche 6 mars 2016 12:47:04 UTC+1, big smile a écrit :
>>
>> Hello Friends
>> In the attached file I want the conditional formating
>> based on the two
Respected My friends
In the table above from cell c5to h8
all cell colour is yellow
I want to make conditional formating in such way
that if I make correction or write new value then
that cell colour become normal or white
This is required so that I can come to know whether I have change
the partic
Hello Friends
In the attached file I want the conditional formating
based on the two conditions
1] Which is if f5 cells falls within 15 days then
all cell from a5 to g5 become yellow
which is at present working
I want that this condition work only
IF cell k5 is only " INF"
If there is some thing in
raw then that file become hang.
It stop works .. why it happen & what is the solution of this.
When ever u have time kindly give some way for this
On 3 March 2016 at 22:42, big smile wrote:
> Thank you very much for explaining in details.
>
> God Bless you & all members of
, named it "TextBox_Current", and changed
> the macro to update this text box.
> Now, you can insert additional records.
>
> I also changed the event macro to use the GetConcat function to put the
> summary value in column D.
>
>
> *Paul*
> ---
Respected All
Last time some brothers have help to make this file perfect
I want some clarification / suggestion on this file
I have approx more than 1000 entries to do in this file
1]When I start inserting lines & copy past
t;
>
>
>
> *“Do all the good you can,By all the means you can,In all the ways you
> can,In all the places you can,At all the times you can,To all the people
> you can,As long as ever you can.” - John Wesley*
> -
>
>
> On
Dear All Friends No body reply
On 10 February 2016 at 09:48, big smile wrote:
> Respected All ,
>
> Can anybody Help me out for this query.
>
> On 9 February 2016 at 12:36, big smile wrote:
>
>> Respected All,
>>
>> Can i have solution for this my query ..
Respected All ,
Can anybody Help me out for this query.
On 9 February 2016 at 12:36, big smile wrote:
> Respected All,
>
> Can i have solution for this my query ..
>
>
>
> On 8 February 2016 at 17:57, big smile wrote:
>
>> Respected All Excel Guru's
>&
Respected All,
Can i have solution for this my query ..
On 8 February 2016 at 17:57, big smile wrote:
> Respected All Excel Guru's
> In my attached file I want that in D3 column if I change years
> i.e. -- if I write 10 Years then automatically
> 10 Years calculation
Respected Excel Guru's
I am giving inputs to calculate desire Eligibility %
Inputs given as per b16-c16-d16
& by this 3 input I have to check
>From the above table ie B 3 to F 7 it should search all criteria
then give result in e16
I also given the answer as per age & no claim years & sum insure
Respected All Excel Guru's
In my attached file I want that in D3 column if I change years
i.e. -- if I write 10 Years then automatically
10 Years calculation done
that is it calculate from raw 11 to 20 & show final in total
The same way it automatically caluclate what ever we put value
If we put 2
This is 1 st time i am sending other query's reply.
Otherwise i am always sending query only.
Thank you very much
Check this file too. It may also help you & our group too ..
You can add days also in today' s date
If u think to have some more correction & then let me know
On 6 February 2016
A event macro.
>
> *Paul*
> -
>
>
>
>
>
>
>
> *“Do all the good you can,By all the means you can,In all the ways you
> can,In all the places you can,At all the times you can,To all the people
> you can,As long as ever y
I have send this query on 21 st -- No body reply.
Is this possible or not
-- Forwarded message --
From: big smile
Date: 21 January 2016 at 08:12
Subject: $$Excel-Macros$$ Polite Reminer -- Prompt / Ask the value & then
calculate value
To: excel-macros@googlegroups.com
H
Hello Friends
Any solution for my query . Is this possible ??
Then please take some time to resolve my query.
Thanks & have a nice day ...
Respected Friends
Information --- >>
This is sample file for the premium calcualtion as per Age & sum Insured
If any body age is more then 70 then I have to
Hello Friends
Any solution for my query . Is this possible ??
Then please take some time to resolve my query.
Thanks & have a nice day ...
Respected Friends
Information --- >>
This is sample file for the premium calcualtion as per Age & sum Insured
If any body age is more then 70 then I have to
Respected Friends
Information --- >>
This is sample file for the premium calcualtion as per Age & sum Insured
If any body age is more then 70 then I have to write in Cell -- G26
For example age is 72
I have written in G26 -- Age 72
But the premium calculates only if I mention E26 as 70
Otherwise t
Yes thanks a lot it works nicely
Now i can do the same thing in other files too
I really appreciate & thanks to have a such group.
I am learning excel in details so i may have lot of queries too
Even i have ask is there any course available in Mumbai then please let me
know .
I always think cr
Respected All
Any idea how it is possible
whenever i closed after saving the file but it open only where i have given
option to open
On 11 January 2016 at 23:02, big smile wrote:
> Respected All I attached sample file I want there when ever I open this
> file For Ex -- my cursor
Respected All I attached sample file I want there when ever I open this
file For Ex -- my cursor should be on particular name manager in this
--- CAL Please share the formula too so that I can use the same technique
in other files too THANKS A LOT
--
Are you =EXP(E:RT) or =NOT(EXP(E:RT)
*
>>
>> *MIS Analyst*
>>
>> *Greater Kailash-1, New Delhi*
>>
>> *Email *
>> *p ankaj123...@gmail.com
>> **Skype** pankaj.sharma_pj*
>>
>>
>>
>>
>> -- Forwarded message --
>> Fro
Respected All
I have attached excel files too It has some still issue . I think there is
some correction required in the formula 1] When F column falls under
15 days before today -- only that time full raw should be yellow Today is
9/1/2016 so any date from 9/1/2016 to 24/1/16 -- then only
Thank you so much
Yes it works. Offset is very good function I never new about this
It is really great group Thank you all to make efforts & give me the
result.
On 7 January 2016 at 16:46, Mandeep Baluja wrote:
> Check this out !!
>>
>
> Regards,
> Mandeep baluja
>
> --
> Are you =EXP(E:RT) o
-- Forwarded message --
From: big smile
Date: 6 January 2016 at 11:23
Subject: $$Excel-Macros$$ Merge cell entries & flash/blink cell for
conditional formatting
To: excel-macros@googlegroups.com
Respected all
Can some body help me in this queries
-- Forwarded mes
Respected all
Can some body help me in this queries
-- Forwarded message --
From: big smile
Date: 4 January 2016 at 17:26
Subject: $$Excel-Macros$$ Merge cell entries & flash cell for conditional
formatting -- Can any body please help me out
To: excel-macros@googlegroups
-- Forwarded message --
From: big smile
Date: 3 January 2016 at 12:19
Subject: $$Excel-Macros$$ Merge cell entries & flash cell for conditional
formatting
To: excel-macros@googlegroups.com
Respected Excel Masters Thanks a lot Abhishek Jain & Leonardo Mezavilla God
B
Respected Excel Masters Thanks a lot Abhishek Jain & Leonardo Mezavilla God
Bless you my friends It works properly I have also enclosed corrected
files so that it can help some one It also save my lot of time now. Some
still queries 1] If u see my formula in -- D3 I have to use many time
s
Respected Excel Masters 1] I am doing entries in Insurance files in each
cell separately 2] Then I am clubbing all separate entries by using &
formula 3] But I am getting result as shown in d12 4] I want the same
thing should be shown as d20 5] I am trying to use Alt + Enter to get the
second r
If i put 1A instead of A then it works
On Thu, Nov 5, 2015 at 6:55 PM, big smile wrote:
> Thanks a lot
>
> But if i put Table A then it shows 0 only. For Table A -- Both Risk Group
> I /II not work..
>
> On Thu, Nov 5, 2015 at 6:49 PM, Abhishek Jain
> wrote:
>
>>
Thanks a lot
But if i put Table A then it shows 0 only. For Table A -- Both Risk Group I
/II not work..
On Thu, Nov 5, 2015 at 6:49 PM, Abhishek Jain
wrote:
> PFA
>
> On Thu, Nov 5, 2015 at 6:20 PM, big smile wrote:
>
>> Repected Friends 1] Which formula I should use i
Repected Friends 1] Which formula I should use in E 13 --- I want the
value depends upon Risk Group & Table As per B4 :D9 2] First I have to see
the Group which I & II then Table A/B/C/D It will take depends upon this
two criteria the value 3] I have to caluculate same way in more raws for
-
>>
>>
>>
>>
>>
>>
>>
>> *“Do all the good you can,By all the means you can,In all the ways you
>> can,In all the places you can,At all the times you can,To all the people
>> you can,As long as ever you can.” -
ll the means you can,In all the ways you
> can,In all the places you can,At all the times you can,To all the people
> you can,As long as ever you can.” - John Wesley*
> ---------
>
> --
> *From:* big smile
> *To:* excel
Respected Guru's .. I want to learn the formula so that I get the
folllowing results 1] In the sheet 1 - I am choossing option A & B I am
chossing any two comparision 2] Ex If I choose Star Comprensive The New
India - FLOTER 3] I want the result as follows Then auotmatically My
sheet 2 wi
-- Forwarded message --
From: big smile
Date: Fri, Sep 18, 2015 at 9:34 AM
Subject: $$Excel-Macros$$ Fwd: -- No body has replied !!.. Hide column as
per option choice. - Attach Sheet..
To: excel-macros@googlegroups.com
-- Forwarded message --
From: big smile
-- Forwarded message --
From: big smile
Date: Wed, Sep 16, 2015 at 3:42 PM
Subject: $$Excel-Macros$$ Hide column as per option choice. - Attach Sheet..
To: excel-macros@googlegroups.com
Respected Guru's .. I want to learn the formula so that I get the
folllowing results 1
Respected Guru's .. I want to learn the formula so that I get the
folllowing results 1] In the sheet 1 - I am choossing option A & B I am
chossing any two comparision 2] Ex If I choose Star Comprensive The New
India - FLOTER 3] I want the result as follows Then auotmatically My
sheet 2 w
s so that if
I want to change the box or cell thenI can do it my own.
Thank
you in advance.
On Mon, Dec 22, 2014 at 6:05 PM, Vaibhav Joshi wrote:
> Hi
>
> Big smile check this...
>
> Mandeep's code is working fine, made few change to it like..if same value
>
Hellow Friends 1] I am changing the value of -- Sheet6-C22 -
everytime 2] The same value should be pasted in the box show B4 :
g13 3] The 1 st change in c22 - pasted on b4 of sheet1 4] The
2 nd change in c22 - pasted on c4 of sheet1 & so on
Ashish bhai
I am sorry it does not work.
But Viabhav Bhai file works
. & if i want to apply this to other excel fiels then
I have to keep open Master file- Initial file open -- Vaibhav Bhai send
then work for all files..
Do not feel hurt .. Just to share what is happening
On Thu, Sep
h has filter.
>
> Cheers!!
>
> +
> *I did not do this for you. God is here working through me for you.*
>
> On Thu, Sep 25, 2014 at 9:16 AM, big smile wrote:
>
>>
>> Respected Excel Guru / Friends
>>
>> I think many of our friend is facing this problem Wh
Which no to call .. You have written called me
On Thu, Sep 25, 2014 at 4:20 PM, Ashish Kumar
wrote:
> Ok friend call me.
>
> --
> 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.facebo
Sir,
I want filter according to column only but it may be at a time two filter
& when i use filter in B and F or may be more combination then that
particularly
full column colour should change so that we can identify easily where we
have out filter ..
On Thu, Sep 25, 2014 at 4:13 PM, Ashish
Respected All ,
What happen every body is silent. No body get any way out ..
How to over come this requirements ..
On Thu, Sep 25, 2014 at 9:59 AM, big smile wrote:
> Respected Sir ,
>
> I think i have not properly explain you.
>
> I want when we used filter then full colum
Respected Sir ,
I think i have not properly explain you.
I want when we used filter then full column colour change & not raw colour.
So if i used filter in two or more colu at a time then i get it fast where
i have used filter..
On Thu, Sep 25, 2014 at 9:42 AM, Ashish Kumar
wrote:
> Hi,
>
> P
Respected Excel Guru / Friends
I think many of our friend is facing this problem When ever we use filter
column then the colour of small box sign changes
But we have to see properly that where ever filter is there ..
I have 10 entries in excel files from Raw 3 to Raw 12 --- Column From B to
T .
ll.
>
> Cheers!!
>
> +
> *I did not do this for you. God is here working through me for you.*
>
> On Mon, Sep 22, 2014 at 12:48 PM, big smile wrote:
>
>> Respected Excel Guru / Friends
>>
>> I have 6 entries in excel files from Raw 3 to Raw 8
>>
Respected Excel Guru / Friends
I have 6 entries in excel files from Raw 3 to Raw 8
I want the formula that --- When ever i filter any raw by selecting any
family name - Ex I filter Dhimant Parmar - EX R7
then i want in B1 What ever is in f - column after filter.
When ever i change my filter and
-- Forwarded message --
From: big smile
Date: Mon, Sep 22, 2014 at 9:23 AM
Subject: Fwd: FILTER ISSUE
To: big smile
TRAIL WORK SHEET.xlsm
<https://docs.google.com/file/d/0BwUVOOH7PyBTcUJxV3E0d1lzTFU/edit?usp=drive_web>
Respected Excel Guru / Friends
I have 6 entr
at 1:45 PM, Vaibhav Joshi wrote:
> Check this.
>
> Cheers.
> On Aug 31, 2014 8:29 AM, "big smile" wrote:
>
>> Respected All,
>>
>> Please find the attached excel sheet
>>
>> I want to have one macro or any solution so that i can do the foll
Respected All,
Please find the attached excel sheet
I want to have one macro or any solution so that i can do the following
problem.
If i write Term 20 Years in C6 then my Raw chart increase automatically
extend up to 20 installments
If i write Term 25 Years in C6 then my Raw chart increase aut
Respected All.
I would like to know that i am using Excel 2010.
& i have used Auto Filtered option.
But key Board Short cut - Alt + Down Arrow is not working
what may be the possible reason.
Is there any other option we can used macro for the same or any other
shortcut key board key.
so that
Respcted Sir & group members.
I have put some numbers in one cell -- for ex. 2 5 9 8 9 5 9 9 v v v ---
now i want the same cell to trimed as look as --- 25989599vvv [ i want to
remove the space in between]
is it possible with excel function.
Thanks
--
---
Hellow Sir,
I am using the Excel 2007,
Can we have the option of Go to direct required Page No.
under Page Preview.
For ex. - I have 200 Pages in my work sheet.
In Page preview i want to see page no.17
Can it possible the page no. direct option.
One way is to go to print option write page no.17
I am Insurance Advisor
I my self has more then 2000 clients i have made excel as my base
software which helps me to solve my all daily updates.
Even the LIC Private Software is not giving that much satisfaction
& need base soultion which Excel gives me.
Even I love this group also from which
AVLA
On Thu, Sep 2, 2010 at 1:05 PM, Aindril De wrote:
> Hi,
>
> Please use the following code:
>
> *Private Sub Workbook_Open()*
>
> Sheets("Sheet2").Select
> Range("A494").Select
>
> *End Sub*
>
> Cheers!
> Andy
>
> On Thu,
Respected Excel Guru's
How to make the macro so that
When ever i start the file my cursor goes into that particular cell only.
For EX. Sheet 2 - A494 etc.
The purpose behing this is ex. i have set the target of achieving certain
amount -- so how much
still pending to achieve.
Thanks & have a
Hellow Friends,
I want to know is it possible to do the following
I am using Excel 2007 version.
I have added in Auto Correct option -- Replace [ .m] & With No. [
34/09/11/]
It works properly -- but i want to do that i have to enter always some no.
after that say ex. 359535 etc
Now w
> If Mid(one, x, 1) = Mid(two, x, 1) Then
> Else
> Range("c1") = Range("c1").Value & Mid(one, x, 1)
> End If
> Next
> End Sub
>
> Regards
> Rajender Soni
>
> On Jul 6, 7:56 pm, big smile wrote:
> > Hello Friends
> >
> > I w
Hello Friends
I want to know that can it possible the following idea.
Cell A1 contains text >>> Shri Ram Chandra
Cell B1 contains text - >>> Shri RAM cHANDRAs
I want to that i want the formula in C1 --
which give me the result of that difference between this A1 & B1
the answer is only
ight is Rs. [ c2]
where c1 & c2 is the cell value
Thanks
Good Day
>From Big Smile
Savla
--
--
Some important links for excel users:
1. Follow us on TWITTER for tips tricks and links :
http://twitter.com/exce
Thanks a lot
Now it has solved.
BIG SMILE
FROM
SAVLA
On Sat, Jun 12, 2010 at 12:53 AM, Paul Schreiner wrote:
> As I said:
> Use:
> Selection.AutoFilter Field:=ActiveCell.Column,
> Criteria1:=ActiveCell.Value
>
> ----------
> *From:* big
macro as following Kindly give check the wordings.
Thanks
Sub Macro2()
'
' Macro2 Macro
' FILTER LIKE THIS
'
' Keyboard Shortcut: Ctrl+Shift+F
'
ActiveSheet.Range("$A$3:$IX$681").AutoFilter field:=14, Criteria1:= _
"
Hellow Gorup Masters,
I want the help to write the macro as follows.
Sub Macro2()
'
' Macro2 Macro
' FILTER LIKE THIS
'
' Keyboard Shortcut: Ctrl+Shift+F
'
ActiveSheet.Range("$A$3:$IX$681").AutoFilter Field:=1, Criteria1:= _
"CURRENT CELL CONTENT "
End Sub
when ever i select the pa
r that ur custom view button will be
> highlighted
>
>
> On Wed, Jun 2, 2010 at 9:20 AM, big smile wrote:
>
>>
>>
>>
>> Thanks for answering
>>
>> But even today i have try but the custom view button
>>
>> Which is under view bar -
; I think it is working fine. can u please put an snapshot, where u r not
> able to view customize button
>
>
> On Tue, Jun 1, 2010 at 8:53 AM, big smile wrote:
>
>> Thanks for reply
>>
>> But in excel 2007 - there is no such Button
>>
>> & one mo
Hellow Group Members
I am using excel 2007 & in one of my file -- custom view button is off
that is not working
In other files it is working
what will be the reason for such thing.
Thanks
From
Big Smile
S
> Hellow Friends.
>
> Can it is possible to do the following
>
> [ =C1 ]
>
> I am taking the name from the C1 & I want Bracket [ ] before & after word
>
> so that i can change & adjust the cell size.
>
> Ex. --[Mr. Guru Datt ] the word Guru Datt had taken from C1 cell
>
> Thanks
>
Have a nic
Respected Excel Friends,
Attached please find the excel sheet -- in which i have explained my query.
Try to resolve it
Thanks
J C SHAH
--
--
Some important links for excel users:
1. Excel and VBA Tutorials(Video a
t 17, 2009 at 4:22 PM, big smile wrote:
>
>> Hellow all excel guru's & friends.
>>
>> I have some query -- or i want to know the shortcuts.
>>
>> 1] Can we delete the name given to particular cell in name box - if
>> we type F5 - the name box appe
Hellow friends
I am awaiting your reply for this my query.
Thanks
On Fri, Oct 16, 2009 at 3:36 PM, big smile wrote:
> HAPPY DIWALI & NEW YEAR TO ALL OUR EXCEL GURU’S & FRIENDS
>
>
>
>
>
> Attached please find the Excel –tips –Query No.3 File
have not written "Save" syntax in the code.
>
> 5) Re-naming option for custom view is not there, alternatively you should
> try and record/ develop a macro to do this lengthy task for you.
>
> Best Regards,
> --
> DILIP KUMAR PANDEY
> MBA-HR,B COM(Hons.),BCA
Hellow Friends,
Please guide me all this query particular to Excel 2007 Version.
Thanks
On Sat, Oct 17, 2009 at 4:22 PM, big smile wrote:
> Hellow all excel guru's & friends.
>
> I have some query -- or i want to know the shortcuts.
>
> 1] Can we delete the
Hellow all excel guru's & friends.
I have some query -- or i want to know the shortcuts.
1] Can we delete the name given to particular cell in name box - if we
type F5 - the name box appear
I would like to know how to change the name and delete the name given to
some reference.
2] There
HAPPY DIWALI & NEW YEAR TO ALL OUR EXCEL GURU’S & FRIENDS
Attached please find the Excel –tips –Query No.3 File
In Sheet 1 – All the details given
In sheet 2 – Types of Reports required
In sheet 3 – Other type of Summery reports required
Thanks in advance for using the mastermind to
Respected members of group,
I want the 2 filter option in Raws & not in Columns.
Is it possible.
Thanks
On Thu, Sep 24, 2009 at 10:21 AM, big smile wrote:
> Hellow group members,
>
> Have a nice time with excel master.
>
> I have query that can it possi
Hellow group members,
Have a nice time with excel master.
I have query that can it possible to have 2 filer option in single sheet.-
if yes how can be done.
with the helo of macro or without the help of macro.
I have tried one filter -- then i have added another filer on another raw -
then 1 s
Thanks a lot,
Yes i got it. --- further to this that can we change the month or year also.
Thanks
On Tue, Aug 18, 2009 at 11:08 AM, shafiq online
wrote:
>
> Attached is complete detail regarding your question. Once you read you can
> diplay calendar inn any version of excel.
>
> ---
Respected Master of Excel & friends
I am having Excel 2007 version
But i can not open the calender in excel sheet - i can not get the tollbar
-- where it is ?
or please elaborate the system or method to do this good & very inform-able
function of
calender.
Is it-- customize quick access tool
nt. Now the
> entire row will be duplicated and not just first 10 columns. So you can add
> any no. of columns, just ensure that you add new columns to the right of
> existing ones and not in between the existing ones.
>
>
>
> Regards
>
>
>
> Ajit
>
> *From:* bi
> *From:* excel-macros@googlegroups.com [mailto:
> excel-mac...@googlegroups.com] *On Behalf Of *big smile
> *Sent:* Monday, July 27, 2009 10:45 AM
> *To:* EXCEL MACRO GROUP
> *Subject:* $$Excel-Macros$$ QUERY NO. 3 - EXCEL
>
>
>
> Respected Group memebers,
>
> Attach
t;
>
>
> *From:* excel-macros@googlegroups.com [mailto:
> excel-mac...@googlegroups.com] *On Behalf Of *big smile
> *Sent:* Monday, July 27, 2009 10:45 AM
> *To:* EXCEL MACRO GROUP
> *Subject:* $$Excel-Macros$$ QUERY NO. 3 - EXCEL
>
>
>
> Respected Group memebers,
&g
Respected Group memebers,
Attach please find the query file no.3 ---
I would like to know the macro to do the necessary entries as shown in the
files.
Thanks - & have a nice day.
--~--~-~--~~~---~--~~
-
--
Respected friends,
Attached please find the excel 2007 query file- 3
I would like to know the shortcut formula or macro to get the result.
Have a nice day.
Mrs. J . Shah
--~--~-~--~~~---~--~~
--
1 - 100 of 102 matches
Mail list logo
