Showing related tags and posts accross the entire site.
-
When I test formulas on a spreadsheet, it s a very manual process. I'm trying to figure out a way to automate this. Here's what I have so far.
I want to identify some input cells and output cells. Then record some known good values for the inputs and outputs and store them. [...]
-
When rolling your own csv files, you have to account for commas in the text. Extra commas will create extra columns and you don't want that. Let's start with this data: Two of the names have commas and two don't. By ignoring those commas, extra columns are created because a comma delimits...
-
I have to save a file that may have the same name as an existing file. If it does, I append a number to the end of it to make it unique. The problem is that the file will live in three different folders in its life; Working, Review, and Archive. I [...]
-
Opening a new workbook should in no way interfere with editing a different workbook which is already open. Saving a workbook should in no way interfere with editing a different workbook which is already open. With large workbooks, opening and saving means that instance of Excel running is completely...