Results 1 to 9 of 9

VBA - Populate Cell in Column F if Adjacent cell in Column E is not blank

Threaded View

DoriBeE VBA - Populate Cell in Column... 02-11-2011, 01:45 PM
MarvinP Re: VBA - Populate Cell in... 02-11-2011, 05:57 PM
DoriBeE Re: VBA - Populate Cell in... 02-11-2011, 07:15 PM
DoriBeE Re: VBA - Populate Cell in... 02-11-2011, 07:09 PM
MarvinP Re: VBA - Populate Cell in... 02-11-2011, 07:26 PM
DoriBeE Re: VBA - Populate Cell in... 02-11-2011, 07:47 PM
MarvinP Re: VBA - Populate Cell in... 02-11-2011, 08:34 PM
DonkeyOte Re: VBA - Populate Cell in... 02-12-2011, 05:24 AM
DoriBeE Re: VBA - Populate Cell in... 02-14-2011, 04:46 PM
  1. #1
    Registered User
    Join Date
    04-16-2010
    Location
    Philadelphia, PA
    MS-Off Ver
    Excel 2007, 2003
    Posts
    25

    Red face VBA - Populate Cell in Column F if Adjacent cell in Column E is not blank

    HELP! I have a Spreadsheet in which Columns F & G retrieve the Month (F) and Year (G) of the date in column E.

    The formula is as follows:
    =IF(ISBLANK($E2),"",VLOOKUP(MONTH($E2),Months,2,FALSE))

    Problem: Spreadsheet lags due to Formulas sitting in cells of COlumn F & waiting for a value to be inputed beside them.

    What I need: I want to remove the formulas i have in columns f and g and have a vba code that will populate F & G with this formula =VLOOKUP(MONTH($E2),Months,2,FALSE)) for every cell that is not blank in COlumn e.

    Meaning,
    If E2 is blank, then no formula in F2 or G2
    if E2 is not blank, F2 & G2 calculate Month and Year (Respectively).
    for every row in my range...

    Gracias in advance!

    PS- I have a dynamic range that auto arranges itself, so the code could be to just apply it within that range when ever a change is made to the worksheet? (i could be way off, just a suggestion).
    Last edited by DoriBeE; 03-03-2011 at 12:03 PM. Reason: close enough!

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