+ Reply to Thread
Results 1 to 6 of 6

VBA Loop Code needed

  1. 06-09-2015, 01:15 PM #1
    mxlew
    mxlew is offline
    Registered User
    Join Date
    05-30-2015
    Location
    Singapore
    MS-Off Ver
    2010
    Posts
    7

    VBA Loop Code needed

    Hi Experts,

    I would like to come up with a VBA code (likely looping..) that will return me with the 2 yellow columns.

    There are 2 data columns (orange) and I need to round up column H to the next figure from column B. And definitely it must also exactly match to column A.

    Thank you all for the help in advance.
    vba.JPG
    Attached Files Attached Files
    Reply With QuoteRegister To Reply
  2. 06-09-2015, 01:38 PM #2
    mxlew
    mxlew is offline
    Registered User
    Join Date
    05-30-2015
    Location
    Singapore
    MS-Off Ver
    2010
    Posts
    7

    Re: VBA Loop Code needed

    please help!

    Thank you.
    Reply With QuoteRegister To Reply
  3. 06-09-2015, 02:06 PM #3
    nigelbloomy
    nigelbloomy is offline
    Valued Forum Contributor nigelbloomy's Avatar
    Join Date
    11-06-2013
    Location
    USA
    MS-Off Ver
    Excel 2010
    Posts
    1,011

    Re: VBA Loop Code needed

    This entered as an array formula in H2 should work. Use CTRL+SHIFT+ENTER to enter the formula instead of just ENTER.
    Please Login or Register  to view this content.
    Some people volunteer in soup kitchens or hospitals. I choose to make the world better by trying to help you with Excel. We're all learning.

    <---Click * Add Reputation for all helpful comments. It's like giving a smile.
    Forum Rules: How to mark your post [Solved] and have a happier, Excel enriched life.
    Reply With QuoteRegister To Reply
  4. 06-09-2015, 02:06 PM #4
    nigelbloomy
    nigelbloomy is offline
    Valued Forum Contributor nigelbloomy's Avatar
    Join Date
    11-06-2013
    Location
    USA
    MS-Off Ver
    Excel 2010
    Posts
    1,011

    Re: VBA Loop Code needed

    Double Post
    Reply With QuoteRegister To Reply
  5. 06-09-2015, 03:21 PM #5
    mperrah
    mperrah is offline
    Registered User
    Join Date
    07-28-2007
    Posts
    35

    Re: VBA Loop Code needed

    this puts the correct price in Column "L"
    Please Login or Register  to view this content.
    Reply With QuoteRegister To Reply
  6. 06-09-2015, 03:26 PM #6
    mperrah
    mperrah is offline
    Registered User
    Join Date
    07-28-2007
    Posts
    35

    Re: VBA Loop Code needed

    and this will put the values in the Yellow "results" columns (I and J)
    Please Login or Register  to view this content.
    Reply With QuoteRegister To Reply
+ Reply to Thread
« Previous Thread | Next Thread »

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. Help needed: Do While Loop needed
    By xlislovexlislife in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 04-11-2015, 11:00 AM
  2. Assistance needed to loop code when pulling info from a web page and pasting to excel
    By boswelljw in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 01-29-2015, 09:49 AM
  3. Help needed on loop
    By johncassell in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 05-17-2006, 08:10 AM
  4. [SOLVED] loop code needed
    By JohnUK in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 06-14-2005, 01:05 AM
  5. Help needed with If/Then/Loop
    By KenoshaCanuck in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 01-07-2005, 04:12 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

Forum Rules


Search Engine Friendly URLs by vBSEO 3.6.0 RC 1