+ Reply to Thread
Results 1 to 1 of 1

Formula to pop data from mult cells from one WS to another based on data enter in a cell

  1. #1
    Forum Contributor
    Join Date
    07-06-2013
    Location
    USA
    MS-Off Ver
    MS Office 2019 Pro Plus
    Posts
    182

    Formula to pop data from mult cells from one WS to another based on data enter in a cell

    WS Attached

    Formula needed to populate data from multiple cells from one WS to another based on data entered into a particular cell.

    On sheet ‘LEADS’, the 4 columns: D, E, F, & I, 6:1005 – when any date is entered into K6:K1005,
    the data from the 4 columns mentioned will auto populate into sheet ‘SALES’
    Columns C, D, E, & F, 6:505 with the data falling under the same headings for both sheets.

    Thanks in advance
    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. Replies: 1
    Last Post: 01-18-2016, 03:40 PM
  2. Enter and Update Data on One Cell based on Date
    By amrit02 in forum Excel General
    Replies: 3
    Last Post: 12-27-2015, 12:21 PM
  3. [SOLVED] Formula needed to auto populate in a range of cells on mult sprdsheets based on text input
    By excelteam777 in forum Excel Formulas & Functions
    Replies: 0
    Last Post: 05-31-2015, 06:40 PM
  4. Enter data into cells based on single cell data
    By lawrence24 in forum Excel Formulas & Functions
    Replies: 9
    Last Post: 09-09-2014, 03:11 AM
  5. conditionally enter data in a cell based on content of another cell
    By jrustebakke in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 01-09-2014, 02:47 PM
  6. Replies: 3
    Last Post: 09-20-2013, 04:24 PM
  7. Excel VB Script to Enter Data based on whether a Cell is empty or not
    By timepass111 in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 09-19-2011, 10:27 AM

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