workrng

  1. D

    VBA one cell returns date of last time another cell was edited

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

    VBA code to hide a range of cells based on cell value

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

    MARCO VBA: Auto rec which cell is last modified (Code only rec time/date/userid)

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

    Cell Range export to Text File

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

    Hyperlink Problem

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

    VBA issue of Excel bug?

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

    Recording Date/Time from 1 column to another whenever a cell changes

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

    Conditional formats getting messed up when del/clearing cells?!

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

    Sort sheets by cell value

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

    Modify VBA Code To Do Nothing When Clicking Cancel

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

    Combine Time from Column Range + Todays Date using VBA on Worksheet Change

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

    Run a Macro when select an option in dropdown

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

    VBA help to update date & time in a cell based on another cell value

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

    x2 codes to run simultaneously help

    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)...
  15. P

    Intersect error

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

    Add blank line after cell value has changed

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

    Copy & Paste VBA

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

    VBA Date and Time Stamp Issue

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

    Trouble with VBA

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

    Grouping Excel Worksheet Based on WBS Column

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

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