Copying a Format.

Hi all,

I need a little help with copying some formulas, tried googling but couldn't find an answer, and I'll do my best in explaining,

I've completed some simple formula for cells linking it to another another tab in the same sheet, but copying and pasting onto another worksheet will continue to link it to it's original source even though I do not want it.

eg : =-SUMIFS(Table[Net amount],Table[Gender],Sheet2!B4), but when I copied the formula, and paste it elsewhere, it would be different, as below,

=-SUMIFS(FEB.xlsx!Table[Net amount],FEB.xlsx!Table[Gender],Sheet2!B4).

All I ever need is for the formula to remain the same. So how do get rid of it's original source, and in this case the "FEB.xlsx!". Just that. Will it be possible for the formula to recognize the new sheet that I just paste it to?, as the new worksheet are structurally the same, just different location and a different filename.

And while I'm at it, along with this formula, there is also some data validation that I set, and I still need it to function the same way, just in a different sheet.

If you need more clarification, I am more than happy to give it to you.


Thanks in advance for your kind help.
Arshad

Update, I could break links for all the formats, but conditional formatting still doesn't work. The only option is to format it again manually.

Anyway I could just copy and paste it?