ReBizRU

How to Create a Petty Cash Log in Excel (Invoice-Compliant Template Guide)

Many companies and sole proprietorships use petty cash to keep track of personal and company finances. However, it is very time-consuming and error-prone to keep balances and to post the information in the cash book to the accounting system...

2024.05.30

Let's Make SeriesLet's make a petty cash book.

PrintOut" printer and automatic printing Excel(Excel) macro(VBA)

Have you ever had the experience of printing the same Excel file every time, only to have to set it up again and again? Have you ever had such an experience? Many people spend a lot of time on Excel printing. Especially in an environment where multiple printers are used, it is a big hassle to change print settings...

2025.06.18

Excel Macro (VBA)

How to use the variable type "Workbook" Excel(Excel) Macro(VBA)

For other variable types, please refer to Excel (Excel) Macro (VBA) about variable types. First, we will explain the basic usage of the variable type "Workbook".

2024.06.14

Excel Macro (VBA)

How to apply mosaic (blur) Excel

When you are preparing a document or manual for external publication, you may need to refer to a web site or a screen where non-public information is visible. In such a case, you would like to put a mosaic like this on the non-public part. We will explain this method in detail in this issue...

2024.07.05

Excel Functions

Excel (Excel) to automatically create a backup file every time you save

Here is how to automatically create a backup file every time you save Excel. Display the General Options screen First, display the "Save As" screen. On the Excel screen, click the "File" tab, then click "Save As," then click "So...

2024.01.10

Excel Functions

How to use the sheet protection function.

After you have created a great system or tool in Excel, do you ever have this fear when you want others to use it? What if someone accidentally breaks a formula... What if an important function is deleted? I only want to edit the cells I need, but...

2024.10.08

Excel Functions

How to use the input screen "InputBox" Excel Macro (VBA)

If you want to use values or arbitrary characters that do not exist in Excel, the "InputBox" is useful to easily create an input screen during macro execution. In this article, we will briefly explain how to use this "InputBox".

2025.02.21

Excel Macro (VBA)

Find Out Which Version of Excel You’re Using – Quick Steps

The functions and functions that can be used may change depending on the version of Excel. You should be able to check if your version is supported when errors or problems occur, so we will show you how to check your Excel version in this issue. Acau...

2024.06.05

Excel Functions

How to Disable Automatic Calculation in Excel VBA to Speed Up Your Macros

Learn how to disable automatic calculation in Excel VBA to dramatically speed up your macros. Simple code examples and performance tips included. Boost your Excel automation today!

2025.07.28

Excel Macro (VBA)

How to extract characters before a specific character "LEFT and FIND functions in Excel"

As shown in the figure below, if there is extra data after the string and you want to extract only the string to the left of the extra data, you cannot simply use the LEFT function alone because the number of characters is not constant. Function to extract the left side of the "¥" mark in cell "A2" = LEFT(A2,FIND(...))

2025.02.19

Excel Functions