Posts by VincentNL

Important Notice


Please note that on 14th December 2023 users will experience an expected outage whilst we make upgrades to our network. We anticipate this process may take a couple of hours and so we apologise in advance for any inconvenience.

    Hello, I have a workbook with two sheets Sheet 1- Oldstock 2021-2022 : It contains warehouse information Sheet 2- Transaction we are selling & returning items stated Question 1: About the information we got from the first article We have two processes: the sale (Sale) and the return (retrieval) and the quantity sold or returned After putting the quantity sold, I want to make a confirmation in order to transfer NEWSTOCK to Quantity in stock on the first sheet. Question 2: 2- How to add the current date automatically each time I add a new line I put it now () but how is it written automatically The file is attached. Thank you.

    You got it figured out yet or do you need additional help?

    Do I understand it?

    grab 2 random cells in worksheet competitors column a, optionally with same the same class, optionally with names already in worksheet matches column a


    Paste both cells in worksheet matches, 1 in column B and 1 in I on the same row


    Question:

    1. If names are allowed to be repeated, how many rows do you want?

    Hey Mamun,


    Thanks for adding the workbook, I hope my following changing are helpfull:


    1. Now if the value of the cell is empty nothing will happen, this will stop the error from accuring

    2. I added the style of the range to change to your description

    3. Added the code for automatically running the macro when values change in the range


    As for your next comment "I want that Only when pressing down the CTRL of Keyboard the hyperlink active", I got that working but it kept crashing the excel workbook every 10 seconds, so not sure about it yet



    Put this code in a module:


    Put this code in the sheet:

    Code
    Private Sub Worksheet_Change(ByVal Target As Range)
    If Not Intersect(Target, Range("E9:E100")) Is Nothing Then
    Call hyper
    End If
    End Sub

    Hi there,


    Hope you can clarify

    1. Only no hyperlink should be created when no folder name matches any string right?

    2. That's fixable

    3. You don't want the popup message and change of tool icon?

    4. Can you attach a worksheet in what the code gives an error?


    Hi there, I hope this is what you mean?



    Let me know if it worked :)

    exactly

    I can't think of anything else than this pretty cheap solution: