#1   Report Post  
Posted to microsoft.public.excel.setup
external usenet poster
 
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 12:46 PM
Setting up protection on a workbook brown1965 Excel Worksheet Functions 2 January 11th 09 11: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 05:15 AM.

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

About Us

"It's about Microsoft Excel"