growthRate #
Calculate the growth rate.
achievementRate #
Calculate the achievement rate.
CAGR #
Calculate the CAGR.
WordFill #
If there is a value in the right side of the selected reference column, fill the cell value in a DB format.
allDecimals #
In the case of numbers with decimal points, all decimal points come out.
shownamelist #
Call the currently defined name list box.
→ double click : activate name area
upsidedown #
Return the data of the selected column and return it to the right side.
inputRandomValue #
Enter the sequential date or random integer.
sepText #
In the text that is mixed with characters+numbers, only the number is returned to the right side.
tableToArray #
Copy the clipboard to set the table as a name definition.
pivotRefresh #
Automatically update the Pivot Table.
SheetVisibilityControl #
sheetVisibleOrNot #
Display visibility property table for all sheets in the current workbook.
→ recommended to work on a new sheet
controlVisibility #
Apply value for the changed visibility property.
sheetNow #
Simply check with the message box to see if there is a hidden sheet in the current sheet.
dietFileSize #
Excel file size diet. check all sheet and clear.
LaunchTextSplitter #
split text from pdf table.