Extract Data from an Access Database in to Excel
There is a facility within Excel to extract Data based on parameters in to
Excel. I use this and it works great based on one parameter. But is it
possible to set 2 parameters to work from. It seems obvious but I can't get
it to work.
My scenario is that at the moment I extract from a Timeclock database
between 2 dates (from and to fields), but I only need the data from a
certain employee, between the dates I select. I have a cell where this
employess number is - A2, based on what I do to extract the specified dates,
I've added another criteria, but it doesn't work - can it?
Thanks
|