+ Reply to Thread
Results 1 to 2 of 2

Do Ms Excel/VBA Scripting

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

    Do Ms Excel/VBA Scripting

    For each name in the workbook,I wish to add 1/the value in the B cell of worksheet1 and 1/the value in the C cell of worksheet2 *100 and display the result if less than 100. This same process is repeated for worksheet1 and worksheet3 and on until worksheet10. The iteration now starts from worksheet2 and worksheet3 and so on until worksheet2 and worksheet10. Iteration continues beginning from worksheet3 and 1/the value in C cell of worksheet4...until worksheet3 and 1/C cell value of worksheet10. The last iteration for the first name in the column would be the use of 1/the value in the B cell of sheet9 and 1/the value in C cell of sheet10. This will happen before the loop goes to the second name and executes the above iteration process all over again until the last Name (Stacy) 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.
    Attached Files Attached Files

  2. #2
    Forum Contributor Dante Amor's Avatar
    Join Date
    07-24-2020
    Location
    MEXICO
    MS-Off Ver
    Excel 2013
    Posts
    212

    Re: Do Ms Excel/VBA Scripting

    Duplicate post. Please read rules:
    https://www.excelforum.com/forum-rul...rum-rules.html

+ 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: 1
    Last Post: 10-23-2017, 06:08 AM
  2. Excel 2007 : Scripting in Excel
    By KMB5 in forum Excel General
    Replies: 1
    Last Post: 10-27-2010, 04:07 AM
  3. When scripting in Excel can you use notepad?
    By simpleonline1234 in forum Excel Programming / VBA / Macros
    Replies: 7
    Last Post: 04-29-2010, 11:18 AM
  4. Excel Dashboard without VBA Scripting?
    By binar in forum Excel General
    Replies: 0
    Last Post: 03-16-2009, 11:51 PM
  5. [SOLVED] VBA scripting in Excel
    By Len in forum Excel Programming / VBA / Macros
    Replies: 5
    Last Post: 04-26-2006, 11:15 PM
  6. [SOLVED] AVAYA CMS Scripting through Excel VBA
    By Maxi in forum Excel Programming / VBA / Macros
    Replies: 5
    Last Post: 03-11-2006, 03:40 PM
  7. Excel scripting,programming
    By TechGuyatwork in forum Excel - New Users/Basics
    Replies: 2
    Last Post: 06-19-2005, 02:05 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