Rude Awakening
New Member
- Joined
- Jul 10, 2014
- Messages
- 36
- Office Version
- 365
Hey Guys
I have a workbook with 20+ sheets. All data on the sheets is pulled from a master sheet using the below formula
=XLOOKUP(Table25192224253134636668697231676869161[@['#]]&"|"&$B$1,Table251922242531346364[Count]&"|"&Table251922242531346364[Country],Table251922242531346364[CSI Group],"",0)
I need to remove all formulas but keep values on all sheets.
I've used the below macro based on this thread , but this returns #n/a for all XLOOKUP values
Sub Convert2Values()
Dim oSh As Worksheet
For Each oSh in Worksheets
oSh.UsedRange.Value = oSh.UsedRange.Value
Next
End Sub
I have a workbook with 20+ sheets. All data on the sheets is pulled from a master sheet using the below formula
=XLOOKUP(Table25192224253134636668697231676869161[@['#]]&"|"&$B$1,Table251922242531346364[Count]&"|"&Table251922242531346364[Country],Table251922242531346364[CSI Group],"",0)
I need to remove all formulas but keep values on all sheets.
I've used the below macro based on this thread , but this returns #n/a for all XLOOKUP values
Sub Convert2Values()
Dim oSh As Worksheet
For Each oSh in Worksheets
oSh.UsedRange.Value = oSh.UsedRange.Value
Next
End Sub