View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.newusers
Paul B
 
Posts: n/a
Default How to start a spreadsheet (inventory)

kailuamike,
See if this will get you started. With quantity in A1, part # in B1,
description in C1, sell price in D1, cost in E1, total cost in F1, put your
data in rows 2:?? In F2 put =A2*E2 and copy down. post back if you need
anything else or if this is not what you want.

--
Paul B
Always backup your data before trying something new
Please post any response to the newsgroups so others can benefit from it
Feedback on answers is always appreciated!
Using Excel 2002 & 2003

"kailuamike" wrote
in message ...

I am having trouble just getting started here. I need to make a parts
inventory spreadsheet, listing quantity on hand, part number,
description, sell price, and cost price, with the last column being
total cost for quantity on hand for each line item. I have several
books here, a help CD, friends eager to help, but all of the books,
CD's, friends, etc. assume that I know how to walk, and they are all
trying to teach me how to fly. I have learned many magical and
wondrous ways to manipulate data in spreadsheets, but I haven't been
able to find a simple explanation of how to start one in the first
place. Color me retarded. Any help?


--
kailuamike
------------------------------------------------------------------------
kailuamike's Profile:

http://www.excelforum.com/member.php...o&userid=29558
View this thread: http://www.excelforum.com/showthread...hreadid=492603