Fiona has attended:
Excel Intermediate course
Excel Advanced course
Macros/VLookup
Hello,
I currently have a spreadsheet of data that is becoming too large, it is very slow and takes a long time to save.
All the data is date specific and we really only need access to the data from the last year or so.
Is there a way to automatically move the data from one workbook to another when it becomes over a year old so we can have a current and 'archive' workbook?
Thanks
RE: Macros/VLookup
Hi Fiona,
Thank you for the forum question.
Yes if you have a lot of VBA knowledge and SQL knowledge you can write a code to do what you want.
If it was me I would use Power Pivot to handle the data. Power Pivot can without any problems handle millions of records.
Kind regards
Jens Bonde
Microsoft Office Specialist Trainer
Tel: 0207 987 3777
Best STL - https://www.stl-training.co.uk
98%+ recommend us
London's leader with UK wide delivery in Microsoft Office training and management training to global brands, FTSE 100, SME's and the public sector
