Search results for query: *

Sorry, I guess I am not being very clear. There is one large document that includes all letters. As stated in my first post, there could be 10000+ pages worth of accounts in the file generated by the billing system. The Company name is our company name, and is listed at the top of every page...

This is an example of what the letter looks like. The page breaks in the text file look like that little box character []

Yes, that is essentially what I am looking for. The edit report is more precise and is able to 'weed out' based on more criteria, like users, etc. The letters only have one criteria: errors So, if there are other criteria that we want to exclude from the letters, we have to do it manually. My...

let me clarify... essentially what I want, is for word to do a find of each account number in the excel file, and then delete the page if it is there. I figure that I can have the lady do filters with delete/send and then have the word doc look through the spreadsheet to select the pages to...

where do you find personal.xls? I tried to search my C:\ drive and nothing showed. I did however, create the sheet.xls and book.xls files and places them in my XLSTART directory. Should I do the same with personal.xls? i.e. create it and save it?

Our medical billing system has the ability to generate letters asking our clients to supply information that was missing on the original order. We need this information in order to bill insurance. The system generates two things: an edit report that our employees can use to fix any errors that...

this page might help you utilize the iserror function to show your custom error message http://spreadsheets.about.com/cs/excelfunction1/a/iserrorfunction.htm

My many thanks to Frederico for his continued help with the processing of this file.

too right about styles and structure. I don't use them as much as I should, but we have people here that still put spaces instead of a tab, and use an * to signify a bullet and then hit enter and spaces until the beginning of the next line lines up with the first.

Thank you Dale. I just fired of an e-mail to you with the file and more details.

I have a spreadsheet with three worksheets: the first worksheet has VA insurance data the second worksheet has TN insurance data the other has revisions that were posted to the first worksheet. my manager wants the revision sheet at the bottom of the data worksheet, but then the data worksheet...

what about saving this file to a PDF and then distributing the PDF? You can prevent printing in a PDF, can't you?

I have a text file that I am unable to import into excel. The file is over 2000 pages long when I load it into word. Is there a way to save this text file into shorter text files - say 20 files of about 100 pages? How would I do this?

I am using excel 97. I tried setting the sheet to import at row 65536 but it won't allow me to set this value to anything over 32767

thanks, will try the two options and see which works best for my situation. the deal was that I was creating procedures using the job descriptions file, because that is what was sent to me to begin with. The format for the JD file is different from the procedures document, and they now want me...

I have a text file that, when loaded in word, is about 2000 pages. When opening this file in excel it will of course not load the whole file into one sheet. How do I load the file into excel over multiple sheets so that I can then extract the data I need?

I have a number of files that were based off a template called "Job Descriptions". Now my higherups want to use a template called "Procedures". How can I replace the template for the files I have already created from Job Descriptions to Procedures and have them all work the way they would if I...

Yes, that is exactly what I was looking for. Thanks so much :)

I am working with a report that dumps data in the following format. The first line for each patient shows the account number, name, date, and test code. 142L56887 SMITH,MARY 10/18/04 C300055 0 MC - MEDICARE 0 C300450 0 0 0 MISC00005 0 0...

I have a document that prints form letters telling the recipient of attached errors. The document then prints the errors following the form letter. I want to remove the form letters from the document and only print the errors. I can remove the text from the letter, but cannot remove my...