+ Reply to Thread
Results 1 to 4 of 4

I wish to use data in my workbook to make calculations between two worksheets at a time

  1. #1
    Registered User
    Join Date
    09-01-2020
    Location
    Owerri, Nigeria
    MS-Off Ver
    2010
    Posts
    4

    I wish to use data in my workbook to make calculations between two worksheets at a time

    For each Name in Column A1 of each worksheet in the workbook,I wish to use this formula:1/Cell B1 value of worksheet1 + 1/Cell C1 value of worksheet2*100 and display the result if less than 100. This same process is repeated between worksheet1 and worksheet3 up until between worksheet1 and worksheet10. The iteration now starts using worksheet2 and worksheet3 and so on until between worksheet2 and worksheet10. Iteration continues beginning from worksheet3(1/Cell B1 value + 1/Cell C1 value of worksheet4*100)...until worksheet3(1/Cell B1 value of sheet3)+ 1/Cell C1 value of worksheet10*100. The last iteration for the first name in column A(sheet1) would be to use 1/ Cell B1 value of sheet9 + 1/Cell C1 value of sheet10*100. These will be executed before the loop goes to the second name in Column A2 of sheet1 and executes the above iteration process all over again( this time : 1/Cell B2 value of worksheet1 + 1/Cell C2 value of worksheet2*100)...until. The rest of the names in Column A is looped through until last Name (Stacy) in Column A10(1/Cell B10 value of worksheet1 + 1/Cell C10 value of worksheet2*100) is looped through with the corresponding iteration through the cells as above and finally displays all values less than 100 through the message box or in some cells of the workbook.
    Last edited by umgbemena; 09-02-2020 at 12:37 PM.

  2. #2
    Forum Expert
    Join Date
    05-29-2020
    Location
    NH USA
    MS-Off Ver
    365
    Posts
    2,103

    re: I wish to use data in my workbook to make calculations between two worksheets at a time

    It would be clearer if you could provide an example of what you want to achieve through a before and after worksheets, as per the yellow banner above.

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

    re: I wish to use data in my workbook to make calculations between two worksheets at a time

    Administrative Note:

    Welcome to the forum.

    We would very much like to help you with your query, however the thread title does not really convey what your request is about. Tell us what you are trying to do, not how you think it should be done.

    Please take a moment to amend your thread title. Make sure that the title properly explains your request. Your title should be explicit and not be generic (this includes function names used without an indication of what you are trying to achieve).

    Please see Forum Rule #1 about proper thread titles and adjust accordingly. To edit the thread title, open the original post to edit and then click on Go Advanced (bottom right) to access the area where you can edit your title.

    (Note: this change is not optional. No help to be offered until this moderation request has been fulfilled.)
    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

  4. #4
    Registered User
    Join Date
    09-01-2020
    Location
    Owerri, Nigeria
    MS-Off Ver
    2010
    Posts
    4

    I wish to use data in my workbook to make calculations between two worksheets at a time

    For each Name in Column A1 of each worksheet in the workbook,I wish to use this formula:1/Cell B1 value of worksheet1 + 1/Cell C1 value of worksheet2*100 and display the result if less than 100. This same process is repeated between worksheet1 and worksheet3 up until between worksheet1 and worksheet10. The iteration now starts using worksheet2 and worksheet3 and so on until between worksheet2 and worksheet10. Iteration continues beginning from worksheet3(1/Cell B1 value + 1/Cell C1 value of worksheet4*100)...until worksheet3(1/Cell B1 value of sheet3)+ 1/Cell C1 value of worksheet10*100. The last iteration for the first name in column A(sheet1) would be to use 1/ Cell B1 value of sheet9 + 1/Cell C1 value of sheet10*100. These will be executed before the loop goes to the second name in Column A2 of sheet1 and executes the above iteration process all over again( this time : 1/Cell B2 value of worksheet1 + 1/Cell C2 value of worksheet2*100)...until. The rest of the names in Column A is looped through until last Name (Stacy) in Column A10(1/Cell B10 value of worksheet1 + 1/Cell C10 value of worksheet2*100) is looped through with the corresponding iteration through the cells as above and finally displays all values less than 100 through the message box or in some cells of the workbook.
    Last edited by alansidman; 09-02-2020 at 06:07 PM.

+ 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] how to make dates progress through worksheets in a workbook
    By mark74 in forum Excel General
    Replies: 7
    Last Post: 05-02-2016, 06:16 PM
  2. Replies: 1
    Last Post: 06-12-2013, 12:00 PM
  3. [SOLVED] Generating summary calculations from multiple worksheets within the same workbook
    By remix7196 in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 09-14-2012, 08:10 AM
  4. Replies: 3
    Last Post: 02-10-2012, 08:33 PM
  5. Make new worksheets from data in workbook
    By randell.graybill in forum Excel Programming / VBA / Macros
    Replies: 12
    Last Post: 03-14-2010, 04:48 AM
  6. Connecting data in different pages and make calculations
    By Orf in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 12-09-2005, 06:45 AM
  7. [SOLVED] calculations from data in other worksheets
    By Tolleen in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 01-11-2005, 03:06 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