Search results

Narayan, It's perfect! Thank you so much. My problem was that I failed to change the column range in the WorksheetChange and Worksheet_SelectionChange modules. I've been getting by with work-arounds to VBA in Excel for years. It's probably time I learn it. I'm grateful. Anything I can do...

Narayan, Wow! Thanks. I understand your code, and it appears that it should work perfectly. The call outs that appear in the workbook you returned are correct and are exactly what I want. However ... it seems that I can't get the code to run. If I make any changes to the values in the...

Narayan, Thank you so much. VBA would be great, but I'm not very good with it. If its a routine that you could write without much time or trouble, I'd be forever grateful, but if its asking too much, I understand. I was hoping that I could be shown some Excel function that would do the...

I have a table which requires that several cells' values need to be manually updated. This causes a cascade of calculations to be triggered and results are displayed. As each of the manually-updated cell values are entered, I would like to display (by any means) the difference between the old...

I have an inventory-type spreadsheet that inserts TODAY() in the date column whenever a new item is entered in a different column, "Item", which is handy. The problem is that every time the worksheet is opened, every cell in the "Date" column that has a corresponding "Item" get updated to...

Perfect. Thanks so much.

I am making an invoice sheet which will include historical as well as current purchases. I auto-populate the date field with the current date when a new item is entered with =IF(F3<>"",TODAY(),""), where cell F3 is a cell for a new item name. My problem is that when I open the sheet...

I've added comments to graphs with arrows pointing to a specific data point, as for example, a point in time when some factor changed. It may offer an explanation of why the slope of a line changed. However, as additional data is added over time, the arrow is not linked to the data point, but...

I don't know how to apply conditional formating to a cell, based on the value of another cell or on the basis of a formula which depends on the value of another cell. Probably easy, but I need some help. Thanks.