Thank you Max. That worked fine. Any ideas on how to have the period number
update. I'm sorry as i am quite a novice when it comes to excel.

"Max" wrote:

Some thoughts to get this phrase done up auto:
or "This data €¦€¦€¦. to 30 September 06"

Assuming the phrase is to pick up data in A2 and then concat it with the
last day of the current month, then something like:

="This data " & A2 & " to " &
TEXT(DATE(YEAR(TODAY()),MONTH(TODAY())+1,1)-1,"dd mmmm yy")
--
Max
Singapore
http://savefile.com/projects/236895
xdemechanik
---
"Lynda" wrote:
Wasnt sure what to put in as the subject.

Sheet 1 is my compiled data sheet. I have 12 other sheets with each
representing that months data. Sheet 1 is linked to each months sheet picking
up all the totals for that month and putting them in a table.

Eg. Sheet 1 represents period 1
Sheet 2 represents period 2
and so on

In sheet 1 I have a number of lines referring to the end of period or has
the end of month date

Example

This data represents €¦€¦€¦€¦€¦. to the end of period 3 of FY 06-07
Comparison data for period 3 FY 05-06
or This data €¦€¦€¦. to 30 September 06


Instead of having to go through and manually change all these dates and
period numbers in sheet 1 at the end of each month I want to know how I can
have these lines automatically update at the end of each period.