Search:

Type: Posts; User: JorgenKjer; Keyword(s):

Page 1 of 3 1 2 3

Search: Search took 0.01 seconds.

  1. Re: Insert row, run macro from Drop down List and copy row above.

    Hello Onlyadrafter

    Thanks for the help, the code works perfectly.

    Greeting
    Jorgen
  2. Replies
    3
    Views
    57

    Re: Create hyperlinks to files in folder

    Hello MUKESHY12390

    I have tried formulas, but I have a VBA code which sort the employees out into different sheets by departments and I have not succeeded in getting the formula copied so that the...
  3. Replies
    3
    Views
    57

    Create hyperlinks to files in folder

    Hi

    Can anyone help with a VBA code that makes a Hyperlink to cells?

    This Workbook is a staff list where in column "E" it is possible to use a Hyperlink next to each person to see a photo

    The...
  4. Replies
    7
    Views
    152

    Re: Copy specific cells at random rows

    Hi Fluff
    You are right
    Once again,you have come to my rescue
    Thank you
    Greeting Jorgen
  5. Replies
    7
    Views
    152

    Re: Copy specific cells at random rows

    Hi Fluff
    I am sure Imust have misunderstood how to use your code. However, I have tried to add somelines to the code and only the first active cell is copied. What am I doingwrong?
    Greeting Jorgen...
  6. Replies
    7
    Views
    152

    Re: Copy specific cells at random rows

    I've tried to create a code that can execute what I need, but I think it must be possibleto make it smarter
    Does anyonehave a suggestion?

    Sub offset_2()

    Range (ActiveCell.offset(0, 0), ...
  7. Replies
    7
    Views
    152

    Re: Copy specific cells at random rows

    https://www.dropbox.com/home/Mr.%20Excel?preview=Copy+specific+cells+at+random+rows.xlsx
  8. Replies
    7
    Views
    152

    Copy specific cells at random rows

    Is there anyone who can help with a code?

    I want to select a random cell in column Aand in that row copy the values ​​in columns A: C and E: G and I: J

    In this example it is row 4 but it...
  9. Insert row, run macro from Drop down List and copy row above.

    Hi

    Are there anyone who can help?

    If I insert a row e.g. between rows 10 and 11 and in the new row I select SUB or RSD from the Drop Down List in column D, the values ​​in the row above the new...
  10. Re: A tuff one, Copy and paste if criteria is partial met

    Hi Fluff
    Thanks for your prompt reply. The code works perfectly
    Regards
    Jorgen
  11. Re: A tuff one, Copy and paste if criteria is partial met

    Hi Joe

    I have tried to make a link to a small example.
    Hope the link works

    Jorgen

    https://www.dropbox.com/s/zr2rgdafqj3o7a2/Copy%20and%20paste%20if%20criteria%20is%20partial%20met.xlsm?dl=0...
  12. A tuff one, Copy and paste if criteria is partial met

    Hi

    Is itpossible to create a code that can copy rows from a data sheet and paste to areport sheet if there is a partial match?

    Data is a staff record with data in 11 columns and about 450...
  13. Replies
    3
    Views
    149

    Re: Adjust text in shapes

    Hi Fluff

    It Works. Thank you very much for your help

    Sincerely Jorgen
  14. Replies
    3
    Views
    149

    Adjust text in shapes

    Hi
    I have a small code that makes a shape with text. Are there anyone who can help change the code so that the three lines are centered horizontal in the shape?
    Best regards Jorgen

    Sub Shapes()...
  15. Replies
    0
    Views
    90

    Copy and paste almost everything

    Hi

    I have a 5-sheet Workbook on Sheet 1 there is a table with a Header from "A6:K6"

    In column D there is text with company departments.

    I want to copy all Rows with all columns from the...
  16. Replies
    5
    Views
    222

    Re: Color every second Row

    Hi Steve

    Thank you for your prompt response
    I forgot to mention that all Rows cover more than column "A"
    However, I have received help with a code that takes this into account
    Thank you very...
  17. Replies
    5
    Views
    222

    Re: Color every second Row

    Hi pbornemeier

    Thank you for your prompt response
    The code works perfectly in my Workbook
    Thank you very much

    Regards
    Jorgen
  18. Replies
    5
    Views
    222

    Color every second Row

    Hi

    Is it possible to create a code that color every second Row with e.g. RGB: 221, 235,247

    Two pages in the Workbook, "Data" and "FrontPage", should not be colored.
    The size ofthe Range on the...
  19. Re: Delete selected Range in selected Sheets

    Hi Joe4

    Thank you

    The code runs perfectly now

    Greeting Jorgen
  20. Delete selected Range in selected Sheets

    Deleteselected Range in selected Sheets


    Cananyone help with a code that deletes a Range starting in "A7" to bedeleted in all Sheets except two in the workbook?
    Rangecan vary in number of Rows....
  21. Re: Copy specific cells from multiple worksheets in VBA

    Hi Vcoolio

    Thanks again for your great help. It works perfectly


    Regards
    Jørgen
  22. Re: Copy specific cells from multiple worksheets in VBA

    HiVcoolio



    It didthe trick, many thanks



    In mycountry we have a saying, if you reach out they take the whole arm. I feel I amdoing it now.
  23. Re: Copy specific cells from multiple worksheets in VBA

    HiVcoolio

    It isabsolutely fantastic. I am very grateful for all your help and patience.


    However,there is a funny thing, on sheet 30_12, part of the check boxing disappearsfrom the filter...
  24. Re: Copy specific cells from multiple worksheets in VBA

    Hi Vcoolio

    I ope i Works this time

    https://www.dropbox.com/s/pssbv4dpheiuxl0/Mr%20Excel.docx?dl=0
    https://www.dropbox.com/s/8hm3y3isbvjp8w1/Udkast%20pmp%20layout_ver.4.xlsm?dl=0
  25. Re: Copy specific cells from multiple worksheets in VBA

    Thanks again for the help, I have some questions in a Word document as well as an updated workbook that can be downloaded from this link.


    Many greetings
    Jorgen Kjer
    ...
Results 1 to 25 of 51
Page 1 of 3 1 2 3