changed

I've just started this job, and I know this can be done easier than it is right now. Currently, it takes days to manually locate changed data in a newly submitted file (WB2) and update the master spreadsheet (WB1). I've used the Compare worksheet function in Excel 2016 which has provided me...

I have a cell in a worksheet which is linked to a cell in another workbook. In theory the link should update when I open the first workshheet, however the linking formula has changed itself to c:\Users\Michael\AppData\Roaming|Microsoft\Excel\file name and cell reference. It is supposed to link...

Folks, I have inherited a report which is causing me some grief. Originally, in .xlsm format it comes in at a hefty 300mb but its only 38000kb in .xlsb. So its not a large file. there are a handful of simple pivots stemming from source data held in dynamic named ranges, and a few navigational...

I have exported a list of suppliers name as aliases name in MS excel 97-2003. Actually the service provider from where i am expoting the file allows to export only in excel format 97-2003. However, after opening the excel file it is found that few aliases name such as june12 has changed to...

Hello, I am trying to find a way for an automatic date stamp to be populated into a field (Col J) in a row when any other cell contained within the same row is changed or modified. I know this is easy just haven't figured it out

Hi I inserted UserForm and some other Form Controls such as textboxes/labels etc. I changed the name of each control for example TextBox1 to Mybox, Label1 to Mylabel etc. I also changed the name of the UserForm from UserForm1 to MyUserForm. Now, when I go to coding window, I see on the left...

I am trying to create a shopping list with several columns, a column for product name, a column with checkboxes to indicate if item is to be fresh and another if item is frozen, etc. I used the sub routine below to create the checkboxes in the "fresh" column which seems to works as designed...

On a Form, there is a Combo Box Field which lists different Statuses (e.g. Open, Pending, Closed). Is it possible for the following to happen? When 'Status' is changed from 'Open', add the sentence to the end of the text field 'Comments' to be something like this: "05/05/19 - Closed - J.Smith"...

Excel 365 I have dates and time (text format) European style that I need to setup like American formatting as a date. 23.05.2012 14:11:56 changed to 05/23/2012 14:11:56 24.08.2011 17:24:39 changed to 08/24/2011 17:24:39 06.04.2012 12:18:58 changed to 04/06/2012 12:18:58 06.04.2012 11:59:27...

I need some help with conditional formatting. I have three columns (C2:E31) with data in them. Column B also has data in it. When the value in column B is changed and the values of Columns C, D and E do not match what B is changed to, I want C, D and E to change color. Can someone please assist...

I want to pre-populate a work sheet with numbers and then if the number is changed it will change the color of the text or the cell to let me know it has changed

Hi all, i found a macro online which is really useful for me but unfortunately i am useless at Excel. can anyone help me modify it slightly? In the code below an input box pops up for me to choose the columnn but can this be changed so it always just looks at colum A:A? i would still like to...

I'm looking to move rows to another sheet when a value in "H" is changed to "closed"

Hi, I'd like a code that would refresh a PivotTable only when a new tab is selected/activated. Not when values on a tab are changed but only when the user moves/selects a different tab. Thanks! Jesse

Hello all, I'm not terribly experienced in macros, but I'm learning as I go. Any help is appreciated. I have a workbook with many worksheets inside it. From a master worksheet, I'd like my staff to be able to select which worksheets to print by selecting them with checkboxes. I have a macro...

Private Sub TextBox1_KeyPress(ByVal KeyAscii As MSForms.ReturnInteger) With TextBox1 If InStr(.Text, ".") > 0 Then If Len(Split(.Text, ".")(1)) = 2 Then KeyAscii = 0 End If Select Case KeyAscii Case Asc("0") To Asc("9") Case...

I've been using a spreadsheet I created 5 years ago, which has grown and evolved the entire time. I use long and complicated formulas, many of which make heavy use of arrays, using INDEX and MATCH. I had to look at one of my formulas today, and noticed that NONE of my formulas are as they were...

I have a file Sum.xlsx with link form soure =D:\OneDrive\OneDrive - FTT\2019\Stock\[Summarize.xlsx]TAA'!M5 I saved this Sum.xlsx and then I open this file and file link changed to ='https://ftt-my.sharepoint.com/personal/user/Documents/2019/Stock/[Summarize.xlsx]TAA'!M5 I used onedrive for...

Hi, I'm new to VBA. I wrote a code to send an email if there is a cell value change in column F, and the code works great. But I want to make sure the workbook is saved prior to sending out the email. The email text body must include the reference cell value, which is the value from column A of...

Hi, I have a list of values that I need converted. They look like this: <tbody> 14.75K 29K 44.5K 26.5K 28.5K 1.5K 22K </tbody> and I am trying to get them changed to <tbody> 14750 29000 44500 26500 28500 1500 22000 </tbody> Any and all help Appreciated! Thanks, Todd