Re: Excel data consolidation question

Harlan

you're just flat out full of ***.

Don't shoot the messenger-- just because I speak the truth.

A) manager has each employee fill out their hours in a spread***
B) each employee does this and emails it into the manager.

how does the manager import 30 spreadsheets and consolidate numbers out
of all 30 workbooks?

please give me details... you are absolutely full of crap harlan.

C) what happens when someone enters 02042006 instead of 2/4/2006 in a
column?
Excel CHOKES on this simple type of data mismatch
D) what happens when Susie; over in marketing-- wants to take vacation
days.
She adds a column called 'vacation hours' and emails it to her
boss.
Seems like a perfectly natural thing to do.

SO HOW DOES EXCEL IMPORT FROM 30 DIFFERENT WORKBOOKS THEN HARLAN?

Don't talk *** about something WHEN YOU'RE WRONG.

Excel is a disease; and I spit on anyone that uses Excel for anything.

Spit in your face.

There are better ways-- email someone a form in Access; it gets
converted to a DAP (plain HTML); they enter all their data and
presto-chango-- I am ALREADY DONE.

So let's compare your 29 steps -- with rampant points of failure-- to
my much much much simpler and scalable solution.

HOW DO YOU LIKE ME NOW, PUNK?

Grow some balls and learn a real program; Harlan.

What a waste of time.

'yeah; it's more efficient to consolidate 30 spreadsheets than to keep
the data in a single database'

eat *** harlan you spew nothing but worthless garbage.

Excel is a waste of time.. A bigger time-waster than Internet Explorer
and Solitaire combined.

ANY COMPANY THAT WANTS TO THRIVE-- TO SUCCEED-- SHOULD UNINSTALL EXCEL
FROM EVERY MACHINE IN THEIR COMPANY.. AND WORK TO BUILD THE
INFRASTRUCTURE THAT THEY REALLY NEED.

uninstall excel from every machine at every company.

I have a free solution that is scalable and mulitple people can edit
their own data at the same time.

Harlan has a piece of *** technology that is inherently single user;
and not scalable enough to begin to meet the needs it's users.

Excel is crap.

I have a better spread*** than Excel; it doesn't require
installation; it doesn't require copying and pasting hundreds of work
books.

It has version control.
It has an audit trail.

I have pivotTables that are a thousand times better than your silly XLS
pivotTables.






Harlan Grove wrote:
aaron.kempf@xxxxxxxxx wrote...
Excel isn't GOOD for data entry.

Only because you don't really know how to use it.

it isn't GOOD for consolidating multiple spreadsheets into a single
data store.

Again, you don't know how to use it.

Databases are a much better long term solution.

Debatable. Depends on how easy it is to access the information. The OP
mentions different authentication *databases*. If they're truly
database tables, then best to use whatever database that is.

.