Thanks I have attached the file
On Friday, March 16, 2012 7:51:26 PM UTC+2, Brian wrote:
I am using Excel 2007
Depending on the squad number I select in a worksheet I have set up some
formulas so I can find the reference for the first cell and last cell in
the range with reference to the
Just remembered to mention that when I go to the Master sheet (Not in the
attached file) I am changing the day of the competition and that changes
the ranges and times on the squad. Thant is why in the attached worksheet
I am copying the range 4 times.
On Friday, March 16, 2012 7:51:26 PM
This just copies the contents of Range P10 it does not copy the range which
P10 referrs to. I have not attached the whole workbook as it is huge so I
just took the relevant worksheet and the piece of code I am struggling with
and attached that. where the code refers to the Master Sheet on the
