Hi Dritan This is a custom FUNCTION. Although it uses VBA, I don't consider this to be a macro. It behaves just like an ordinary FUNCTION. Is th...
Hi Wpfreeman I have created a macro that will generate the PDF you required (you are not asking too much ). I have modified the FORM to include ...
Hi Emily Please attach a sample copy of your file. Sunny
Hi Please attach a file with some sample data and the form. Sunny
Hi Millhouse Wrapping text in a single cell will cause the cell to auto expand. See example attached. Sunny
Hi Dritan Try this attachment. How can i extract the second "a", or the other positions? 1st, 2nd 3rd "a" is still an "a" when extracted, so ...
Here is another version that can also change the color of the 1st letter of each word.
Hi Paul Instead of using a text box, you could try using a linked image instead. I am using an Event macro to detect any change in a specific ce...
Hi Without a copy of your form it is very difficult for anyone to help. If you can attach a copy of the form with the issues and your expected s...
Hi David WEEKNUM(A1,2) will give you the week number of a date in a year. There are approximately 52 weeks in a year. The 2 indicate what is the...
Hi Chris I am using a helper column with SUBTOTAL. Please note that I am unable to use the SUBTOTAL for the entire Helper column because if you fil...
Hi Dritan Under the Find And Replace - Find tab, change the Look in option to Values instead of Formulas. You should be able to find them now. ...
See if this helps.
Hi Russ You could consider using a 3rd party utility to merge the files. No need to reinvent the wheel by writing codes. Once you have merged th...
Hi Dritan Another suggestion is to allow user to input the data (excluding the colon) into one cell and then concatenating it in another to include...