G
gceiley
Hi,
I have an excel sheet that's linked to a query in an access datadase. I'm
looking to make it possible that upon opening the excel file, user's can
choose to view data by one of two parameters (the column names are product
code which isn't a visible field, and ID). Once the parameter is chosen,
subtotals of each columns are displayed at the bottom. Can anyone point me in
the right direction to achieve this, I'm kind of lost. Also I don't have much
experience with Visual Basic, but know this is the direction I have to go in.
I have an excel sheet that's linked to a query in an access datadase. I'm
looking to make it possible that upon opening the excel file, user's can
choose to view data by one of two parameters (the column names are product
code which isn't a visible field, and ID). Once the parameter is chosen,
subtotals of each columns are displayed at the bottom. Can anyone point me in
the right direction to achieve this, I'm kind of lost. Also I don't have much
experience with Visual Basic, but know this is the direction I have to go in.