On 2002-03-07 10:40, Sami wrote:
Hey guys u seem to no ur stuff but erm the problem is i got an accounts worksheet which has weeks and the total sales coloum. there is just 2 coloumns in this worksheet. The sales revenue and week date is taken from the sales worksheet where daily sales are entered. I need to no how excel will group the sales figures by week and paste the week and the sales revenue in the accounts file. Also if say another sale is done and £10 is entered the sales revenue from the week will change automatically.
Cheers. Thanks for the info. v grateful!
On 2002-03-09 00:23, Sami wrote:
i look in format cells date. but there is no week option!
On 2002-03-09 00:57, Sami wrote:
im not using a pivot table. what ive got is an Accounts workbook. This has 2 columns "Week Date" in coulumn A and "Total Sales Revenue" in column B. I would like to know how excel will enter the week date automatically and then get the total sales revenues from the Sales workbook by adding up and grouping the sales by week. Plz accounts is about 30% of projects marks.
On 2002-03-10 02:33, Sami wrote:
it says "that function not valid and highlights "select". isnt there an easier way??? =select(A1:B10)