Attached is an excel file. There are two worksheets. In Worksheet 1

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

I have eight worksheets in a workbook. The worksheets contains columns of
numbers with a total at the bottom of each column. Is there a way I can add

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


Is there a way to lock 3 or 4 rows of information together so that when

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

What code do I need in a macro to determine whether a sheet is protected or
not?

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

Hi Guys,

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

Hi,

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

How do I create an organization chart from an excel file that has a quot;reports
toquot; column. The quot;reports toquot; column indicates the hierarchy of who reports

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

If I have dates listed in a column as 06-0101 etc, how can I format it to
be: 20060101? I have 7000 rows where I need to reformat the date.

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

We have users sharing a workbook but when they freeze columns or rows
everyone doen not have the cell frozen. Why does this happen?

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

Is there anyway to make the quot;zero and negative numbers cannot be plotted in
log plots...quot; error message? It is really annoying as it goes off every 5

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