+ Reply to Thread
Results 1 to 5 of 5

copy specific columns and replace values & calculate values from sheet to another

  1. #1
    Forum Contributor
    Join Date
    12-02-2020
    Location
    Asia
    MS-Off Ver
    2010 & 2016 insider(Windows 10 64-bit)
    Posts
    468

    copy specific columns and replace values & calculate values from sheet to another

    hello
    I have data in sheet1 the expected result should brings all of data in sheet2 it should copy specific columns (BRAND,TYPE,ORIGIN,SALES,RETURNS,BALANCE) there is two columns K,L are relating in COL ORIGIN in sheet1, it should replace for it based on COL K the col L= col k then should copy values from COL K to COL ORIGIN and the COL BALANCE should calculate the values by subtracting the COL SALES from COL RETURNS
    thanks in advance
    Attached Files Attached Files

  2. #2
    Forum Expert
    Join Date
    10-06-2008
    Location
    Canada
    MS-Off Ver
    2007 / 2013
    Posts
    4,795

    Re: copy specific columns and replace values & calculate values from sheet to anoth

    Should this be the other way around? subtracting the COL SALES from COL RETURNS > Subtract returns from sales

  3. #3
    Forum Expert
    Join Date
    10-06-2008
    Location
    Canada
    MS-Off Ver
    2007 / 2013
    Posts
    4,795

    Re: copy specific columns and replace values & calculate values from sheet to anoth

    Please Login or Register  to view this content.

  4. #4
    Forum Expert sintek's Avatar
    Join Date
    12-04-2015
    Location
    Cape Town
    MS-Off Ver
    2013 | 2016 | 2019
    Posts
    11,398

    Re: copy specific columns and replace values & calculate values from sheet to anoth

    My take on this one...
    Please Login or Register  to view this content.
    Attached Files Attached Files
    Good Luck
    I don't presume to know what I am doing, however, just like you, I too started somewhere...
    One-day, One-problem at a time!!!
    If you feel I have helped, please click on the star to left of post [Add Reputation]
    Also....add a comment if you like!!!!
    And remember...Mark Thread as Solved.
    Excel Forum Rocks!!!

  5. #5
    Forum Contributor
    Join Date
    12-02-2020
    Location
    Asia
    MS-Off Ver
    2010 & 2016 insider(Windows 10 64-bit)
    Posts
    468

    Re: copy specific columns and replace values & calculate values from sheet to anoth

    thanks guys ! the codes are perfectly

+ 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. [SOLVED] Find and Replace Multiple Columns in Sheet 1 Based on a Column Values in Sheet 2
    By adblog3 in forum Excel Programming / VBA / Macros
    Replies: 9
    Last Post: 04-07-2020, 01:49 PM
  2. Copy Textbox values to last blank row for specific columns
    By buhwheet in forum Excel Programming / VBA / Macros
    Replies: 6
    Last Post: 12-28-2018, 05:45 PM
  3. How to copy pivote table details and paste (replace) with values only in same sheet
    By aleanboy in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 10-09-2014, 01:50 PM
  4. Macro to find all specific values in column and replace adjacent cell values
    By dblock02 in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 07-23-2013, 06:03 AM
  5. Macro to copy values from specific columns from different workbooks to one sheet
    By sksajid7 in forum Excel Programming / VBA / Macros
    Replies: 9
    Last Post: 07-11-2013, 09:50 AM
  6. [SOLVED] Copy Specific Columns if they match values from another sheet
    By Costasg in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 04-04-2012, 09:09 AM
  7. Filter, copy specific columns, and paste to another sheet as VALUES ONLY
    By elobelix in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 08-04-2010, 11:59 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