+ Reply to Thread
Results 1 to 9 of 9

how to update a sheets based on value of cells in a column in another sheet

  1. #1
    Registered User
    Join Date
    07-03-2016
    Location
    cochin
    MS-Off Ver
    2007
    Posts
    6

    Post how to update a sheets based on value of cells in a column in another sheet

    I have two sheets on my excel work book. sheet1 contains whole customers data, sheet 2 contains data of customers who made payments. both sheets contain a column named "customer id" , I enter payment details details only in sheets 2 . **i need to get updated sheet 1 automatically based on "customer id" the corresponding row should be highlighted or marked " paid " in another column**.

    sheet 1:- all customer data with customer id (1000,999.998.... in descending order)
    sheet 2:- details of customers those who made payment with customer id(the order in which the payment made)

  2. #2
    Forum Contributor
    Join Date
    01-09-2016
    Location
    Perth Western Australia
    MS-Off Ver
    Office 365
    Posts
    257

    Re: how to update a sheets based on value of cells in a column in another sheet

    Hi

    Could you upload a sample of your workbook as it will make it easier to provide a solution for you.

    Thanks

  3. #3
    Forum Expert
    Join Date
    06-08-2012
    Location
    Left the forum!
    MS-Off Ver
    Left the forum!
    Posts
    5,189

    Re: how to update a sheets based on value of cells in a column in another sheet

    Assuming customer ID's are in column A on both sheets, use the following formula to mark "Paid" in your chosen column..

    =IF(ISNUMBER(MATCH(A2,'Sheet 2'!$A:$A,0)),"Paid","")

  4. #4
    Registered User
    Join Date
    07-03-2016
    Location
    cochin
    MS-Off Ver
    2007
    Posts
    6

    Re: how to update a sheets based on value of cells in a column in another sheet

    I have uploaded my file

    when a customer make payment i enter details in sheet 2 , i need to get updated in sheet 1 column D, in corresponding row (where the customer id found)
    pld see the atachment
    Attached Files Attached Files

  5. #5
    Forum Guru
    Join Date
    08-28-2014
    Location
    USA
    MS-Off Ver
    Excel 2019
    Posts
    14,285

    Re: how to update a sheets based on value of cells in a column in another sheet

    Since the customer ID numbers are in column B of both sheets, modify Jason's formula to read:
    Formula: copy to clipboard
    Please Login or Register  to view this content.
    Let me know if you have any questions.
    Consider taking the time to add to the reputation of everybody that has taken the time to respond to your query.

  6. #6
    Registered User
    Join Date
    07-03-2016
    Location
    cochin
    MS-Off Ver
    2007
    Posts
    6

    Re: how to update a sheets based on value of cells in a column in another sheet

    please see the newly uploaded file , every customer in sheet 1 displays as "paid"
    Attached Files Attached Files

  7. #7
    Forum Guru
    Join Date
    08-28-2014
    Location
    USA
    MS-Off Ver
    Excel 2019
    Posts
    14,285

    Re: how to update a sheets based on value of cells in a column in another sheet

    Using the following formula only the customers whom are listed on page 2 display 'Paid' on page 1:
    Formula: copy to clipboard
    Please Login or Register  to view this content.
    Let me know if you have any questions.
    Attached Files Attached Files

  8. #8
    Registered User
    Join Date
    07-03-2016
    Location
    cochin
    MS-Off Ver
    2007
    Posts
    6

    Re: how to update a sheets based on value of cells in a column in another sheet

    its worked thank you very much

  9. #9
    Forum Guru
    Join Date
    08-28-2014
    Location
    USA
    MS-Off Ver
    Excel 2019
    Posts
    14,285

    Re: how to update a sheets based on value of cells in a column in another sheet

    You're Welcome and thank you for the feedback. Please take a moment to mark the thread 'Solved' using the thread tools link above your first post. I hope that you have a blessed day.

+ 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] Update multiple cells in same column from sheet 1 to sheet 2
    By Sai Prashanth in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 10-03-2014, 12:46 PM
  2. Update table on another sheet with information on ACTIVE SHEET based on column search.
    By keelinglee in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 05-14-2014, 09:06 PM
  3. [SOLVED] Linking cells from one sheet to another and update cells accordingly based on selection
    By hcyeap in forum Excel Programming / VBA / Macros
    Replies: 7
    Last Post: 12-17-2013, 09:53 AM
  4. [SOLVED] Compare 2 sheets, match data in 1 column, update row in sheet 2 & add new rows not matched
    By Synchronicity in forum Excel Programming / VBA / Macros
    Replies: 15
    Last Post: 11-11-2013, 01:21 PM
  5. Create and/or update sheets based on value in column A
    By ClassicVAG in forum Excel Programming / VBA / Macros
    Replies: 7
    Last Post: 09-30-2012, 09:15 AM
  6. Replies: 0
    Last Post: 08-07-2011, 05:06 PM
  7. Create sheets based on a column of master sheet
    By samdaddy07 in forum Excel Programming / VBA / Macros
    Replies: 7
    Last Post: 02-10-2009, 02:54 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

X vBulletin 4.1.8 Debug Information

  • Page Generation 0.66827 seconds
  • Memory Usage 9,116KB
  • Queries Executed 16 (?)
More Information
Template Usage (34):
  • (1)SHOWTHREAD
  • (1)ad_footer_end
  • (1)ad_footer_start
  • (1)ad_global_above_footer
  • (1)ad_global_below_navbar
  • (1)ad_global_header1
  • (1)ad_global_header2
  • (1)ad_navbar_below
  • (1)ad_showthread_firstpost_sig
  • (1)ad_showthread_firstpost_start
  • (1)ad_thread_first_post_content
  • (1)ad_thread_last_post_content
  • (1)footer
  • (1)forumrules
  • (1)gobutton
  • (1)header
  • (1)headinclude
  • (1)headinclude_bottom
  • (9)memberaction_dropdown
  • (1)navbar
  • (4)navbar_link
  • (4)navbar_noticebit
  • (6)option
  • (3)postbit_attachment
  • (9)postbit_legacy
  • (9)postbit_onlinestatus
  • (9)postbit_wrapper
  • (4)showthread_bookmarksite
  • (7)showthread_similarthreadbit
  • (1)showthread_similarthreads
  • (1)spacer_close
  • (1)spacer_open
  • (1)tagbit_wrapper
  • (1)vbseo_linkbackmenu_entry 

Phrase Groups Available (6):
  • global
  • inlinemod
  • postbit
  • posting
  • reputationlevel
  • showthread
Included Files (39):
  • ./vbseo.php
  • ./env.php
  • ./vbseo/includes/functions_vbseo.php
  • ./vbseo/includes/functions_vbseo_pre.php
  • ./vbseo/includes/functions_vbseo_url.php
  • ./vbseo/includes/functions_vbseo_createurl.php
  • ./vbseo/includes/functions_vbseo_db.php
  • ./vbseo/includes/functions_vbseo_vb.php
  • ./vbseo/includes/functions_vbseo_seo.php
  • ./vbseo/includes/functions_vbseo_misc.php
  • ./vbseo/includes/functions_vbseo_crr.php
  • ./vbseo/includes/functions_vbseo_cache.php
  • ./vbseo/includes/functions_vbseo_hook.php
  • ./vbseo/includes/functions_vbseo_startup.php
  • ./includes/config.php
  • ./showthread.php
  • ./global.php
  • ./includes/class_bootstrap.php
  • ./includes/init.php
  • ./includes/class_core.php
  • ./includes/functions.php
  • ./includes/class_friendly_url.php
  • ./includes/class_hook.php
  • ./includes/functions_cforum.php
  • ./includes/functions_facebook.php
  • ./includes/functions_bigthree.php
  • ./includes/class_postbit.php
  • ./includes/class_bbcode.php
  • ./includes/functions_reputation.php
  • ./includes/class_bootstrap_framework.php
  • ./vb/vb.php
  • ./vb/phrase.php
  • ./packages/vbattach/attach.php
  • ./vb/types.php
  • ./vb/cache.php
  • ./vb/cache/db.php
  • ./vb/cache/observer/db.php
  • ./vb/cache/observer.php
  • ./includes/functions_notice.php 

Hooks Called (50):
  • init_startup
  • friendlyurl_resolve_class
  • database_pre_fetch_array
  • database_post_fetch_array
  • global_bootstrap_init_start
  • global_bootstrap_init_complete
  • cache_permissions
  • fetch_threadinfo_query
  • fetch_threadinfo
  • fetch_foruminfo
  • global_state_check
  • global_bootstrap_complete
  • global_start
  • style_fetch
  • global_setup_complete
  • showthread_start
  • showthread_getinfo
  • friendlyurl_redirect_canonical
  • showthread_post_start
  • showthread_query_postids
  • showthread_query
  • bbcode_fetch_tags
  • bbcode_create
  • showthread_postbit_create
  • postbit_factory
  • postbit_display_start
  • fetch_musername
  • cache_templates
  • template_register_var
  • parse_templates
  • notices_check_start
  • notices_noticebit
  • process_templates_complete
  • reputation_image
  • postbit_imicons
  • bbcode_parse_start
  • bbcode_parse_complete_precache
  • bbcode_parse_complete
  • postbit_display_complete
  • memberaction_dropdown
  • postbit_attachment
  • tag_fetchbit
  • tag_fetchbit_complete
  • showthread_similarthread_query
  • showthread_similarthreadbit
  • forumrules
  • showthread_bookmarkbit
  • navbits
  • navbits_complete
  • showthread_complete


Search Engine Friendly URLs by vBSEO 3.6.0 RC 1