+ Reply to Thread
Results 1 to 1 of 1

Modifying the Topmost Entry of a Table

  1. #1
    Registered User
    Join Date
    01-22-2019
    Location
    Nova Scotia, Canada
    MS-Off Ver
    2007
    Posts
    22

    Modifying the Topmost Entry of a Table

    Good morning,

    I have several worksheets with a Table 1 in column A from A5:A15 for example (see below). Although every table in each worksheet has 10 rows from A5:A10, not every row contains a value (many tables will have blank entries, and the topmost entry of each table will vary from worksheet to worksheet). Can someone help me with the following macro?

    If the topmost entry of table 1 is greater than C1, then set the topmost entry equal to C1


    In the table below, if y in C1 = 0.75, then A5 would become 0.75

    If the topmost entry of table 1 is less than C1, then add the lesser of the following two values to the topmost entry of Table 1:

    1. The value needed for the sum of all entries in Table 1 to equal B1
    2. The value needed for the topmost entry of Table 1 to equal C1

    So if x in B1 = 8.6, and y in C1 = 0.95, then A5 becomes 0.9. However, if x in B1 = 8.6 and C1 = 0.88, then A5 becomes 0.88.

    M
    Attached Images Attached Images
    Last edited by excel_novice2019; 01-23-2019 at 09:06 AM.

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

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