changed

Hi, I am currently working on a template to be shared among several people within the organization. It is suppose to be stored in a sharepoint using the web. The idea was to generate a backlog where you could see all changes that people have been doing. The purpose for tracking the changes is...

Hey, I am simply trying to copy value from cell B2 and paste it into cell B3 but am unable to do so. could someone please guide me as the what needs to be changed in the following vba script? Range(B2).Value = Range(B3).Value Thanks. will appreciate any help.

Hi, Am getting an error on my Case Select statement. The error message is - "Case without Select Case". And I could not figure out where the error was this Case Select which has about 7 different possible "Cases" and so I removed each Case one by one to see which one was causing the error...

Good Day, I have a data table like below starts from A2 to C19 Is it possible to ruffle those datas randomly by clicking a command button? Every column will remain with same datas ony their rows will be changed... Thank you... <colgroup><col span="3"></colgroup><tbody> NAME1 1 1 NAME2 1 2...

I have added a new drive to my computer and I want to change the default location of the pictures. I have changed it in word but can't work it out in excel. Can you help ?

I think I know the answer to this question but it's been sometime so I thought I would see if things changed. Is there any way to enlarge the GO TO box when using trace dependents. Some of the sheets names are longer than the box so I can see them and was wondering if enlarging the box has...

Dear Sir I just need a way out that option button caption / name should be pick from cell values; Like option button 1 should be linked with Cell A1 accordingly Option Button 7 linked with Cell A7 When we changed values in cell, option button caption may also be changed. Regards

Hi All, I have a worksheet that when a cell in column F is changed I want to email out a message to a particular person. I.E. if the cell in F is changed to Production I want to email Chris Smith with a message letting him know that he has a new Non Conformance that needs actioning. If the cell...

Hi All, I hope someone can help. I have a workbook with 12 worksheets in it. I have a worksheet called 'Master LOG-Owner Geoff Clarkson'. When a cell in column F is changed on this worksheet I need a macro to automatically run. Thanks in advance.

Don't seem to be able to copy & paste into a message using Internet Explorer 11.0.95 Have changed compatibility settings but still no joy. Has anyone got suggestions as to why?

Hi, Have a data set with 6 columns and roughly 10000K rows. My columns are: Date/Initials/Commidity/Weight/Container Weight/Net Weight. I use this data to track how much recycling material is processed with 4 different types of commidities. However, while this is used for every entry, once my...

I have an odd issue where the underlying VBA in my "WorkSheet" Code does not retain the value of a "Copy" after pasting to a cell. Subsequently - I am unable to utilize the qat "UNDO" shared control as the copy value always reverts to Application.CutCopyMode = False immediately after pasting -...

Hi All, I have had a read through other posts can cant find exactly what i am after, i can find script for each individual part but when i try and put them together i can can only get one half to work. I would like to monitor target cells in another sheet and record the value that was in the...

Hello everyone!! My question is this, how can I sort largest to smallest column B with a formula that have references that I don't want changed and column A to follow the results of column B? I'll try to show example below. TIA A B 1 =COUNTIF(G2:G2189,1) 2...

Hi i have used your code below, but i want to add time to the date in Row Q can you help me please? Private Sub Worksheet_Change(ByVal Target As Range) Dim Changed As Range, Rw As Range Set Changed = Intersect(Target, Union(Range("H:H"), Range("H:H"))) If Not Changed Is Nothing Then...

Hi All I need a time stamp(NOW()) in P:3 (d/m/yy h:mm AM/PM) if there is any change in B3:L3 I need to run this formula down the whole work sheet for this columns The formula I attempted to use, =COUNTIF(B3:K3,"DONE") then =IF(O3>0,NOW(),"") ALL the dates in P change to current date and time if...

Can someone show me how I can add a value to the same row in column H but only if the cell in column E is changed from a blank to a value?

Good evening. I have a challenging problem I was hoping to get help with. I have reviewed other posts and found a solution that allows for clearing a range of cells based on a change, but can't find a way to clear different ranges based on different cells changing. I have dependent drop-downs...

Hi, the code below (that Peter posted) so that we can use a "multi-filter" on our spreadsheets has been BRILLIANTLY helpful. In short, it filters all of the data on a given spreadsheet for whatever search strings are placed in Row 1. So at the moment we could filter Column A for "red", Column B...

I am trying to save an invoice file as the invoice number (H9) and the customer name (H2). I found this in a different post on here: Sub SaveInvoiceWithNewName() Dim NewFN As Variant ' Copy Invoice to a New Workbook ActiveSheet.Copy NewFN = "C:\aaa\Inv" & Range("E5").Value &...