ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Setting up and Configuration of Excel (https://www.excelbanter.com/setting-up-configuration-excel/)
-   -   Setting up a workbook (https://www.excelbanter.com/setting-up-configuration-excel/262245-setting-up-workbook.html)

Amin April 23rd 10 01:43 PM

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


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

Powered by vBulletin® Copyright ©2000 - 2019, Jelsoft Enterprises Ltd.
ExcelBanter.com