edits

I've appended two Excel tables (A and B) using Power Query. So far so good. Table A is a connection only to another Excel file. Table B is in another sheet of the workbook where my query results get loaded. Table B has to be manually updated on occasion - it's a list of exceptions to append to...

I have a piece of code (Which I got from this site) that tracks changes to cells within the worksheet. It works great except I'd like it to look a changes just within one column only, not the whole sheet. Anyone know of a way? Option Explicit Const intUsernameColumn = 1 Const intCellRefColumn...

Hi, I found the below code to add the current date to an adjacent column when an edit is made. Note that this code is meant to apply to the worksheet, which might complicate my bonus question. I'd like to modify it to do the following: 1. Add the date to Column L of the edit row regardless of...

Hi guys just wondering if someone can confirm something for me. I've got a workbook which requires users to edit data and once they've finished their edits they click a command button which runs a macro. In the macro I have ' ActiveWorkbook.SendMail' would this send a copy of the workbook with...