leezac
asked on
Formulas not retaining cell information
I have created formulas on a sheet where I use code to poplulate a form. I noticed when I delete the forms where I paste the data to I get #Ref! in the formula that is to be used to paste into the sheet. Is there a way to not lose the cell references in the formulat when data is deleted?
=INDEX(Cpuimport!#REF!,MAT CH(CPU!#RE F!,Cpuimpo rt!#REF!,0 ))
=INDEX(Cpuimport!#REF!,MAT
ASKER
Thanks but don't understand.....
This is how it should look
=INDEX(Cpuimport!$C$4:$C$5 000,MATCH( CPU!D4,Cpu import!$A$ 4:$A$5000, 0))
I have a formula page and was going to use vba to add to columns on CPU sheet, but when I delete the CPU sheet I the the REF! error on the formula tab
This is how it should look
=INDEX(Cpuimport!$C$4:$C$5
I have a formula page and was going to use vba to add to columns on CPU sheet, but when I delete the CPU sheet I the the REF! error on the formula tab
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Don't delete the cells - clear them instead.
ASKER
Rorya, I tried clear and go the #ref! error....
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
=INDEX(INDIRECT("Cpuimport
Where "Address" equals the original range addresses.
HTH,