Prev: Add and edit a shape in VBA
Next: Excel, custom format
From: Amin on 19 Apr 2010 03:03
Hi i am about eating an inventory database for a small makeup store, however
thier product are many in terms of category and group. you have the lip
glosses , lip liners, eye liners and so many others like skin care stuff.
what will be the best way to arrange this data should i put all the product
in one colum or seperate them into their own columns. pls advice thank you
From: Jacob Skaria on 19 Apr 2010 03:25
It is better to have 4 or 5 columns such as below;which would help to
summarize information based on category,group etc;

Category
Group
Product name
Product code
Price


--
Jacob (MVP - Excel)


"Amin" wrote:

> Hi i am about eating an inventory database for a small makeup store, however
> thier product are many in terms of category and group. you have the lip
> glosses , lip liners, eye liners and so many others like skin care stuff.
> what will be the best way to arrange this data should i put all the product
> in one colum or seperate them into their own columns. pls advice thank you
From: ozgrid.com on 19 Apr 2010 03:28
Excel works best with data laid out in table format, i.e row 1 for headers
and contiguous data beneath.
http://www.ozgrid.com/Excel/ExcelSpreadsheetDesign.htm




--
Regards
Dave Hawley
www.ozgrid.com



"Amin" <Amin(a)discussions.microsoft.com> wrote in message
news:795AD58F-E6CC-4EBA-BDBE-A337B12BED53(a)microsoft.com...
> Hi i am about eating an inventory database for a small makeup store,
> however
> thier product are many in terms of category and group. you have the lip
> glosses , lip liners, eye liners and so many others like skin care stuff.
> what will be the best way to arrange this data should i put all the
> product
> in one colum or seperate them into their own columns. pls advice thank you

From: Amin on 19 Apr 2010 04:48
Hi thanks for the advice but i still need some help here.

My data is in columns but am particular with the items how they should go
into the sheet. Now we have more than 100 make up items. hould i have all
into one column? and have a grouping column and category column as well or
which. to help you help me check this eg. Lip items under berries,
LIP STICK LIP LINER LIP GLOSS
Apple berry d berry berry sparkle
rich fig plum berry sugarberry

there are other lip items under chocholates, metals, neutrals and so on. now
i wanted to have all items in one column then a column for them to be grouped
as well as categories. any assistance will be apprecated.

the above all falls under berries

"Amin" wrote:

> Hi i am about eating an inventory database for a small makeup store, however
> thier product are many in terms of category and group. you have the lip
> glosses , lip liners, eye liners and so many others like skin care stuff.
> what will be the best way to arrange this data should i put all the product
> in one colum or seperate them into their own columns. pls advice thank you
 | 
Pages: 1
Prev: Add and edit a shape in VBA
Next: Excel, custom format