+ Reply to Thread
Results 1 to 8 of 8

macro to populate cells based on value on other sheet

  1. #1
    Forum Contributor
    Join Date
    02-18-2014
    Location
    United Kingdom
    MS-Off Ver
    Excel 2010
    Posts
    356

    macro to populate cells based on value on other sheet

    any advice would be a great help
    i have posted this in general but feel it might be of more use in vba
    what im looking to do is auto populate other sheets based on a certain cell
    I have attached spreadsheet to help explain

    if on the first page (NEW WORKOUT SHEET)
    in cell G3 is a manufacturer (a) so once this cell has data in it i want it to take the relevant data to sheet (a)


    please see sheet a

    i hope i have explained this ok.
    all help gratefully received

    many thanks
    Attached Files Attached Files

  2. #2
    Forum Guru xladept's Avatar
    Join Date
    04-14-2012
    Location
    Pasadena, California
    MS-Off Ver
    Excel 2003,2010
    Posts
    12,378

    Re: macro to populate cells based on value on other sheet

    Hi SWFarm,

    Try this: SWFArm.xlsm
    If I've helped you, please consider adding to my reputation - just click on the liitle star at the left.

    ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~(Pride has no aftertaste.)

    You can't do one thing. XLAdept

    ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~aka Orrin

  3. #3
    Forum Expert
    Join Date
    02-19-2013
    Location
    India
    MS-Off Ver
    07/16
    Posts
    2,386

    Re: macro to populate cells based on value on other sheet

    Hello find attached ! I don't think really VBA is required for this.

    Change the references which is currently G3:G11 to your actual data range and lock them with dollar sign in sheet A A1 and drag down and
    right.

    Formula from A1 till the end are array formula you need to confirm them with control shift and enter! instead of pressing enter.

    FOrmula in K1 is non array means you can simply press enter
    Attached Files Attached Files
    Last edited by hemesh; 02-27-2014 at 08:10 PM.
    -------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------

    WANT TO SAY THANKS, HIT ADD REPUTATION (*) AT THE BOTTOM LEFT CORNER OF THE POST

    More we learn about excel, more it shows us, how less we know about it.

    for chemistry
    https://www.youtube.com/c/chemistrybyshivaansh

  4. #4
    Forum Expert
    Join Date
    02-19-2013
    Location
    India
    MS-Off Ver
    07/16
    Posts
    2,386

    Re: macro to populate cells based on value on other sheet

    Thanks for the comment and Rep

  5. #5
    Forum Contributor
    Join Date
    02-18-2014
    Location
    United Kingdom
    MS-Off Ver
    Excel 2010
    Posts
    356

    Re: macro to populate cells based on value on other sheet

    hemesh as requested
    thank you for your patience once again
    Attached Files Attached Files

  6. #6
    Forum Expert
    Join Date
    02-19-2013
    Location
    India
    MS-Off Ver
    07/16
    Posts
    2,386

    Re: macro to populate cells based on value on other sheet

    find attached !
    I think your show formula tab is on.

    make it off by going to formulas tab.---> formula editing----> click show formulas and see you will be able to view the results.


    Hope this helps !
    Attached Files Attached Files

  7. #7
    Forum Contributor
    Join Date
    02-18-2014
    Location
    United Kingdom
    MS-Off Ver
    Excel 2010
    Posts
    356

    Re: macro to populate cells based on value on other sheet

    Spreadsheet attached Hemesh
    Attached Files Attached Files

  8. #8
    Forum Expert
    Join Date
    02-19-2013
    Location
    India
    MS-Off Ver
    07/16
    Posts
    2,386

    Re: macro to populate cells based on value on other sheet

    In this set up you don't even need to populate the sheet name because it is already written by you and you just need to change the reference for the day

    Important things to notice that all day name should be same and all the names should be same in both sheets!
    Attached Files Attached Files

+ 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] Macro to Auto-populate cells and columns based off of a Number
    By Cansa in forum Excel Programming / VBA / Macros
    Replies: 8
    Last Post: 05-06-2013, 05:59 PM
  2. Macro to populate surrounding cells based on the value of another
    By irfan1983 in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 08-05-2012, 04:05 PM
  3. Replies: 4
    Last Post: 03-01-2012, 01:05 PM
  4. Auto-populate cells based on data from another sheet
    By tmartin1313 in forum Excel Formulas & Functions
    Replies: 5
    Last Post: 11-16-2011, 12:15 AM
  5. Macro to add rows and populate cells based on critera
    By Scott Wagner in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 12-23-2005, 12:00 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