I have a data on worksheet 1 column A = month column D = Salesman column

software 發表在 痞客邦 留言(0) 人氣()

With Excel, is it possible to generate automatically a sequence of number
that would increse by one (1) each time the file is used? As an example

software 發表在 痞客邦 留言(0) 人氣()

H?ow do I automatically run a macro when a worksheet is opened

software 發表在 痞客邦 留言(0) 人氣()

I have a form that makes heavy use of cell validation.
When the Office Assistant is active, the validation messages appear next to

software 發表在 痞客邦 留言(0) 人氣()

Hi - I would be really grateful if anybody knows a function to return the
formula contained in one cell to another cell as a text string?

software 發表在 痞客邦 留言(0) 人氣()

How do I skip a formula, if left of cell does not equal a colon, followed by
7 numbers? thanks.

software 發表在 痞客邦 留言(0) 人氣()

I want to creat a work sheet at the top of the work sheet in a portrat style
I need what I will call a header. With text indicating tital of sheet and

software 發表在 痞客邦 留言(0) 人氣()

Column D is a dropdown list of shirt sizes from S to 4X.
I am trying to get the price to show up in Column F, depending on what size

software 發表在 痞客邦 留言(0) 人氣()

I have very large spreadsheets with 10s of thousands of items, all with
unique identifiers. I then get a small subset of those identifiers and have

software 發表在 痞客邦 留言(0) 人氣()

In Excel 2003 when I press the up/down arrows on the Keyboard the whole page
is scrolling up and down instead of going through the cells moving. Any

software 發表在 痞客邦 留言(0) 人氣()