formula

Occasional Visitor

Hello, I got a problem with a formula,

I got a database with 2 sheets,

1 with data of my Vinyl records for my jukebox

2 with Labels that I made by my self.

 

Screenshot 2021-11-04 114218.png

 

Screenshot 2021-11-04 114309.png

 

Screenshot 2021-11-04 114403.png

 

If I cut or copy the cellB1 in my 'jukebox files' then my formula is gone and not stay on this cell.

is the a solution to keep that formula on that cell??

I already tried it with the Dollar sign and also with copy and not cut then afterwards delete the data out of the cell, but my formula still gone.

maybe someone can help me out here?

thanks in advance

Moods1960

 

0 Replies