CR CrestHome Page of the Central Region - HISD
West Region Web Site Header West Region Home Page

Inventory Checking Spreadsheet
       
Step 1 - Exporting your inventory from SAP
Step 3 - Using the Inventory Checking Spreadsheet
       
This is a description of what needs to be done to succesfully import your inventory from the text file you created when you exported from SAP.
       
Step 2
Importing your inventory into the Excel Inventory Checking spreadsheet
 

A.

Download the spreadsheet, paying attention to where you save it. You may rename it if you wish.

       
 

B.

1 Open Excel and then click the open file icon.
2 Find and open the Inventory Checking spreadsheet you just downloaded.
       
 

C.  Click the open file icon again and find the file you exported from SAP (hopefully you remember where you put it). For the sake of this example, we placed ours on the Desktop.
       
 

D.  Click the Finish button on the text import wizard which opens

       
 

E.  Your report should resemble the example below

Text File Import
       
 

F.  Click on cell C6 and, holding down your mouse button, drag down to the last line of your inventory and column R

Left Top
drag down and to the right from C6

to the last line and column Q
Bottom Right
       
 

G.  Move to the Inventory Checker spreadsheet and make sure cell A2 on the SAP_Inventory tab is clicked

Starting Point

 
       
 

H.  Very important! Go to the Edit menu and select Paste Special...

In the dialogue box that opens select Values and then click OK

Save your document
       
  Now you are ready for Step 3 - Using the Inventory Checking Spreadsheet
       


© 2006 - 2008, The Central Region - Houston ISD. All rights reserved.
It is the policy of the Houston Independent School District not to discriminate on the basis of age, color, handicap or disability, ancestry, national origin, marital status, race, religion, sex, veteran status, or political affiliation in its educational or employment programs and activities.