B5rocksass
Board Regular
 Joined
 Jan 10, 2017
 Messages
 50
 Office Version

 2016
 Platform

 Windows
Hello everyone, Is it possible to copy concatenated fields and have them treated as a formula in that pasted field? I have 4 columns of the same formula in which each of the 30+ rows reference a different tab in the workbook. Instead of entering each cell and replacing various parts of formula, I've created the correct formula using concatenate. Now all i have to do is put an equal sign before it. But i was hoping this could be pasted as a formula. Please help!
Here is a portion of the data I'm working with...
Here is a portion of the data I'm working with...
LUM Confirmations Time Frame Averages  2021.01.xlsx  

A  B  C  D  E  F  G  H  I  J  
1  Formula Fragments  
2  Tab  Form1  Form2  Form3  Form4  Form5  Form6  Form7  Form8  Concatenated Formula  
3  1'  COUNTIFS('  !$F:$F,  $B$2  ,'  !$G:$G,"N",'  !$C:$C,"<="&WORKDAY(  $A3  ,3))  COUNTIFS('1'!$F:$F,$B$2,'1'!$G:$G,"N",'1'!$C:$C,"<="&WORKDAY($A3,3))  
4  2'  COUNTIFS('  !$F:$F,  $B$2  ,'  !$G:$G,"N",'  !$C:$C,"<="&WORKDAY(  $A4  ,3))  COUNTIFS('2'!$F:$F,$B$2,'2'!$G:$G,"N",'2'!$C:$C,"<="&WORKDAY($A4,3))  
5  3'  COUNTIFS('  !$F:$F,  $B$2  ,'  !$G:$G,"N",'  !$C:$C,"<="&WORKDAY(  $A5  ,3))  COUNTIFS('3'!$F:$F,$B$2,'3'!$G:$G,"N",'3'!$C:$C,"<="&WORKDAY($A5,3))  
6  4'  COUNTIFS('  !$F:$F,  $B$2  ,'  !$G:$G,"N",'  !$C:$C,"<="&WORKDAY(  $A6  ,3))  COUNTIFS('4'!$F:$F,$B$2,'4'!$G:$G,"N",'4'!$C:$C,"<="&WORKDAY($A6,3))  
7  5'  COUNTIFS('  !$F:$F,  $B$2  ,'  !$G:$G,"N",'  !$C:$C,"<="&WORKDAY(  $A7  ,3))  COUNTIFS('5'!$F:$F,$B$2,'5'!$G:$G,"N",'5'!$C:$C,"<="&WORKDAY($A7,3))  
Sheet1 
Cell Formulas  

Range  Formula  
J3:J7  J3  =CONCATENATE(B3,A3,C3,D3,E3,A3,F3,A3,G3,H3,I3) 