Excel question!
Posted: Mon Aug 17, 2015 2:51 pm
Hello all,
I'm looking to convert our current database 20-30 entries from Microsoft Access to Excel, as I hate Access and no one knows how to use the damn thing.
The question is: is it possible to have people's entries that then feed into a template, that can then be printed with each person's entries on a different sheet.
E.g. at the moment we use Access to have a range of people's numbers, e.g.
John Doe 115 / 120 / 90 / 65
Joe Bloggs 120 / 140 / 100 / 90
etc.
which then feed into a template sheet that prints out formulas based on each person, so we get 30 sheets each with say:
John Doe
(115) * .9
(120) * .75
and then another printed sheet with
Joe Bloggs
(120) * .9
(140) * .75
and so forth.
Wanted to know, is this possible in Excel?
Thanks!
I'm looking to convert our current database 20-30 entries from Microsoft Access to Excel, as I hate Access and no one knows how to use the damn thing.
The question is: is it possible to have people's entries that then feed into a template, that can then be printed with each person's entries on a different sheet.
E.g. at the moment we use Access to have a range of people's numbers, e.g.
John Doe 115 / 120 / 90 / 65
Joe Bloggs 120 / 140 / 100 / 90
etc.
which then feed into a template sheet that prints out formulas based on each person, so we get 30 sheets each with say:
John Doe
(115) * .9
(120) * .75
and then another printed sheet with
Joe Bloggs
(120) * .9
(140) * .75
and so forth.
Wanted to know, is this possible in Excel?
Thanks!