S
Stan
I thought that this was done automatically but ...
I have a sheet with a list of customers and how much they purchased.
The sheet is to be given to the accountant to be billed. The sheet has
about 8 columns some I fill in and others with formulas. The first
column is the date, after that I have 2 seperate columns that have the
formula for the year and month. 3 more columns of data that I fill in
and then formulas...
I thought that Excel recognized that as soon as there was data in
adjacent columns it would add the formulas automatically... For some
reason I need to copy and paste or drag the formulas down the column..
Is there somewhere to make this happen automatically? I am using Excel
2000 on a terminal server...
Thanks for any help.
Stan
I have a sheet with a list of customers and how much they purchased.
The sheet is to be given to the accountant to be billed. The sheet has
about 8 columns some I fill in and others with formulas. The first
column is the date, after that I have 2 seperate columns that have the
formula for the year and month. 3 more columns of data that I fill in
and then formulas...
I thought that Excel recognized that as soon as there was data in
adjacent columns it would add the formulas automatically... For some
reason I need to copy and paste or drag the formulas down the column..
Is there somewhere to make this happen automatically? I am using Excel
2000 on a terminal server...
Thanks for any help.
Stan