I wasn't aware of that, not being a Mac user.
It is possible to use VBA behind the scenes within EXCEL but it is not a straightforward as it is with linked tables and Queries in ACCESS. Pivot...
Type: Posts; User: Griswold
I wasn't aware of that, not being a Mac user.
It is possible to use VBA behind the scenes within EXCEL but it is not a straightforward as it is with linked tables and Queries in ACCESS. Pivot...
I was just about to suggest that too. It's a much more qualified database manager than EXCEL. VBA and SQL can be better used in ACCESS as can Queries across multiple linked tables.