I am using Excel in Microsoft Office 2010, and I have created a Workbook for Golf Opens that contains 3 Competitions. Each competition is created on 4 worksheets, each competition is seperate and will contain different information. The worksheets are
1. All application data including date, time, name, handicap, entry amount, cheque no, and if cancelled date and cheque number that has returned the money. Also this has the players partners name etc.
2. A startsheet, which contains tee off time name of team i.e. the 2 names from the application sheet and which is their home club the players handicap allowances plus a result column.
3. A Results sheet which is a direct copy of the startsheet. The Result column is manually sorted using the sort system at different times during the day to ascertain the leaderboard
4. A balance sheet.
The problem I am having is copying the data from one worksheet to another, and instead of getting the name I get the formulae i.e. ='entrysheet1'!j10 instead of John Doe for example. The columns are formatted identically and I cannot find out why this is occurring in some columns when I get the required result in another column.
Can anyone assist please ?