ı want to print PDF files with certain ordering. And, ı watched your video. The videos were great. However, ı couldn't your files. How can I find your files ? Please help me.

Thank you.

You need to select you text box, type = into the Formula bar, and pick the cell or formula you want to link to your text box.

I learned it from this guide on how to create, edit, and remove a text box in Excel: https://spreadsheetsuperstar.com/basics/how-to-add-edit-and-remove-a-text-box-in-excel/

Hope this helps someone!

Use the shortcut Alt + N + X

1. The standard Text Box tool (Insert>Text>Text Box)

2. You can do the same thing using the shortcut (Alt + N + X)

3. ActiveX Controls method (Developer>Controls>Insert>Text Box)

Also, there's the VBA method, but you can learn it here - it's too long to write: https://spreadsheetsuperstar.com/basics/how-to-add-edit-and-remove-a-text-box-in-excel/

Hope this helps someone!

So, how do you build a text box in Excel?

Problem-

Generate dynamic date every month using blank query (M).

e.g. like today/now function display present date in the same way display 09-08-2020 and dynamically next month it will display 09-09-2020 ..As you can see day will be same for everymonth but it will be dynamic month wise.

Thanks

Hi,

Thank you so much for your help, this "NOT" formula which you teach will definitely help me in time saving.

Once again thank you so much Faraz.

Kind regards,

Sumana