I have a not too large excel book used for field technicians to make job reports. There is a lot of information to enter, and a combination of drop boxes, check boxes, diagrams, and a whole lot of data entry tables with some formulas etc
the tables are all macro controlled. If the tech wants to enter 4 items for a particular field, she can initiate a macro which will then create a formatted table with 4 entries, etc
the field report will turn into the final report, so as such all the tables etc are pre-formatted for size, colour, text size, etc. this makes an OK looking report at the expense of some difficulty for the techs to enter the data
what id love is a way to allow data entry in a very simple, no frills excel sheet, but generate much more complex reports from it with all the formatted tables and junk
ive looked at access but the user form style isn't an efficient way to enter 100 row by 50 columns of data from the field point of view. Is there another program (or some excel tricks I've never came across) that will give me the best of both worlds?
the tables are all macro controlled. If the tech wants to enter 4 items for a particular field, she can initiate a macro which will then create a formatted table with 4 entries, etc
the field report will turn into the final report, so as such all the tables etc are pre-formatted for size, colour, text size, etc. this makes an OK looking report at the expense of some difficulty for the techs to enter the data
what id love is a way to allow data entry in a very simple, no frills excel sheet, but generate much more complex reports from it with all the formatted tables and junk
ive looked at access but the user form style isn't an efficient way to enter 100 row by 50 columns of data from the field point of view. Is there another program (or some excel tricks I've never came across) that will give me the best of both worlds?