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. 08-26-2020, 07:29 PM #37
    fixer
    fixer is offline
    Senior Member
    Join Date
    Jul 2019
    Posts
    382
    Rep Power
    0

    If Decimal Found then move the data from after decimal to before decimal

    Hi Experts,

    I am looking for a macro that will do the the things mentioned below
    Macro will be placed in a macro.xlsm
    macro.xlsm & 1.xls both are located in different path so the path should be hardcoded in the macro, so i can change it as per my needs


    In column K, If after decimal if the second digit is 0 then Move all the data from after decimals to before decimals
    K2 has data that has the second number after decimal is 0, so the output would be in K2 10030.00


    Thnx For the Help
    https://www.excelforum.com/excel-pro...e-decimal.html
    Attached Files Attached Files
    • File Type: xls 1.xls (26.0 KB, 2 views)
    Reply With Quote Reply With Quote
« Previous Thread | Next Thread »

Similar Threads

  1. VBA Dir File Copy and Paste: Check if file exists then copy file from one directory to another. Bat File
    By fixer in forum Test Area
    Replies: 26
    Last Post: 09-26-2020, 05:56 PM
  2. VBA Simple Copy and Paste between two workbooks based on criteria
    By fixer in forum Excel Help
    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

Bookmarks

Posting Permissions

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

Forum Rules