: $$Excel-Macros$$ I'm in budget vlookup hell. Please help
Any chance to think about it?
Sent from my iPhone
On Jul 20, 2011, at 1:06 AM, Adam Hamilton wrote:
> You're a godsend!
>
> On Wed, Jul 20, 2011 at 12:57 AM, Anish Shrivastava
wrote:
>> Tracking sheet.. I see.. I
Any chance to think about it?
Sent from my iPhone
On Jul 20, 2011, at 1:06 AM, Adam Hamilton wrote:
> You're a godsend!
>
> On Wed, Jul 20, 2011 at 12:57 AM, Anish Shrivastava
> wrote:
>> Tracking sheet.. I see.. I will have a look and try my best to give one
>> dummy dashboard by tomorrow.
You're a godsend!
On Wed, Jul 20, 2011 at 12:57 AM, Anish Shrivastava 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
> wrote:
>>
>> However, I get your point, the data is not raw i
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 wrote:
> 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 'ti
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 wrote:
>
The 'time tracking' sheet is where all of the data are pulled to
populate the erroneous amount of fluff that you see in my xls
On Wed, Jul 20, 2011 at 12:35 AM, Anish Shrivastava wrote:
> Hi Adam,
>
> Great thing.
> I would request you again to send me only those sheets which you think are
> raw
Hi Adam,
Great thing.
I would request you again to send me only those sheets which you think are
raw data.
Your workbook contains many sheets (includin pivot sheets) which makes me
unsure that which sheet should I consider as a raw data sheet for dashboard.
As you said, your management wants to
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
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
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
11 matches
Mail list logo
