f circular referencing.
> However, it can be done with macros, either automatically, or by button
> click.
> So, which would you prefer: Worksheet functions with extra column, or VBA?
> Regards - Dave.
>
>> Date: Thu, 22 Jul 2010 18:42:53 -0700
>> Subject: $$Excel-Macros$$
HLC
-- Forwarded message --
From: MNM
Date: Fri, Jul 23, 2010 at 7:12 AM
Subject: $$Excel-Macros$$ Auto Calculate Number to Percent
To: MS EXCEL AND VBA MACROS
Hi,
I am trying to figure out if there is a way to auto calculate number
entered into a column to total percent
Dave.
> Date: Thu, 22 Jul 2010 18:42:53 -0700
> Subject: $$Excel-Macros$$ Auto Calculate Number to Percent
> From: mnaf...@gmail.com
> To: excel-macros@googlegroups.com
>
> Hi,
>
> I am trying to figure out if there is a way to auto calculate number
> entered into a
Hi,
If I say clearly then this is not possible to change the "Hour Worked"
value in percentage in the same column.
The reason is that when a value is changed to percent what will
converted to a fraction.
Date User Hours Worked Hours Worked %
16-Jul ABC8
Hi,
I am trying to figure out if there is a way to auto calculate number
entered into a column to total percent. Example
Column A contains 'Date'
Column B contains 'User'
Column C contains 'Hours worked'
Based on the value in column B User 'XYZ' I should be able to convert
hours worked into tota
