Hello,
I have a large amount of data that I receive with timesheets each
week. I am currently using many, many vlookups and pivots to achieve
the results that I need. My goal is to get the resource data by hours
and spend, by month and project. Please take a look and let me knowif
you can help.
@googlegroups.com [mailto:excel-macros@googlegroups.com]
On Behalf Of Adam Hamilton
Sent: Thursday, July 28, 2011 9:17 AM
To: excel-macros@googlegroups.com
Subject: Re: $$Excel-Macros$$ VBA Needed to summarize employee data from raw
data
Thanks for responding. Attached is the sample dataset.
On Wed, Jul
Hello,
I have a large amount of data that I receive with timesheets each
week. I am currently using many, many vlookups and pivots to achieve
the results that I need. But I know there is a VBA, but I can't
figure out what it is. Please take a moment and look at the samlple
file, and desired
Thanks for responding. Attached is the sample dataset.
On Wed, Jul 27, 2011 at 7:06 PM, ashish koul koul.ash...@gmail.com wrote:
can you attach the sample file
On Thu, Jul 28, 2011 at 7:28 AM, Adam Hamilton adamchamil...@gmail.com
wrote:
Hello,
I have a large amount of data that I
Hello, I need to take employee data, and run a macro that will allow
me to populate many different types of conclusions from this data.
For example,
If I have the resource, project, hours, description, spend, etc, I
would like to be able to quickly see the conclusions of resources
spend by
That's what I'm currently doing, but want something more efficient.
On Sun, Jul 24, 2011 at 1:45 PM, GoldenLance samde...@gmail.com wrote:
Try using a Pivot Table. one of the quickest and easiest ways for
data consolidation and view in Excel
Sam Mathai Chacko
On Jul 25, 1:43 am, Adam
AM, Adam Hamilton adamchamil...@gmail.com 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 of my syntax are failing!!!
I’ve spent endless hours on this, can
, 2011 at 12:49 PM, Adam Hamilton adamchamil...@gmail.com
wrote:
Thanks so much. A dummy dashboard would be great. Once I can grasp
the concept, I know it shouldn't be any problem expanding on it at a
later time. My idea is for executive mgmt to be able to select a
resource and see everything
However, I get your point, the data is not raw if I am adding a sum of
spend based on resource allocation and budgetary spend.
The 'time tracking' sheet is supposed to be the 'raw' data, but since
it has been altered, I guess I have none..
On Wed, Jul 20, 2011 at 12:44 AM, Adam Hamilton
You're a godsend!
On Wed, Jul 20, 2011 at 12:57 AM, Anish Shrivastava anish@gmail.com wrote:
Tracking sheet.. I see.. I will have a look and try my best to give one
dummy dashboard by tomorrow.
On Wed, Jul 20, 2011 at 1:16 PM, Adam Hamilton adamchamil...@gmail.com
wrote:
However, I get
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
11 matches
Mail list logo