Copy formulas from multiple workbooks All in One workbook? Without cell reference carry over

[FGaxha]

Hi members,

I have 4 workbooks and each workbook has tab1 with data from A2 to V48 ,and some formula’s from cell K2 to V48.
I want to copy and paste all workbook in ons to consolidated as one but i want to copy formulas without cell reference from the other 4 workbooks.
Format is the same A2 to v48?
Thanks

 

[GlennUK]

Your description is not clear, and I can't make head or tail of it. Are you asking about how to copy formulas and paste as values? To do that, copy the range, and when you are at the place you want to paste, then do Right-click and choose Paste Options of Paste Values.

 

[FGaxha]

Well,
Each workbook has forms K2 to V48.
When i merged/ condolidate all 4workbooks in one, th hose formulas don’t wo te k except the first one K2 to V48.
So i need to copy same logic from each workbook in th consolidated file.

 

[GlennUK]

First you said : "... copy formulas without cell reference ..." - which is incomprehensible, and now you say that formulas don't work (in what way, exactly?) .. except for first one (meaning what?) ... so, am still confused. And, judging by the lack of anyone contributing here, I'm guessing everyone else is just as confused. How about describing exactly what you doing, and why, and how, and what is going wrong?

 

[FGaxha]

Sorry,
Workbooks, 1.2.3.4 are bringing values to sheet 1 from sheet 2 within range K2 to V48.
I want to combine all information in workbook 1,2,3,4 to new workbook called BP24 but j want to bring the formulas to the new workbook without cell reference.
Note: when are combined, workbook 2,3,4 will have different cell ranges, they will be one on top of the other.
Hope it will make sense now.
Sorry again

 

[GlennUK]

Can you explain what "bring the formulas to the new workbook without cell reference" means?