I recently updated Office 97 to Office 2003. When Excel 2003 came up it had
my customized toolbars from my 97 version and then after about a month Excel

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


Hi, I'm looking to set up a spreadsheet where users enter new months

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

I'm curious if anyone knows if it's possible to feed a bunch of random cells
into an array, and as those cells are populated (regardless of which gets a

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

For ex: if the Value in the Cell is quot;3456quot; i want to change that to quot;23456quot;.
Similarly every cell should be prefixed with quot;2quot;

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

I want to be able to automatically copy data from a number of different
spreadsheets to a summary spreadsheet on a weekly basis using the VLOOKUP

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

Looks like this;

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

D7 has a dropdown list with customer names (10 -12 customers). F16 thru F38
each have a dropdown list with a vlookup of a products list. Infomation in

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

I have a spreadsheet that looks as follows:
A B

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


I now have all of my info on one line. I can get it to sort.

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

i'm trying to enter a formula for an invoice in excell h.s.landing @ 3.80 a
sq mtr x 10sq mtrs would be £38.00. how do i write that as a formula so that

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