MacroToolkit - excel - scripts (2)

growthRate #

growthRate
Calculate the growth rate.

achievementRate #

achievementRate
Calculate the achievement rate.

CAGR #

CAGR
Calculate the CAGR.

WordFill #

WordFill
If there is a value in the right side of the selected reference column, fill the cell value in a DB format.

allDecimals #

allDecimals
In the case of numbers with decimal points, all decimal points come out.

shownamelist #

shownamelist
Call the currently defined name list box. → double click : activate name area

upsidedown #

upsidedown
Return the data of the selected column and return it to the right side.

inputRandomValue #

inputRandomValue
Enter the sequential date or random integer.

sepText #

sepText
In the text that is mixed with characters+numbers, only the number is returned to the right side.

tableToArray #

tableToArray
Copy the clipboard to set the table as a name definition.

pivotRefresh #

pivotRefresh
Automatically update the Pivot Table.

SheetVisibilityControl #

sheetVisibleOrNot #

sheetVisibleOrNot
Display visibility property table for all sheets in the current workbook.
→ recommended to work on a new sheet

controlVisibility #

controlVisibility
Apply value for the changed visibility property.

sheetNow #

sheetNow
Simply check with the message box to see if there is a hidden sheet in the current sheet.

dietFileSize #

dietFileSize
Excel file size diet. check all sheet and clear.

LaunchTextSplitter #

split text from pdf table.