# how to create many absolute cells

1. ## how to create many absolute cells

Hello

I have a question how to create absolute cells in column C which has formula to compare compare A cell and B cell.
For example, A1 is compared with B1. C1 has the formula i.e. C1 = IF(A1=B1, "yes","no"). Data continues from Row 1 to let say down to 1000.
copying C1 to all the way down to C1000.

But now the challenge is, i need to insert or delete cells in A column or B column randomly which changes the C reference cells.
So making them absolute i.e. C1=IF(\$A\$1=\$B\$1, "","") C2=IF(\$A\$2=\$B\$2, "","") ....C1000=IF(\$A\$1000=\$B\$1000,"","") is what I want to do.
It can be done easily for a few cells, but if there are thousands of cells, how can I create ?

Thank you
Samky2005

2. ## Re: how to create many absolute cells

Hi,
I don't know what your skills are in Excel, but I would do this via VBA, a macro:
``Please Login or Register  to view this content.``
Cheers
Erwin

3. ## Re: how to create many absolute cells

=IF(\$A\$1=\$B\$1, "","") does not achieve much, does it?
And why use absolute references when you will insert or delete cells anyway which will change the outcome?

4. ## Re: how to create many absolute cells

Hi Erwin

Thank you so much! That gives me exactly what I wanted to do.
I just took a few youtube videos to undersatnd how to deal with VBA/Macro, then I see the effect right away.
I will spend some time about VB/macro since I'm not familiar with it. The command reminds me of the script i used in SecureCRT.

Thank you
Sam

6. ## Re: how to create many absolute cells

Hi
Oh Actually, what Erwin advised me created formula successfully. But you are right. once I insert/delete cells in A or B column, the absolute formula in C column also changed. Hmmm

Thanks
Sam

7. ## Re: how to create many absolute cells

Hi AliGW

Thank you for the reminder. Yes, I was responding to 2nd reply and about to do so.

Thanks
Sam

There are currently 1 users browsing this thread. (0 members and 1 guests)