Hoopsah
03-13-2012, 03:19 AM
Hi
not just an Array problem, also me headbutting the screen problem.
I have a sheet where the user inputs a reference and it should list all the occurances of the reference taken from the Database tab.
It sort of works except for a couple of things.
The formula I have in cell A12 - no matter what I do it repeats itself in cell A13 - I cant change 1 without the other changing too.
This is causing the rest of the formulas not to work and resultantly I don't get the right details populating the correct area.
What am I doing wrong that I can't seperate these 2 cells??
All help will be welcomed,
Cheers
Hoops
not just an Array problem, also me headbutting the screen problem.
I have a sheet where the user inputs a reference and it should list all the occurances of the reference taken from the Database tab.
It sort of works except for a couple of things.
The formula I have in cell A12 - no matter what I do it repeats itself in cell A13 - I cant change 1 without the other changing too.
This is causing the rest of the formulas not to work and resultantly I don't get the right details populating the correct area.
What am I doing wrong that I can't seperate these 2 cells??
All help will be welcomed,
Cheers
Hoops