Hi,
I'm new to excel apart from the simplist of spreadsheets but I know it is a power tool and I would like to use it to its full advantage.
I have a workbook that I would like to connect the data from the first sheet to the rest of the sheets. So I could change a figure in a column in sheet1 and it would automaticly update the rest of sheets that corressponds to that column.
Also I would like to know if there is a formula that could auto age/count from a specific date for example:
say the date was 2008-01-25 in column G and age to the present date would be 21 days in column I and the next day it would automaticly update it to 22 days and so on.
I'm not sure if this is possible.
thanks in advance
Baz
Bookmarks