I have spent months converting the useless report document for my work from its original Word file to the more user friendly
It works really well and has a few people interested. The problem I have is that I used a lot of
consatination and formulas to write the repeated information that goes onto different areas of the report (customer,
location, measurements units, etc). This means that pages can not be easily edited out of the finished report as that causes
#ERROR and #VALUE messages to spring up all over the place. When we had the older Word version of the report the guys
usually spent a day after the job, edditing out the unwanted bits of the report. I want to use Excell to sort of do away
with this frustrating exercise while avoiding the #ERROR and #VALUE messages.
What I thought of was a VBA routine
that will select the pages for printing To understand. There are fact sheets covering all the equipment we may supply to
our customers. These are filled out at the end of the job and the printouts are handed to the customer as their hard copy.
Not all the equipment in the report will be used and I have set these pages up so that they remian blank. This works well
enough at the moment - the blank pages are easily identified for discarding prior to adding the report to the completed
How I think the programme will best work is that it will look for a value in a cell and if it finds the
value of that cell is 1, it will go to the next programme line which will tell excell which area to highlight and then the
next line will print that area. The VBA programm will then move onto the next page and identify the cell that holds the
value, If it is a zero instead of one then it will skip to the next page, and so on and so on until the the vba programme
has reached its end. Ideally this programm will be started by a simple button on the spread sheet itself
in the process of shopping around for a book on Excell VBA. I intend to use VBA code in future Excell spreadsheets to
automate jobs that are not covered by Excell functions and formulas.
Past experience has been 10 years writing
spreadsheets which I use in my job as a technician. Spreadsheets cover number crunching, form filling, data manipulation.
Applications used - Psion Sheet, Lotus, Excell. Prior to that I wrote programmes in Basic programming language on a hand
held computer to carry out the same work I have just described.
Gone on a bit here but without the detail you
folks might not understand what I have been up to or where I might be going with this.
Any advice or help will be
most appreciated as I am fed up with colleagues at work telling me how easy it would be, but not coming up with the goods
H and ignore the pages that have been left blank (