Hi Adam,
Looking at your workbook, it seems that it's a complete dashboard project to
be completed and in these cases Sample data wouldn't do the perfect job
(However we can create one dummy dashboard).
I understand that you want it to be interactive to the user creating
homepage and navigation w
Hi, Guys,
Thanks. You're recieving this error b/c I ommitted the resources
names for confidentiality. I'm looking for a macro, or complex
formulae that will allow the dashboard to be both interactive to the
user, as well as auto populate data, charts, stats, etc.
On Tue, Jul 19, 2011 at 6:10 AM
Hi Kaushik,
The criteria that you have mentioned is not clear enough. Please clarify the
critera properly.
Do you mean it would sum is all the criteria is met or sum only the cells
that meet the criteria.
Cheers,
Andy
On Wed, Jul 20, 2011 at 1:15 AM, kaushik modak
wrote:
> Hello Guys,
>
> Pleas
Hi Anish & John,
Thanks for the reply.
Attached the sample file. Please check
Regards
Shiek
On Tue, Jul 19, 2011 at 11:45 PM, john wrote:
> you answers in the notes a the bottom do not make sense. please
> review
>
> On Jul 19, 5:26 am, Anwar Mohd wrote:
> > Hi All,
> >
> > Can any one hel
Hello Guys,
Please help me to get to result in the attached.
I have tried with sumifs, if etc., but not getting the accurate result.
Regards,
Kaushik
--
--
Some important links for excel users:
1. Follow us on TWITT
I sorta see from the notes below the data what you are trying to do,
but the sample results do not seem to match the data. ??? please
check it for correctness or explain further how you reached those
results
On Jul 19, 5:26 am, Anwar Mohd wrote:
> Hi All,
>
> Can any one help me with this.
>
>
Sub enterTotals()
myArr = Array(4, 5, 7)
For i = LBound(myArr) To UBound(myArr)
For Each rngArea In Columns(myArr(i)).SpecialCells(2, 1).Areas
With rngArea.Cells(rngArea.Cells.Count).Offset(1)
.FormulaR1C1 = "=SUM(" & rngArea.Address(1, 1, xlR1C1) &
")"
.Interior.Co
I see in the raw data the vlookup that fails. this is because the
value in Column A does not have the name of the resource (column F in
your Ratesheet)
don't know what other problems you are having
On Jul 19, 1:30 pm, Adam Hamilton wrote:
> Sorry. It's attached. You have NO IDEA how much this
try this
Sub enterTotals()
Dim x
x = Array(7, 9, 10)
For i = LBound(x) To UBound(x)
For Each rngArea In Columns(x(i)).SpecialCells(xlCellTypeConstants,
xlNumbers).Areas
With rngArea.Offset(rngArea.Rows.Count).Resize(1, 1)
.FormulaR1C1 = "=SUM(" & rngArea.Address(1, 1, xlR1C
Hi Mahesh,
Thanks for your help.
I'not sure if my first query wasn't confusing. In between, I found
another way to deal with this query.
My first query was about having one button on let say 10 or more
sheets. Each button should be related to the same code. In other
words, button.Sheet1=>button.
Hi Daniel
Sorry to say, still doing the same thing.
I am using Excel2000 and Win7.
Appreciate yur comments.
Thankyou
Charlie
On Tue, Jul 19, 2011 at 10:37 PM, Daniel wrote:
> Sorry. Hope this one is better.
>
> ** **
>
> Daniel
>
> ** **
>
> *De :* excel-macros@googlegroups.com [mai
Hi Adam,
Are we missing the Sample db as attachement?
On Tue, Jul 19, 2011 at 6:40 PM, Adam Hamilton wrote:
> Hi, guys,
>
> So, I’ve created this complex budget workbook for the department I
> manage. Everything is automated, however, now that I want to create a
> dashboard with the data, all o
Dear members,
As you already know that I am collecting ideas and new features that you
would like to see in upcoming version of MS Excel.
The only intent here is to make excel awesome for the users and give
feedback to Microsoft on their product. These ideas will be reviewed by
Microsoft Excel
Hi, guys,
So, I’ve created this complex budget workbook for the department I
manage. Everything is automated, however, now that I want to create a
dashboard with the data, all of my syntax are failing!!!
I’ve spent endless hours on this, can someone PLEASE guide me in the
right direction? As yo
So either this didn't post, or there is no way on earth for this to happen.
John
On Fri, Jul 15, 2011 at 2:39 PM, John A. Smith wrote:
> Is there a way to have my Quick Access Toolbar portable (like on a jump
> drive) so any computer with Excel 2007 can have my customized Quick Access
> Toolbar
Thanks for the reply Ashish,
However I need to skip around a bit since not all columns need
summed.
For instance Columns 4, 7, 9 need summed but those inbetween do not.
--
--
Some important links for excel users:
1. F
Hi Anwar,
You requirement is not clear to me.. Merge few cells (manually) in the
sample sheet according to your requirement and send it.
Will write the code for you.
Thanks,
Anish
On Tue, Jul 19, 2011 at 3:56 PM, Anwar Mohd wrote:
> Hi All,
>
> Can any one help me with this.
>
> Regards
>
> Anr
Hey Haseeb,
This formula is AWESOME man... Tooo goood.. helped me big time..
A big THANK YOU :)
Thanks,
Anish
On Tue, Jul 12, 2011 at 8:25 AM, Haseeb Avarakkan <
haseeb.avarak...@gmail.com> wrote:
> Hello, Try this Array Formula. Must hit CONTROL+SHIFT+ENTER, rather than
> ENTER.
>
>
> =INDEX(
Sam,
This is really great to know you got it working tht's the best thing..
The code for find and replace can be reduced to few lines.. but it's fine as
long as it serves the purpose. :)
Cheers,
Anish
On Tue, Jul 19, 2011 at 5:19 PM, Samuel Murray (Afrikaans translator) <
afrika...@gmail.co
Anish Shrivastava wrote:
> Anyways, I will give you another macro which will search in each cell on the
> sheet and if it finds a value then it will populate cells address at the
> begining for the text but this may lead to problem with formulas.
Your latest macro actually stops and gives me a
Dear EE,
Dear Ashish,
Its really helpful for me to understand the VBA.
My requirement is 85% similar but I also want to add some selective
greeting picture in body text after massage and before signature and
also want to sent the mail thru excel with Permission “Do not forward”
and “Do not Reply”
Hi All,
Can any one help me with this.
Regards
Anr
-- Forwarded message --
From: Anwar Mohd
Date: Mon, Jul 18, 2011 at 3:58 PM
Subject: Need Formula or Macros
To: excel-macros@googlegroups.com
Hi Experts,
I need formula or macro to concatenete the rows by mail id or reps. At
Hi,
Check The Below link
http://www.mrexcel.com/articles.shtml#Charts
--
*Best Regards,*
*Venkat*
*
*
On Tue, Jul 19, 2011 at 11:37 AM, Chandra Shekar <
chandrashekarb@gmail.com> wrote:
> Hi,
>
> I need a book about graphs/charts only. Thanks!
>
> On Wed, Jul 13, 2011 at 7:15 PM, Vikas Chou
Hi ,
Please Look below Link
http://www.brainbell.com/tutorials/ms-office/excel/Create_A_Speedometer_Chart.htm
*Best Regards,*
*Venkat*
On Tue, Jul 19, 2011 at 11:36 AM, Chandra Shekar <
chandrashekarb@gmail.com> wrote:
> Hi,
>
> Any suggestion please.
>
> On Mon, Jul 18, 2011 at 2:31 P
24 matches
Mail list logo