Laura D. Oliver
|
Here are the instructions I gave one guy in my office. It might be too simple for you. It takes much longer to read this,than to do it. These instructions are for exporting the open SO listing.....you can easlily figure out what to do with the other reports. Directions for to export DBA open SO listing to a spread sheet. 1. List SO-O-A to screen. 2. reduce screen by clicking on magnify glass icon 3 or 4 times 3. Highlight data only-- Do not highlight titles at top of page or column headings or anything below customer total 4. Right click on mouse and option box will pop up. 5. Left click on copy 6. exit out of SO-O-A 7. minimize DBA by clicking on dash in far right hand corner 8. Back at main windows menu-click on start and option options will up. 9. run mouse pointer up to PROGRAMS and other options pop up. PROGRAMS will be high lighted in Black10. 10. with PROGRAMS staying highlighted in Black-slide mouse pointer down to excelL and click open 11. you will see book 1 12. make sure 1A and only 1A is highlighted , right click mouse and press paste. 13. mouse click on Data at top of page 14. click on column A ---it will go black 15. slide down and highlight Text to Columns 16. Push next 17 . Delete lines between space in customers' name by double clicking on each arrow point. do not remove any lines beyond the line after s 18. Push next. 19 Push Finish 20 back to book 1 21. highlight columns A-E etc and rows 1- whatever 22. Copy by clicking on COPY icon at top of page- Data should be look like hollywood marquis 23 Minimize book 1 by right clicking on the minimize at the very top top of the page. 24. At main window menu open WORKS 25. In far left column choose works spread sheet 26 now mouse click on START A BLANK SPREAD SHEET and open a new spread sheet 27. mouse highlight on 1A , right click and press PASTE 28. Go to top left and press FILE 29 slide down to SAVE AS and choose ------ as directory, name file w/date and save. 30. highlight-select all data 31. Go to FORMAT at very top mid page, slide down to COLUMN WIDTH and choose BEST FIT 31. Delete Column A (which should be PCC) 32. Column A should now be SO# and Column B should be raw date. 33. Fix date by highlighting column B, click on FORMAT, slide down to NUMBER, fill in date circle_OK 34 Fix price by highlighting column C, click on FORMAT, slide down to NUMBER, fill in currency -OK 35. Save by pressing diskette icon on tool bar 36. now modify-add column headings, delete colums etc. 37 SAVE again 38.close your new spread sheet 39 right right click on minimized excelL book 1 spead sheet and close
|