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
Hi, To wrap the formula in VBA, use a space then an underline, but not within
double quotes. You have to split at a point outside the double quotes.
eg:
WS3.Cells(iRow, 11).Formula = "=IF(NAMES!AR" _
& j & "<>,NAMES!AR1,IF(NAMES!AS" & j & "<>,NAMES!AS1,IF(NAMES!AT" _
& j & "<>,
Hi,
If you attach a sample file, I think we can help you.
Regards - Dave.
> Date: Wed, 23 Sep 2009 14:33:11 -0700
> Subject: $$Excel-Macros$$ Substring across a range of cells
> From: sjharri...@btinternet.com
> To: excel-macros@googlegroups.com
>
>
> I have a spreadsheet populated with game
Hi,
Try this:
Range("C" & CStr(LCurSRow)).Formula = "=COUNTIF(Dept!AR" & CStr(lRow)
& ":CE" & CStr(lRow) & ",>0)"
Regards = Dave.
> Date: Wed, 23 Sep 2009 17:12:13 -0700
> Subject: $$Excel-Macros$$ Help with quotes in COUNTIF formula
> From: cad...@gmail.com
> To: excel-macros@googleg
i am also aggree with u guys.
On Thu, Sep 17, 2009 at 6:51 PM, Aindril De wrote:
> Hats Off Ayush...
> Excellent Tip...
>
>
> Regards,
> Andy
>
> On Thu, Sep 17, 2009 at 7:31 PM, Ayush Jain wrote:
>
>> **
>> Do you have important Excel files that would create nothing short of chaos
>> and d
i am aready ahving data in col a and col b ,,etc
but i want to insert new row when cell value in cal b is parent co.
On Wed, Sep 23, 2009 at 8:37 PM, Sandeep Kumar Maurya wrote:
> Hello Ashish,
>
> Do you have your data ready or you want to enter the data then a new row
> below it.
> Means y
Hi,
I was trying to create a macro that replaces every series in a line
chart with a moving average (other kinds of trendlines could be added
later with a form), easing the creation of a series of smoothed charts
out of raw data far simpler (currently you have to manually make the
moving averages
Hi Everyone,
I'm having troubles with this formula. It currently works. But I
would like to extend the range out to column CE.
There are 2 problems:
1). I would like to wrap the text of this formula so that it appears
as 4 lines in the vba editor. It's too hard to read
as 1 gigantic line.
I have a spreadsheet populated with game score data imported from an
external source (so I can't change the format!) that consists of
between 2 and 4 cells each containing a name (variable length) and a
score (always 3 characters) in the following format;
cell#1 cell#2 cell#
Hi Everyone,
I'm have a problem with modifying the following excel formula into a
macro.
This is the basic cell formula from excel
It counts the number of cells in the range that are greater than 0.
Excluding blank cells.
=COUNTIF(Dept!AR40:CE40,">0")
This is my attempt at writing the same for
There short keys for proper or upper case in excel rather you have to use
proper & upper worksheet function to do this. :)
On Wed, Sep 23, 2009 at 8:48 PM, Alok Bhatt wrote:
> Hi friends,
>
> Can u provide me any shortcut key for proper and upper function in Excel
>
> >
>
--
Regards,
--
Abdu
can u send that file..
i will try to recover passowrd..
Thanks & Regards,
Harmeet Singh
Sent via BlackBerry Wireless
On Wed, Sep 23, 2009 at 8:27 PM, manish wrote:
>
> ive forgot password to the new project & macro i have created in VB
> excel. how to recover that macro password. can som
Hi Sonia,
If you open the VBE window, u will see a for each loop, that is changing the
cell color for all the selected cells.
Let me know if more clarification is required. :)
Thanks & Regards,
Harmeet Singh
Sent via BlackBerry Wireless
On Wed, Sep 23, 2009 at 1:34 PM, Sonia Singla wrote:
Hello Ashish,
Do you have your data ready or you want to enter the data then a new row
below it.
Means your data already have "parent co" in column B are you going to enter
it in column B.
Regards
Sandeep
On Wed, Sep 23, 2009 at 10:29 AM, ashish koul wrote:
> inserting a blank row with matchi
Hi VR,
Find the attached solution.
Regards
Sandeep
On Tue, Sep 22, 2009 at 8:05 PM, vinod rao wrote:
> HI Team,
> need a foumula to find the latest Date and in next column the Status
> Plz find attached.file.
>
> Thanks in advance.
> VR
>
> >
>
--~--~-~--~~~---~--~
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
manish
--~--~-~--~~~---~--~~
---
Hi Sonal,
I take a look on your data and find that your data in file1 and file2 are
not same as there are some short names and no middle name in one of the file
but the other one has full name and short middle name.
It can be done with VBA but if your data is not unique then there is no
guarantee
Hi friends,
Can u provide me any shortcut key for proper and upper function in Excel
--~--~-~--~~~---~--~~
--
Some important links for excel users:
1. Excel and VBA Tutorials(Video and
Hi Team,
Can you please help me below my request.Thanks in advance
On Tue, Sep 22, 2009 at 4:11 PM, minimaster <
hartmut.gruenha...@bakerhughes.com> wrote:
>
> How can I attach an excel workbook to this reply? I added some macro
> code to your workbook. But for some reason I can't find a way to
No Replies! :(
On Sep 19, 2:44 pm, Hemant wrote:
> Good day friends :)
>
> I have an excel workbook with one of its hidden (XlVeryHidden) sheets
> contains a link to my web site and gets updated every time the
> workbook is opened and once in 15 minutes.
>
> When I will publish some encrypted in
20 matches
Mail list logo
