Hi al

Im having problems with a hyperlink function I thought would work easily

I applied a hyperlink to a cell near the top of each column (each column represents a day and the hyperlink is on the date cell) that will take the user to the totals cell for that column (which is 300+ cells below)

The problem is that users insert rows and the total cell moves causing the hyperlink to go to the wrong cell

I tried applying €œabsolute references€� (ie $EJ$377) to the hyperlink but excel wiped these and reverted it back to a basic cell reference (EJ377)

I then thought of creating a defined area for the totals and writing a macro to go to it, but I dont want to have separate defined areas for every column (the spreadsheet covers 6 months+ of columns = 198 columns) - it seems to increase the file size hugely having lots of them (or is that something I'm doing that is wrong)

Can anyone suggest either a better way to do this or a macro that will €œgo to€� the current columns cell within the defined area named €œTotals€�

The €œTotals€� defined area covers 198 columns and 21 rows
__________________________________________________ ________________________
Also, the excel spreadsheet is constantly "calculating" which holds up and annoys the users - is there anyway to either speed up the calculations or decrease the number of calculations it has to do without loosing immediate results of changes

Note: I could put it on "manual" calculation and create a button for the users to click to "calculate now", but I don't want to do this because they will forget to click it and they will use wrong results

If you need more detail of what's contained in the workbook here it is
2 worksheets
- The activity sheet (198 columns, currently 1100 rows
Users enter sale details on each row via Validation lists, including supplier, company, details of sale, status of sale, placement, size and a number is entered in the date cell
The sheet includes formulas to group supplier totals and show their totals by column, plus placement by compan
The sheet includes filters to view specific suppliers or companies etc

- The Totals sheet (198 columns, 140 rows
100% formulas to summarize the activity sheet (ie show totals by supplier split by company), plus hidden rows to calculate placements against each supplier which are shown on the spreadsheet as one row using a concatenate formula to combine the number (ie (1/0/1)

Any help on these two issues would (as usual) be greatly appreciated €“ I am constantly amazed at how much I am and have learnt from this discussion group and how helpful everyone is. Its enormously appreciated by this novice