RGB values
<http://www.cpearson.com/excel/colors.aspx>
http://www.cpearson.com/excel/colors.aspx
& see att
Don Guillett
Microsoft MVP Excel
SalesAid Software
dguille...@gmail.com
From: Janet Dickson <mailto:janetdicks...@gmail.com>
Sent: Saturday, March 10, 2012 6:
Hi All,
I have attached a file to show my challenge. The file shows one column with
colors in cells and second column empty, but I want to add RGB Values
automatically using VBA. Help please.
cheers
--
FORUM RULES (986+ members already BANNED for violation)
1) Use concise, accurate threa
> > =text(B4,"mmm")
> >
> > > Now copy this formula in all rows of coloumn C, You will get Month name
> > > like Aug in cell C4.
> >
> > > Now you can use sum if.
> >
> > > Sent on my BlackBerry® from Vodafone
> > > ---
Hello Excel Gurus,
I encountered a challenge on using SUMIF FUNCTION. Help me on summing total
amount in different months into different cells. See attached fine for
details.
--
--
Some important links for excel use
Hi Ayush, my heartiest congratulation
On Tue, Oct 5, 2010 at 4:55 PM, Srinivasan Ethirajalu <
srinivasan.ethiraj...@gmail.com> wrote:
> Good. Keep going..
>
>
> On Tue, Oct 5, 2010 at 4:09 PM, Tulasi Rao wrote:
>
>> Hi Ayush,
>>
>> You got the deserved
>>
>> Regards,
>>
>> Tulasi Rao
Thanks, I will follow up
On Mon, Sep 27, 2010 at 7:11 AM, P.VIJAYKUMAR wrote:
> Hello,
>
> There are Excel addins for removing Duplicates.You can Download and Install
> them from www.office-excel.com,www.ablebits.com ... etc.There is also an
> addin called "Ultimate addin" for Excel which conta
ind.
>
> Thanks
> Srinivasan E
>
>
> On Thu, Sep 23, 2010 at 4:11 PM, janet dickson wrote:
>
>> Thanks for your response I used *Advanced filter *and it worked out.
>>
>>
>> One Love...
>>
>> On Thu, Sep 23, 2010 at 12:28 PM, Srinivasan E
ter > auto filter
> Step6: Apply Test2 filyter with value as 1. Now the Row with first
> occurance of the concatenated values are selected.
> Step7: Select the columns from A to G to a new wooksheet then duplicates
> are elminated.
>
> Enjoy.
>
>
> On Thu, S
Hi All,
Team, see attached file, please help me on how to remove duplicates in .xls
file.
.on love
--
--
Some important links for excel users:
1. Follow us on TWITTER for tips tricks and links :
http://twitter.
Hello Team,
Everyday I am supposed to visit http://www.goldprice.org/ and checking gold
price, then I enter gold price into an excel file. I was wondering if its
possible to automate this task. I mean create some vba that will pick gold
everday and put it into excel sheet am using. I hope am clear
at, Sep 18, 2010 at 5:00 PM, Vinod N wrote:
>
>> Hi Janet,
>>
>> Please enter the date in Excel recognizable format i.e., mm/dd/
>> instead of dd/mm/. Then days can be calculated with the formula you have
>> already entered.
>>
>> Thanks
&
Hi Team,
I have challenge, see attached file. I want to see days instead of dates
Hugs en Love
--
--
Some important links for excel users:
1. Follow us on TWITTER for tips tricks and links :
http://twitter.com/exc
Much appreciation for this DIARY
Hugs & Love
On Tue, Sep 14, 2010 at 9:47 AM, sphamandla ntombela wrote:
> Maries please email me as well the Diary Doc i cannot get it by following
> the link also.
> It looks very interesting. Thanks
>
> On Tue, Sep 14, 2010 at 5:46 AM, P.VIJAYKUMAR wrote:
>
Hi Dave,
Much appreciation every works perfect.
Hug & Love
On Thu, Jul 29, 2010 at 7:08 AM, Dave Bonallack
wrote:
> Hi,
> In H4 enter:
> =IF(G4=0,"",D4/G4)
>
> And similarly for other cells that contain a division operator
> Basically we are saying, if the denominator = 0 then nothing, otherwi
Hi Team,
I have a challenge, how can I create a formula using VBA?!
Attached file show details, but i don't want to see *#DIV/0! *error in case
columns used in division does not have any data!!
column E - F = column G (sometimes column E - F does not have any data, so i
don't want to see 0 in c
Hi team,
Team I have a challenge, attached .xls file provides an example of roster
timetable which am monitoring. Each column contain names for different
employees and rows are dates, some cells in columns contain R and some B. R
= going leave, B = back to leave.
How can I automate email alert on
- 62, India
>
>
> On Fri, Jun 25, 2010 at 9:57 AM, Prashanth Banneni
> wrote:
>
>> Hi Janet,
>>
>> The shortcut for Powerpoint through run is --> powerpnt
>>
>> Thanks
>> Prashanth
>>
>> On Thu, Jun 24, 2010 at 10:51 PM, janet di
Hi Team
*Sorry for asking this in excel group.*
Does any one know the Shortcut for opening a MS Powerpoint using run box
(Winkey + R) ??
I can open several programs in run box (winkey + R) as shown below*:*
MS Excel is *excel*
MS Word is *winword*
MS Access is *msaccess*
MS Outlook is *outlo
utton to append the data. This will only append data
> in sheet1 of the files.
>
> Regards,
>
>
> Seema
>
> On 4/6/10, janet dickson wrote:
>>
>> Hello Team
>>
>> I have more than 52 workbooks each contain 3 sheets but only one sheet
>> "
Hello Team
I have more than 52 workbooks each contain 3 sheets but only one sheet
"sheet1" contain data. all sheets containing data have the same column names
in the 1st row, i want to append all sheets into one excel sheet.
Please send me some codes to accomplish the task.
Thanks in advance
Jen
Okay
Am looking for codes to forward emails which am receiving in my OUTLOOK 2007
to my second mail/Account and if some emails contain attachment, then all
email with attachment file >=3MB will be excluded automatically.
I hope you understood
Thanks for helping
Jenie..
On Tue, Apr 6, 2010 at 8:2
Hello Team
Sorry for asking things out *EXCEL, *can anyone share sites/groups for MS
OUTLOOK.
Much regards
--
--
Some important links for excel users:
1. Follow us on TWITTER for tips tricks and links :
http://twi
Hello
book to start with
VBA For Dummies
This is the book am using am also novice in VBA, but everyday am
appreciating the power of VBA.
Cheers
On Wed, Mar 10, 2010 at 12:39 PM, sumanth kumar wrote:
> So How can master in VBA
> can you please advice any books to learn and master VBA
>
> On
Hi Excel Savvy
Help me on making a scatter plot (attached file contain raw data).
It may look like am not asking too much or not reading (but not true i have
tried to read the *F1 Help *but it was not useful)
Thanks
--
Dave, these are not sample data thus why am want to remove them.
But thanks for being curious.
One Love as a group.
On Thu, Feb 18, 2010 at 12:09 PM, Dave Bonallack
wrote:
> Hi Jen,
> Sample data has no duplicates. Am I missing something?
> Also, is the data allowed to be sorted?
> Regards - Dav
Hello Fans..
Am in trouble, please give a *macro *to remove duplicate rows (attached file
show just few data) this will help me alot (My original data have up to 6100
rows, possibly more than 500 rows are duplicate).
Regards
Jen
--
---
Hello Group
I hope this book will be of use
Book Title:
*Financial Analysis with Microsoft Excel 4th edition*
Book Infos:
Published in 2006
Author: Timothy R. Mayes
ISBN: 0324407505
Book Description:
FAME explores the use of Excel as THE calculating tool for finance
professionals. As students ente
Thanks Alot for your support, that means alot
Hugs & One Love
On Fri, Feb 5, 2010 at 11:52 AM, Sanjoy Nath wrote:
> Dear janet dickson,
> Your problem is solved.
> I am sending the file attached herewith.
>
> Sanjoy
>
>
>
> On Thu, Feb 4, 2010 at 11:17 PM, janet d
Hello frends.
Help me on how to change graphs in excel so that it is 90 degree rotated.
this is very important in my work, as I want to align several graphs side by
side in their rotated view.
See attached file for more details.
Much Love.
--
> ElseIf tCell.Value < 0.01 And tCell.Value <= 0.02 Then
> tCell.Interior.Color = RGB(192, 192, 192)
>
> Range("o21").Interior.Color = RGB(192, 192, 192)
> Range("p21").Value = " 0.059 to 0.066"
>
Hello Guys
I have created a useful code for my work, see below. but the problem: This
code takes almost 3minutes
to complete running. can anyone help me tweaking this to work much better.
Sub UseColorz()
Range("n:n").Select
For Each Cell In Selection
If Cell.Value > 0.02 And Cell.Value
Hi All
Please provide with a code which can put RGB cell values in colored cells.
Hugs
--~--~-~--~~~---~--~~
--
Some important links for excel users:
1. Excel and VBA Tutoria
Thanks a lot for the shortcut, I have been looking for these stuffs
Hugs
From: excel-macros@googlegroups.com [mailto:excel-mac...@googlegroups.com]
On Behalf Of Dilip Pandey
Sent: Sunday, October 04, 2009 12:59 PM
To: excel-macros@googlegroups.com
Subject: $$Excel-Macros$$ Re: Shortcut t
Just send to me that vba file
From: excel-macros@googlegroups.com [mailto:excel-mac...@googlegroups.com]
On Behalf Of shefali singh
Sent: Saturday, September 26, 2009 7:44 AM
To: excel-macros@googlegroups.com
Subject: $$Excel-Macros$$ vba password
hello excel experts
i want a software t
hi
I have numbers ranging from 1 to 1 in excel column, how can i make
random number after every tenth group (and bold it or color that
number)? For example from 1 to 10 i can choose 3 manually, from 11 to
20 i can choose 17, from 21 to 30 i can choose 23...etc.
This is boring in a very large n
hello guys i need on help on making a macro for getting color values/RGB
values for cells or color boxes. See my attachment with color i want to have
RGB
Hugs
--~--~-~--~~~---~--~~
---
thanks for this shortcut
its cul
On Tue, Jun 9, 2009 at 6:18 AM, Abdul Rasheed wrote:
> Name : Abdul Rasheed
> Subject : Save As
> Tip : Press F12
>
> Regards
> Abdul Rasheed
>
> >
>
--~--~-~--~~~---~--~~
--
greetings
help me to create a macro for a chart with:
one chart use column g & l (chart name macro1)
second chart use column k & n (chart name excel1)
each chart will be in new sheet .
The idea is to have macro which uses columns which are not adjacent.
I will be using this workbooks but same co
38 matches
Mail list logo