+ Reply to Thread
Results 1 to 1 of 1

To form a formula of two different columns

  1. #1
    Forum Contributor
    Join Date
    09-19-2017
    Location
    London
    MS-Off Ver
    2015
    Posts
    169

    Question To form a formula of two different columns

    Hi, all

    Hope you are doing well.

    I have a file named Scheduler, which the intention is to extract and consolidate some data and list out in orderly manner in "Orders" sheet. The data will be coming from sheet "result_cb" of Result file.

    In the control panel sheet in Scheduler, I have listed out the nomenclature which it should copy paste to "Orders" sheet in column B. But for column C ("Value" column), as of now my code is only extracting value from column R in "result_cb" sheet. But I want to change it to become a formula instead hence value in column C of "Orders" should be:

    Value = 1.07*R + S

    Is it possible to do such?

    I have tried to tweak it around but it did not work.

    Can I know how can I adjust this code?

    Please Login or Register  to view this content.
    Hereby I attached both files as well.

    Appreciate anyone's feedback.
    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. Replies: 4
    Last Post: 06-25-2018, 10:15 PM
  2. Replies: 7
    Last Post: 03-15-2015, 03:12 PM
  3. Replies: 6
    Last Post: 04-08-2014, 03:16 PM
  4. Replies: 3
    Last Post: 04-17-2013, 07:09 PM
  5. [SOLVED] Ratio formula in it's original form (NOT in simplest/lowest form)
    By tlacloche in forum Excel Formulas & Functions
    Replies: 5
    Last Post: 03-22-2013, 01:08 PM
  6. Columns in a form
    By LAF in forum Excel Programming / VBA / Macros
    Replies: 14
    Last Post: 09-24-2010, 09:20 PM
  7. Web Form or Form that Populates Columns in Spreadsheet
    By uneek78 in forum Excel General
    Replies: 0
    Last Post: 11-05-2009, 10:49 AM

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