Morning Zac,
I would not suggest carrying out a process like this for such a large
data set in Excel.
My suggestion would be to perform your pivot table in Access and
report through Excel.
The only other alternative is to consolidate your data before pivoting
it and even this has limitations in
Hi,
I do not even see a way to get all of the data into a single work
sheet. V7 is 1m rows, yes? Given that you are not going to be able to
bring it all in, how many groups of data will you have? Can you bring
your data in as you want to do sub-totals, groups? If you have a lot
of groups and sub-t
Hello Dear,
Once i have read this book when i was totally unaware of even
any computer application.
Off course every one learn from his/her experience.
So try this following book.
Stephen Copestake
EXCEL 2003
in easy step
dreamtech press
ISBN:81-7722-505-7
On Wed, Apr 14, 2010 at 11:25
Dear Michael,
Thanks for the piece of advice. I'm basically new to the management
accounting world. Please do not take this as if I am new to finance and
accounting (But my excel skills are resticted and have no knowledge of
access yet). That said, can you guide me to some tutorials etc or books f
Hi Chaudhry,
I hate to commit sacrilege in the Excel VBA sight but its sounds like
excel is probably not the right solution for such a massive task.
Access can handle larger database queries. Even if you use Access to
perform all your summerizing and then export it back to excel for the
presentati
