+ Reply to Thread
Results 1 to 3 of 3

Macro to populate cells with formula based on adjacent cell

Hybrid View

  1. #1
    Forum Contributor
    Join Date
    11-15-2012
    Location
    Edinburgh, Scotland
    MS-Off Ver
    Excel 2010
    Posts
    195

    Macro to populate cells with formula based on adjacent cell

    Hi,

    I have a spreadsheet with data populated down column B. This size will vary from day to day so is there a macro I can run that will populate Column C with a formula based on their being data in the adjacent cell.

  2. #2
    Forum Contributor arlu1201's Avatar
    Join Date
    09-09-2011
    Location
    Bangalore, India
    MS-Off Ver
    Excel 2003 & 2007
    Posts
    19,166

    Re: Macro to populate cells with formula based on adjacent cell

    Is this solved?

    If you solve a problem yourself before anyone else has responded, please take a moment to describe your solution, chances are some other member will benefit.
    If I have helped, Don't forget to add to my reputation (click on the star below the post)
    Don't forget to mark threads as "Solved" (Thread Tools->Mark thread as Solved)
    Use code tags when posting your VBA code: [code] Your code here [/code]

  3. #3
    Forum Contributor
    Join Date
    11-15-2012
    Location
    Edinburgh, Scotland
    MS-Off Ver
    Excel 2010
    Posts
    195

    Re: Macro to populate cells with formula based on adjacent cell

    Apologies, I actually wanted to delete this thread. I thought I could have used solved to do so. I have unsolved this thread now.

+ 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] Auto populate adjacent cells based on specific dropdown selection
    By ahtigers10 in forum Excel Programming / VBA / Macros
    Replies: 6
    Last Post: 01-02-2014, 08:11 PM
  2. [SOLVED] Loop through named range backwards and populate based on criteria from adjacent cells
    By CDEG in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 03-17-2013, 05:56 AM
  3. Replies: 1
    Last Post: 08-10-2012, 04:30 AM
  4. Replies: 1
    Last Post: 07-24-2012, 02:06 PM
  5. Populate a range of vertical data based on the value in an adjacent cell?
    By juniperjacobs in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 08-19-2010, 12:14 PM

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