amended

Hi all I would like to be able to create an audit trail within Excel to record, for a single worksheet (lets call it SOURCE: - cells that have been amended - who amended it (we all log in, so I assume an Active Directory user name field could be used?) - date/time amended - what was done in the...

I have the following formula:- =INDIRECT("'"&TEXT($P$1,"d mmmm yyyy")&"'!"&"A4") How can this be amended so that the A4 part will adjust (so A5, A6, A7) etc when dragged down?

Dear ALL, Hope you are doing good, I have a dump of data (invoice number's) and multiple data in excel. If there are 10 employee's but each can process different number's of invoice's. Here is what I want to do. If a person is handling the invoice while taking the invoice he should enter his...

I have searched a lot for an answer to this and am beginning to think there isn't one... I would like to create a list of all the currently assigned shortcut keys, I don't just mean those assigned to macros but the ones delivered with Excel and that may or may not have been amended. I think...

Hi, I want to create a VBA Macro to show me when there is a change in any cell in a certain range. I found the below and amended to suit my sheet , but it does the trick , but it only works for 1 column not a range of columns .. as you can see the offset is -3 .. and it shows date and time 3...

I've recently switched from excel 2010 to 2016 but whenever I amend code on the fly it sees to reset the project even if I'm only amended commented code. Is there some setting I've overlooked as I'm sure it didn't do that with 2010. Thanks

Hi, Can someone help with a formula - If an amended price is present it will calculate product weight value with new price, if not it will use current pricing. Thanks for your help. <tbody> New Pricing Current Pricing Amended Code Amended Price Product Weight Actual Code Price/kg Actual...

I have the following code to coy data after sheet1 n the current workbook I would like it amended to extract the name of the current workbook i.e "BR1 Sales.xlsm" nb.Sheets(1).Copy After:=Workbooks("BR1 Sales.xlsm").Sheets(1)