Log in  \/ 
x
or
x
x
Register  \/ 
x

or

sticky What we lack or need to improve. Our ideas.

More
2 years 3 weeks ago #628 by svetievboris@gmail.com
Replied by svetievboris@gmail.com on topic What we lack or need to improve. Our ideas.
Hi everyone,

Thank you for a great set of tools. I have a suggestion for improvement which I need in my workflow.

When using the split data function the new workbook (and worksheets) that is generated does not seem to keep page headers and footers and information about row height and column width. It also changes the font to Arial 10 thus not preserving the font from the original worksheet.

Having this option would save me a lot of time in which I have to customize all of the above settings for each new worksheet that is generated with this function and I would like to be able to set it up in my original master sheet and have all of those settings copied down to every data split that I perform.

Let me know if this function is already available. I am using Kutools 16.0

Sincerely,
Boris

Please Log in or Create an account to join the conversation.

More
2 years 3 weeks ago #623 by qiuhongkun
Replied by qiuhongkun on topic What we lack or need to improve. Our ideas.
Hello,
thanks for your suggestion. :)

Please Log in or Create an account to join the conversation.

More
2 years 1 month ago #602 by mreed1972@gmail.com
Replied by mreed1972@gmail.com on topic What we lack or need to improve. Our ideas.
Enterprise Tab > Combine Worksheets
When using this feature (which works fantastic) It would be nice if it would remember the folder that you last selected. I recently had to combine hundreds of workbooks and each group that I had to combine had to be saved into a single folder, but during each combine, I had to navigate to the folder. It would have been nice to have to navigate to the save folder once and then each time after, it was saved.


Thanks for all your hard work
Scott

Please Log in or Create an account to join the conversation.

More
2 years 1 month ago #599 by qiuhongkun
Replied by qiuhongkun on topic What we lack or need to improve. Our ideas.
Thanks, we will consider to enhance it.

Please Log in or Create an account to join the conversation.

More
2 years 1 month ago #578 by sz@fullhandfunding.com
Replied by sz@fullhandfunding.com on topic What we lack or need to improve. Our ideas.
Hi Jay, Im reposting this here as it did not seem to get any attention in the original post:

Are you able to update the "Error condition Wizard" to use Excel's IfError() Formula?

It is much neater, as you do not need to repeat the formula twice, only once:

Syntax
=IFERROR (Formula, value_if_error)
ExcelJet Link: How to use the Excel IFERROR function | Exceljet

This is only for when trying to capture all error values but makes for far neater and faster processing of complex formulas.

Thank you!

Please Log in or Create an account to join the conversation.

More
2 years 2 months ago #537 by qiuhongkun
Replied by qiuhongkun on topic What we lack or need to improve. Our ideas.
Thanks for your suggestion.

Please Log in or Create an account to join the conversation.

Moderators: jaychivoExcelfansqiuhongkun