+ Reply to Thread
Results 1 to 3 of 3

When condition true, need to copy range,

  1. #1
    Registered User
    Join Date
    11-10-2016
    Location
    Sri Lanka
    MS-Off Ver
    2010
    Posts
    77

    When condition true, need to copy range,

    Hello everyone.

    If H3:H1000, column value >=10,

    When this condition true, need to copy (A22:A1000) value to (I22:I1000) and (F22:F1000) value to (J22:J1000).

    Thank you,
    Attached Files Attached Files

  2. #2
    Forum Moderator alansidman's Avatar
    Join Date
    02-02-2010
    Location
    Steamboat Springs, CO
    MS-Off Ver
    MS Office 365 Version 2404 Win 11 Home 64 Bit
    Posts
    23,860

    Re: When condition true, need to copy range,

    Please Login or Register  to view this content.
    Alan עַם יִשְׂרָאֵל חַי


    Change an Ugly Report with Power Query
    Database Normalization
    Complete Guide to Power Query
    Man's Mind Stretched to New Dimensions Never Returns to Its Original Form

  3. #3
    Registered User
    Join Date
    11-10-2016
    Location
    Sri Lanka
    MS-Off Ver
    2010
    Posts
    77

    Re: When condition true, need to copy range,

    dear sir,
    It is correct. appreciate your support.
    sir, i have another problem.
    H column calculation ....
    H3=(F2-F3)*100
    H4=(F2-F4)*100
    H5=(F2-FF5)*100
    .....................
    .....................
    When Hn value >=+or-10;That row ,Bn value - B2 write In Jn.
    Then
    Hn+1=Hn-Hn+1
    Hn+2=Hn-Hn+2
    ....................
    ...................
    Hn+n value >=+or-10 ;That row ,Bn+n value - Bn write In Jn+n

    ....................................
    .........................................
    This manual calculation attached .
    Attached Files Attached Files

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. how to copy data from the textbox if condition is true or false???
    By clinton96 in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 09-03-2016, 03:03 AM
  2. Replies: 1
    Last Post: 03-09-2016, 03:57 AM
  3. [SOLVED] If Condition True Then Paste Named Range
    By bkg73123 in forum Excel General
    Replies: 6
    Last Post: 10-03-2014, 11:30 AM
  4. [SOLVED] Copy all row if condition is true
    By norlax in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 06-13-2014, 12:01 PM
  5. if condition is true then copy the range to other range
    By pedjvak in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 01-21-2013, 04:56 AM
  6. open a comment to cell range upon true condition then removing comment on false condition
    By ferrum_equitis in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 08-08-2012, 12:55 AM
  7. if condition is true then copy the formula in the other cell
    By pedjvak in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 08-01-2012, 02:05 AM

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

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1