back to ACBC Home 

Instructions for Ordering from the 2004 Agritech Price Lists.

There are two price lists for ordering either Groceries (Food Items) , Health and Beauty Products. All catalogs are available in Excel format.

Both Groceries and Health & Beauty Price Lists now have the same format!

 

INSTRUCTIONS:

1. Download the Zip file "2005 ACBC Order File.Zip" and save it to your hard disk. Unzip the four files: 2005 Grocerie.xls, 2005 H&B.xls and 2003 Agritechorderforms.xls. and save them to your hard disk.

2. Now open all three files in individual windows.

Note: The files have been color coded and areas of the files have been protected to prevent you from changing any of the data or format of the files. This was necessary due to problems with the last orders.

3. Browse through each price list and when you find the item that you wish to order simply copy the 6 cells (columns A-F) that contain the data on that item to a blank line(row) in your order form. Please put the Groceries on the "Groceries Order"sheet and the Health & Beauty on the "Health & Beauty Order"sheet.

To do this:

  1. Highlight the 6 cells you wish to copy (columns A to F). Hit the copy icon (or right click the mouse and choose copy).
  2. Hit Ctrl + Tab until you move to the Order window.
  3. Place the cursor in the first blank cell in column A (starting at row 10). Hit the Paste icon (or right click your mouse and chose Paste)
  4. DON'T COPY THE ENTIRE ROW - OR YOU WILL WIPE OUT FORMULAS ON THE ORDER FORM!!!!!

( Note: If you order extends below row 150 then you will need to contact me!)

When you have finished ordering all the items.

4. Fill in your Name and Membership # on the "Groceries" sheet and save the order file with a name like:

ACBC *** Apr04.XLS where *** is your Membership #.

5. E-mail this file to me as your order. You should also print this file, sign the top and send/give it to me with your check.