+ Reply to Thread
Results 1 to 7 of 7

Can I move selected data?

  1. #1
    Registered User
    Join Date
    09-14-2015
    Location
    Philippines
    MS-Off Ver
    2010
    Posts
    15

    Can I move selected data?

    Hi! I am new in using excel.I want to move selected data to my another excel file "database2" from "database1". But I only want to automatically transfer the data if it is mark as "approved". Is that possible?

  2. #2
    Forum Guru Kaper's Avatar
    Join Date
    12-14-2013
    Location
    Warsaw, Poland
    MS-Off Ver
    most often: Office 365 in Windows environment
    Posts
    8,609

    Re: Can I move selected data?

    Yes, it is. But not necesserily just with "Excel Formulas & Functions", especially if you really need automatic data transfer.

    2 main options are:
    - Standard macro to filter approved and move filtered data to second sheet, or
    - Worksheet_Change event handler to move approved data as soon as approval column has been updated.

    You can find samples of similar procedures on the forum using http://www.excelforum.com/search.php
    Best Regards,

    Kaper

  3. #3
    Forum Expert
    Join Date
    03-20-2015
    Location
    Primarily UK, sometimes NL
    MS-Off Ver
    Work: Office 365 / Home: Office 2010
    Posts
    2,405

    Re: Can I move selected data?

    Hi, welcome to the forum.

    A macro would be able to check 'database2' for 'approved' data and automatically move it across, but the VBA experts on here would need some more detail first (which columns, etc).

    Less automatically, it is possible to filter the data to show just 'approved' so that you can then copy-paste the data yourself.
    In 'database1', select all the data (including header columns) then go to the 'Data' tab and select 'Filter'. You'll see little arrows appear beside each column header. Click the one in the column where you have 'approved' then select only 'approved'. This will hide all the rows which do not contain 'approved' in this column.
    Now click and drag to select all the rows left visible, press Ctrl-C to copy, go to 'database2', click the top left cell of where you want the data to go and press Ctrl-V to paste - only the filtered data will be pasted.
    If you want to remove this data from 'database1', you can then go back and delete those rows (or you could use Ctrl-X to cut instead of Ctrl-C to copy).

    Is that of any help?

    Regards,
    Aardigspook

    If your problem is solved, please go to 'Thread Tools' above your first post and 'Mark Thread as Solved'.
    You don't need to give me rep if I helped, but thanks are appreciated.

  4. #4
    Registered User
    Join Date
    09-14-2015
    Location
    Philippines
    MS-Off Ver
    2010
    Posts
    15

    Re: Can I move selected data?

    Thank You for your replies.I want to automatically copy the selected data even it is not marked as "approved" in "database2" once I encoded or updated the details in "database1",
    so that I don't need to "copy and paste" every time I update the "database1"
    I hope this attachment will clarify my problem.
    Attached Files Attached Files

  5. #5
    Forum Guru Kaper's Avatar
    Join Date
    12-14-2013
    Location
    Warsaw, Poland
    MS-Off Ver
    most often: Office 365 in Windows environment
    Posts
    8,609

    Re: Can I move selected data?

    To me it looks like a quite different question than the original one. But here is the solution to post #4:

    Please Login or Register  to view this content.
    Attached Files Attached Files

  6. #6
    Registered User
    Join Date
    09-14-2015
    Location
    Philippines
    MS-Off Ver
    2010
    Posts
    15

    Re: Can I move selected data?

    Hi! This really solved my problem. Can this code also be used if i want to transfer the data in different excel file?

    Thank You!

  7. #7
    Forum Guru Kaper's Avatar
    Join Date
    12-14-2013
    Location
    Warsaw, Poland
    MS-Off Ver
    most often: Office 365 in Windows environment
    Posts
    8,609

    Re: Can I move selected data?

    of course use your file name and path

    Please Login or Register  to view this content.

+ 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] Move selected row up or down with a command button
    By allwrighty in forum Excel Programming / VBA / Macros
    Replies: 8
    Last Post: 06-07-2016, 08:13 AM
  2. [SOLVED] Macro to move selected cells in a data base
    By nico125 in forum Excel Programming / VBA / Macros
    Replies: 5
    Last Post: 11-13-2013, 11:12 AM
  3. Move selected columns data from UserForms listbox to different ranges in Worksheet
    By oxicottin in forum Excel Programming / VBA / Macros
    Replies: 9
    Last Post: 01-25-2013, 10:37 AM
  4. [SOLVED] Move data from SHEET1 to SHEET2 based on Selected criteria...like an adv filter
    By gspivey79 in forum Excel Formulas & Functions
    Replies: 9
    Last Post: 10-03-2012, 02:06 PM
  5. [SOLVED] Move selected cells to previous row
    By pmolsen in forum Excel General
    Replies: 6
    Last Post: 08-31-2012, 11:14 PM
  6. Move listbox to selected row
    By enphynity in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 11-03-2011, 10:49 AM
  7. Move Only Selected Data Frm 1 Sheet 2 other Existin Workbooks 1st Avaliable Empty ROW
    By xcruc1at3r in forum Excel Programming / VBA / Macros
    Replies: 12
    Last Post: 08-09-2011, 06:46 PM
  8. [SOLVED] highlight selected row permanently until u move out from the row
    By nwhan in forum Excel General
    Replies: 5
    Last Post: 06-02-2005, 09:05 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