#1   Report Post  
Old April 23rd 10, 01:43 PM posted to microsoft.public.excel.setup
external usenet poster
 
First recorded activity by ExcelBanter: Aug 2006
Posts: 48
Default Setting up a workbook

hi i have to design an inventory sheet for a small business and needed some
advice.
i want know if i should format my data into tables in any of the worksheets
or some can be formatted. sheet one will hold every single item the prices
and everything about the workbook, then other sheet can then use formulas and
functions refering to the sheet 1. Lookup formulas and many others.

i will also use at least five rows in one of the sheets with data validation
to make data entry strict and that list will be stored in the sheet one. i
just want to know if having tables with none tables data can be confusing in
terms of formulas

Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Help window setting workbook collapse MrBill Excel Discussion (Misc queries) 0 November 14th 09 11:46 AM
Setting up protection on a workbook brown1965 Excel Worksheet Functions 2 January 11th 09 10:00 PM
setting the default printer for this workbook only mikecoxffbb Excel Worksheet Functions 1 October 25th 08 01:47 AM
Help with setting up a sales tracking workbook Sal Excel Discussion (Misc queries) 0 April 9th 08 10:14 PM
how can i remove workbook protection setting??? raviv Excel Discussion (Misc queries) 1 June 10th 05 07:36 PM


All times are GMT +1. The time now is 08:32 AM.

Powered by vBulletin® Copyright ©2000 - 2019, Jelsoft Enterprises Ltd.
Copyright 2004-2019 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"

 

Copyright © 2017