workrng

Hello everybody, I currently have the following: Where column: I = quantity J = subtract any number entered from the quantity after which the number entered will be subtracted in column I and disappear in column J so you can enter a new one in the future J = add any number entered from the...

Hi, I am not sure if i am close but i am attempting to hide a range of rows based on the value of another cell. To be more clear A11 value is "Status" and i need to evaluate B11 and if it is "Open" then hide 11 rows up. This repeats in a dynamically lengthed document that i run weekly...

Hi, I had a code which auto update time & date on Col E and last modified userid on col F. Possible to rec which is the last modified cell? <tbody> A B C D E F abc def ghi jkl 8/9/2019 5:03:51 PM C:\Users\TOM , update Cell A, B, C,D </tbody> Private Sub...

Hi All, Need some help - I have the below code to copy a range of cells to a text file; however, when it copies and creates the file the text file shows only #REF in each selection. I need this to copy the values of the formulas in the cells. Each cell has a VLOOKUP formula and data...

Hello and thank you in advance if you can help, I am using excel 2019 64 bit on a PC. I have a VBA macro that I have used to create hyperlinks in the past. It has always worked fine, and it "sort of" is working now, but it is not keeping the absolute hyperlink I need, so it will not open the...

Hi all! I need your help and expertise once again. The macro in this worksheet links cell B2 to the footer. So when you type into cell B2, it updates the Footer (and places whatever text you just typed into cell B2 into the left Footer location). Problem is, when I type into B2 and press...

Hi everyone! I found a code on google that automatically generate date and time when a cell changes. It is working, but I want the date and time to be recorded next to the cell with the old date and time and so on whenever the cell changes. Can somebody give me a hand on this? Thanks in...

Hi guys, Hope someone can help me out here. I have a spreadsheet which has conditional formats on it (A9:N9 and down rows below to A700:N700) where depending on what item is entered highlights that certain cells. After awhile the items need to be removed from the spreadsheet, but the formats...

Hi, I have some code that I modified from another thread. The code is to sort sheets based on a specific cell number on the sheet. My sheets are called "QM03-P1-R1" where the P and R number can be modified. The sheets are continually being created but not in a specific number. When I run...

The following code auto numbers a selected range that has merged cells. An input dialog pops that asks for to select/provide the range to auto number with the option to click "OK" or "Cancel", when I click "Cancel" it puts a "1" in a pre-selected cell. I would like to modify the code so that...

Would like to make a VBA private sub that runs a column of data on change and combines in another column the time from the cell + current DAY + AM/PM (value from a matching cell in another column) If it makes it easier it can also pull date from a third column. code below is what I started...

Hi Friends, I need a little help in my code which is working in different logic. If I explain my scenario, I have an excel with two worksheets Sheet1(Form), Sheet2(Collation). I have a data in Sheet1 and kept a drop down list in column B (B2:B250) with Yes/No option. In column A there is a...

Hi Folks, I have a vba code which is working fine in my one of the file. In this file, I have applied a rule that whenever in column A and column U data will be entered, current date and time will be captured in another two columns. However there are validation applied in that file from where...

Hello the below code I hope you can help, I have the 2 codes below that need to run simultaneously, but at moment they don't, this is to work on a cell value change, the last code only works if you press play. hope you can help please. thex2 codes below are placed in sheet 8 (SMART Locate)...

Hi all, good morning, I have the code below but the workrng intersect doesn't work it comes up with a yellow background can you help please. this is the line with the error Set WorkRng = Intersect(Application.ActiveSheet.Range("I:I"), Target) Below is the full code Private Sub...

Hi Guys, I have a timeclock dump of data where column "A" = a person's name and column "B" is their clock in / clock out times. I want to add a blank line between each group of names. Searching google, I found this bt of code... Dim Rng As Range Dim WorkRng As Range On Error Resume Next...

Hi All, I'm trying to manipulate the following script. When I paste new data over a range on sheet 1 I would like the old data range copied and pasted into sheet 2.. id like this as a cycle.. every time I paste new data over the data in sheet 1 the old data overwrites the older data in sheet2...

Hello Gurus, I am currently working on adding a date/time stamp when things are entered into a column. So for example, if I enter something in column O, I would like the date/time stamp in column P. This following code seems to work most of the time, but once in a while, it stops working and...

I am working on an Excel worksheet based on a MS Project file, and I am trying to write a macro that can group my rows by the WBS number in column A. I am trying to do this by using the formula below. Here is my attempt so far. While the input box does appear, nothing is grouped. Any help would...

I am trying to write a macro to group my project schedule in Excel based on the number of periods in the WBS column. This is not working, but I feel as though I am close. Sub Group_1() Dim cell As Range Dim WorkRng As Range Rows.ClearOutline On Error Resume Next xTitleId = "Grouping" Set...