+ Reply to Thread
Results 1 to 2 of 2

Move cell value from one column to another based on contents

  1. #1
    Forum Contributor
    Join Date
    04-06-2009
    Location
    England
    MS-Off Ver
    Excel 2007
    Posts
    103

    Move cell value from one column to another based on contents

    Hi,

    I have a query about creating a macro to move certain figures from one column to another.

    Look down column F and G for negative value. If a negative value is found then I would like this to be moved into the opposite column as a positive and removed from the first column.

    So, for example. If F6 was -100 then I would like G6 to be 100 and F6 to be made blank.

    I would need this macro to run from Row 4 to the bottom of the data, which, I have declared a variable as lastrow.

    Any ideas on this guys?
    Thanks

  2. #2
    Forum Contributor mccrimmon's Avatar
    Join Date
    02-19-2004
    Location
    Scotland
    MS-Off Ver
    2003
    Posts
    249

    Re: Move cell value from one column to another based on contents

    The below column will do exactly what you are after for column F. You obvioulsy need to extend if you are wanting to look for negative numbers in Column G aswell.

    Cheers

    Please Login or Register  to view this content.
    Last edited by mccrimmon; 06-30-2011 at 06:47 AM.
    McCrimmon

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

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