Results 1 to 10 of 41

Thread: copy,paste,calculate Cell value based on calculations & comparisonsother cells same row. Decimal places

Threaded View

Previous Post Previous Post   Next Post Next Post
  1. #34
    Senior Member
    Join Date
    Jul 2019
    Posts
    382
    Rep Power
    0

    Put Decimal with certain conditions

    Hi Experts,
    I am looking for a macro that will do the things mentioned below

    Check column H of 1.xls has how many number before decimal (If decimal is not present then check how many numbers it has )
    after knowing this, match column I of 1.xls with Column B of 2.xlsx & if matched then put decimal in column E of 2.xlsx after that many numbers (if decimal is not present) & if decimal is present then remove that decimal & reput the decimal in column E of 2.xlsx according to the numbers

    Plz see the sample file


    Macro will be placed in macro.xlsm
    both file can be located anywhere in the pc so the path should be hardcoded in the macro so that i can change it as per my needs in the future

    Thnx For the Help

    Any Doubts Any Question Plz Ask
    Attached Files Attached Files

Similar Threads

  1. Replies: 26
    Last Post: 09-26-2020, 05:56 PM
  2. Replies: 6
    Last Post: 08-28-2019, 09:42 AM
  3. copy data and paste it in another sheet
    By newbie2 in forum Excel Help
    Replies: 1
    Last Post: 07-15-2015, 01:38 PM
  4. Trapping Copy To Range Before Copy/Cut Paste
    By Rasm in forum Excel Help
    Replies: 4
    Last Post: 04-07-2011, 07:48 PM

Tags for this Thread

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •