+ Reply to Thread
Results 1 to 3 of 3

add & subtract by vba

  1. #1
    Forum Contributor
    Join Date
    05-10-2020
    Location
    india
    MS-Off Ver
    2013
    Posts
    221

    add & subtract by vba

    Hi,

    Macro will be placed in macro.xlsm, macro.xlsm & basketorder.xlsx both are located at diiferent path so the path of basketorder.xlsx should be hardcoded in the macro so that i can change it as per my needs

    If J is Buy then add .05 to to column L & put the total to Column G
    If column J is Sell then subtract .05 to to column L & put the total to Column G

    Thnx
    Attached Files Attached Files

  2. #2
    Forum Moderator davesexcel's Avatar
    Join Date
    02-19-2006
    Location
    Regina
    MS-Off Ver
    MS 365
    Posts
    13,475

    Re: add & subtract by vba

    Please Login or Register  to view this content.
    Last edited by davesexcel; 09-26-2020 at 05:35 AM.

  3. #3
    Forum Contributor
    Join Date
    05-10-2020
    Location
    india
    MS-Off Ver
    2013
    Posts
    221

    Re: add & subtract by vba

    Thnx Alot Davesexcel Sir for helping me in solving this problem Sir
    Have a Awesome Day Sir

+ 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. Subtract until 0 then move to next cell to subtract until 0
    By manateee in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 04-15-2020, 03:32 AM
  2. Replies: 2
    Last Post: 11-20-2019, 10:31 AM
  3. [SOLVED] I need to subtract
    By Jesus Huerta in forum Excel General
    Replies: 2
    Last Post: 10-21-2019, 02:55 PM
  4. Add and subtract
    By caziscarol in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 04-20-2015, 08:56 AM
  5. If Sat subtract one day, if Sunday subtract tow days
    By Wskip49 in forum Excel General
    Replies: 3
    Last Post: 06-30-2012, 03:35 PM
  6. Replies: 1
    Last Post: 01-27-2012, 11:25 PM
  7. [SOLVED] how to subtract one row from the other?
    By prasad in forum Excel General
    Replies: 1
    Last Post: 04-08-2005, 04:06 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

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1