1st off I want to thank anyone that takes time to reply my stick. OK heres my big mission..... I have an EXCEL spreadsheet that is an inventory with about 15 fillable blocks. This spread sheet due to regulation has to be the exact size and the frames have to be exacly in every page.
I issue and recieve new equipment all month long and have to put everything in alphabetical order which is alot of work. Now i want to create a database where I can put all current material and as the material comes in or is issued is filled into a specific sheet (excel) and if the 15 blocks to put the info in are full to start a new page. I need certain data in certain fields. Also the name for equipment has to be in alphabetical order. I need ideas fast!!! Please help.
THanks
[IMG]2653.jpg[/IMG]
"WarFighter" I have attached picture of spreadsheet!!!!!!!!!

First off, one of the guys based in Heidelberg has already solved this problem. Why re-invent the wheel?

His solution was based on overlaying the data from a VB app with the PDF of the standard form. It was rather persnickity about the font used, and I've never seen it work on anything other than an HP Laserjet, but that was never an issue.

Just an observation on my part, but how many COMSEC devices can you really handle in a month? I can't imagine that it is worth the effort to automate the completion of this form, especially considering that it is due to be completely automated in under 30 months.

I'd do a bit of looking before I bothered to write another tool to do this.

-PatP

Pat, Hiedelberg you say? What unit so i can give them a call.. But there has to be a way to make a huge datbase with rules to make them go in alpahbetical and ez'er. Thanks I need more input database Guru's

Without looking it up, I'm not sure but I think he was with the QM. I only knew him as HuebnerE, but that might be enough for the base locater to find him for you.

-PatP