+ Reply to Thread
Results 1 to 5 of 5

How do I move certain Cell data from one worksheet to another?

  1. #1
    ryan r
    Guest

    How do I move certain Cell data from one worksheet to another?

    I have an excel file with two different worksheets. On the 2nd worksheet I
    have a Column labled "status," in which each cell has a dropbox with either
    Pre-qual, Active, or TD as choices. The other columns all have client data.
    Now, I need several cells of information from the row to move to certain
    cells in the 1st worksheet when the "Pre-Qual" choice is picked on the
    dropbox from the "Status" Column. Any help here would be appreciated

    -Thanks!
    -Ryan

  2. #2
    CLR
    Guest

    Re: How do I move certain Cell data from one worksheet to another?

    Hi Ryan........

    I'm afraid I would need a little more information to make any kind of
    specific suggestion. There are so many options toward something like you
    are taling about........ie:, linked cells, VLOOKUP formula, AutoFilter,
    Macros, etc.........and you don't mention what, if anything you want to have
    happen when the selection is other than "PreQual"......

    Please provide some more details and someone will be happy to
    help...........

    Vaya con Dios,
    Chuck, CABGx3



    "ryan r" <ryanr@discussions.microsoft.com> wrote in message
    news:3E3B4443-0059-42E6-A6E5-B990C30B8118@microsoft.com...
    > I have an excel file with two different worksheets. On the 2nd worksheet

    I
    > have a Column labled "status," in which each cell has a dropbox with

    either
    > Pre-qual, Active, or TD as choices. The other columns all have client

    data.
    > Now, I need several cells of information from the row to move to certain
    > cells in the 1st worksheet when the "Pre-Qual" choice is picked on the
    > dropbox from the "Status" Column. Any help here would be appreciated
    >
    > -Thanks!
    > -Ryan




  3. #3
    ryan r
    Guest

    Re: How do I move certain Cell data from one worksheet to another?

    Well thanks for lookin into it I dont want anything to happen if one of
    the other two choices is picked. I simply need data from maybe 5 or 6 of the
    12 cells in each row to be copied into the other worksheet. One of the cells
    is a number, but all others are text.

    "CLR" wrote:

    > Hi Ryan........
    >
    > I'm afraid I would need a little more information to make any kind of
    > specific suggestion. There are so many options toward something like you
    > are taling about........ie:, linked cells, VLOOKUP formula, AutoFilter,
    > Macros, etc.........and you don't mention what, if anything you want to have
    > happen when the selection is other than "PreQual"......
    >
    > Please provide some more details and someone will be happy to
    > help...........
    >
    > Vaya con Dios,
    > Chuck, CABGx3
    >
    >
    >
    > "ryan r" <ryanr@discussions.microsoft.com> wrote in message
    > news:3E3B4443-0059-42E6-A6E5-B990C30B8118@microsoft.com...
    > > I have an excel file with two different worksheets. On the 2nd worksheet

    > I
    > > have a Column labled "status," in which each cell has a dropbox with

    > either
    > > Pre-qual, Active, or TD as choices. The other columns all have client

    > data.
    > > Now, I need several cells of information from the row to move to certain
    > > cells in the 1st worksheet when the "Pre-Qual" choice is picked on the
    > > dropbox from the "Status" Column. Any help here would be appreciated
    > >
    > > -Thanks!
    > > -Ryan

    >
    >
    >


  4. #4
    CLR
    Guest

    Re: How do I move certain Cell data from one worksheet to another?

    How big is your Sheet 2 database?...........how many "PreQuals", might one
    be expected to encounter......how often is this exercize performed?......is
    the target area a single block, or is the data expected to populate various
    cells, (such as).........
    Are you just wishing to view this data or does it integrate into some kind
    of a report?..........

    Vaya con Dios,
    Chuck, CABGx3




    "ryan r" <ryanr@discussions.microsoft.com> wrote in message
    news:1F99D7C4-E74A-41A2-B92A-454C247336B2@microsoft.com...
    > Well thanks for lookin into it I dont want anything to happen if one of
    > the other two choices is picked. I simply need data from maybe 5 or 6 of

    the
    > 12 cells in each row to be copied into the other worksheet. One of the

    cells
    > is a number, but all others are text.
    >
    > "CLR" wrote:
    >
    > > Hi Ryan........
    > >
    > > I'm afraid I would need a little more information to make any kind of
    > > specific suggestion. There are so many options toward something like

    you
    > > are taling about........ie:, linked cells, VLOOKUP formula, AutoFilter,
    > > Macros, etc.........and you don't mention what, if anything you want to

    have
    > > happen when the selection is other than "PreQual"......
    > >
    > > Please provide some more details and someone will be happy to
    > > help...........
    > >
    > > Vaya con Dios,
    > > Chuck, CABGx3
    > >
    > >
    > >
    > > "ryan r" <ryanr@discussions.microsoft.com> wrote in message
    > > news:3E3B4443-0059-42E6-A6E5-B990C30B8118@microsoft.com...
    > > > I have an excel file with two different worksheets. On the 2nd

    worksheet
    > > I
    > > > have a Column labled "status," in which each cell has a dropbox with

    > > either
    > > > Pre-qual, Active, or TD as choices. The other columns all have client

    > > data.
    > > > Now, I need several cells of information from the row to move to

    certain
    > > > cells in the 1st worksheet when the "Pre-Qual" choice is picked on the
    > > > dropbox from the "Status" Column. Any help here would be appreciated
    > > >
    > > > -Thanks!
    > > > -Ryan

    > >
    > >
    > >




  5. #5
    ryan r
    Guest

    Re: How do I move certain Cell data from one worksheet to another?

    The 2nd sheet database is small at the moment, but will grow to hundreds of
    entries; Each containing basic client and loan information. On average, 6
    of 10 entries will go to Pre-Qual. Anywhere from 0 to 15 new clients will be
    added to the 2nd worksheet a day.

    The 2nd worksheet has 12 Columns of data, 5 of which need to be moved to the
    1st worksheet when pre-qual is assigned. These are Contact, company, Loan
    amount, loan type, and finally just a simple link of the text Pre-qual.
    These columns are not in any specific order and do not coincide with any
    particular order on the first worksheet. This data simply needs to be viewed
    and recorded for various marketing and organization purposes. If you have
    time, or are simply in a good mood to help, my email is Rusden@gmail.com and
    I would be glad to send you the basic sheet so you can visually see what I am
    talking about. Again, thanks for your time.



    "CLR" wrote:

    > How big is your Sheet 2 database?...........how many "PreQuals", might one
    > be expected to encounter......how often is this exercize performed?......is
    > the target area a single block, or is the data expected to populate various
    > cells, (such as).........
    > Are you just wishing to view this data or does it integrate into some kind
    > of a report?..........
    >
    > Vaya con Dios,
    > Chuck, CABGx3
    >
    >
    >
    >
    > "ryan r" <ryanr@discussions.microsoft.com> wrote in message
    > news:1F99D7C4-E74A-41A2-B92A-454C247336B2@microsoft.com...
    > > Well thanks for lookin into it I dont want anything to happen if one of
    > > the other two choices is picked. I simply need data from maybe 5 or 6 of

    > the
    > > 12 cells in each row to be copied into the other worksheet. One of the

    > cells
    > > is a number, but all others are text.
    > >
    > > "CLR" wrote:
    > >
    > > > Hi Ryan........
    > > >
    > > > I'm afraid I would need a little more information to make any kind of
    > > > specific suggestion. There are so many options toward something like

    > you
    > > > are taling about........ie:, linked cells, VLOOKUP formula, AutoFilter,
    > > > Macros, etc.........and you don't mention what, if anything you want to

    > have
    > > > happen when the selection is other than "PreQual"......
    > > >
    > > > Please provide some more details and someone will be happy to
    > > > help...........
    > > >
    > > > Vaya con Dios,
    > > > Chuck, CABGx3
    > > >
    > > >
    > > >
    > > > "ryan r" <ryanr@discussions.microsoft.com> wrote in message
    > > > news:3E3B4443-0059-42E6-A6E5-B990C30B8118@microsoft.com...
    > > > > I have an excel file with two different worksheets. On the 2nd

    > worksheet
    > > > I
    > > > > have a Column labled "status," in which each cell has a dropbox with
    > > > either
    > > > > Pre-qual, Active, or TD as choices. The other columns all have client
    > > > data.
    > > > > Now, I need several cells of information from the row to move to

    > certain
    > > > > cells in the 1st worksheet when the "Pre-Qual" choice is picked on the
    > > > > dropbox from the "Status" Column. Any help here would be appreciated
    > > > >
    > > > > -Thanks!
    > > > > -Ryan
    > > >
    > > >
    > > >

    >
    >
    >


+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

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.05889 seconds
  • Memory Usage 8,946KB
  • Queries Executed 16 (?)
More Information
Template Usage (30):
  • (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
  • (5)memberaction_dropdown
  • (1)navbar
  • (4)navbar_link
  • (4)navbar_noticebit
  • (6)option
  • (5)postbit_legacy
  • (5)postbit_wrapper
  • (4)showthread_bookmarksite
  • (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 (40):
  • ./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
  • ./includes/functions_prefix.php 

Hooks Called (44):
  • 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
  • bbcode_parse_start
  • bbcode_parse_complete_precache
  • bbcode_parse_complete
  • postbit_display_complete
  • cache_templates
  • template_register_var
  • parse_templates
  • notices_check_start
  • notices_noticebit
  • process_templates_complete
  • memberaction_dropdown
  • tag_fetchbit_complete
  • forumrules
  • showthread_bookmarkbit
  • navbits
  • navbits_complete
  • showthread_complete


Search Engine Friendly URLs by vBSEO 3.6.0 RC 1