Windows 10 My column C which I hid last week now won't unhide. I've tried right-clicking unhide, select all unhide, visibility, reformatting all the...
Diamond Contributor to PhilipP1055 Jul 12, 2024 PhilipP1055 Please check How to use Advanced Filter in Excel - criteria range examples with formulas (ablebits.com) Filter by using advanced criteria - Microsoft Support Like 0 Rudrabhadra
1. Use Word's Mail Merge feature to create emails. 2. If you need to add attachments, you can add them manually, email by email, or use a third-party tool (such as Mail Merge Toolkit or AbleBits Mail Merge) to add attachments automatically. 3. Ensure that the data source contains a field for the path or filename of the attachment so that it can be referenced during the merge. 4. if the mail ...
Hi All,Is there a way, without using VBA, where I can click on a cell, which opens another worksheet. The answer to that complex calculation on that new or...
In my new laptop, using the same excel and the same template, the funtion TEXTO(A6,"ddd dd mmm") returns the name of the day in english ("Sunday", etc) and I...
I'm looking to simply run a macro that finds a picture's location in one cell and then insert the picture into another cell. But it has to be attached to a...
pascalemarquis A macro is a procedure (Sub) without arguments in a standard module. A function is not a macro, so it will not be listed under macros. You can use the function in cell formulas. The Ablebits page gives some examples. And you can use that in data validation. I'll take their SKU example. Let's say you want to enter SKUs in A2:A12. Select B2. Enter the formula =OR (A2 ...
You cannot count colors assigned by conditional formatting, as these cells are effectively still the default background color! Why not just count these cells based on the conditions you used for conditional formatting? Example: Set in a worksheet with conditional formatting so that the cell background turns green when the cell contains the value 2. COUNTIF counts all cells that contain the ...
I am having trouble using the find and replace tool. I am trying to select all values greater than 0 and replace them all with 1 to create a binary in a...
Juliano-Petrukio Thank you for your reply but that unfortunately is overkill as it breaks all links. I need to selectively find the Active Control [Charts] link, review that its not critical, then break it if I deem it to be useless. I have whole bunch of other links [Data > Edit Links] in the file that are valid and must remain intact.
