edits

  1. F

    Table edits not included in query refresh

    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...
  2. R

    Tracking and logging changes to values within one column.

    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...
  3. M

    VBA add current date and username when edits are made

    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...
  4. B

    Macro clarification

    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...

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top