+ Reply to Thread
Results 1 to 7 of 7

Copy data from certain cells automatically and then delete the data from 1st worksheet

  1. #1
    Registered User
    Join Date
    10-09-2013
    Location
    Netherlands
    MS-Off Ver
    Excel 2003
    Posts
    10

    Copy data from certain cells automatically and then delete the data from 1st worksheet

    Hi I am new and i don't know much about macro's yet. Sorry for my grammar.

    I would like to import some date from a website. This i do manually (just copy paste). Then i would like to copy certain cells from this worksheet (1st worksheet) to other cells in another worksheet (2nd worksheet), so that i would only have the data i need and i would have my own lay-out. Finally i should be able to delete the imported data without this having an influence on the 2nd worksheet. I would like that excel does this automatically after i paste the imported data in my excel.

    Explanation:

    - cell C9 in 1st worksheet has a certain value.
    - column A in 2nd worksheet contains values of the same kind as cell C9 in 1st worksheet
    - A particular cell in column A from the 2nd worksheet has the exact same value as C9 in 1st worksheet.
    - Data from some cells in 1st worksheet (let's say:B3, G8, G9, F3) should be autmotically copied to certain cells in the relevant row in the 2nd worksheet
    - Data in 1st worksheet can now be deleted.
    - 2nd worksheets keeps this data.

    Thanks in advance

  2. #2
    Forum Expert OllieB's Avatar
    Join Date
    12-20-2012
    Location
    Netherlands
    MS-Off Ver
    Excel 2007 (home) & 2010 (office)
    Posts
    1,542

    Re: Copy data from certain cells automatically and then delete the data from 1st worksheet

    Hi Bill,

    Please copy the below routine in the worksheet module of the worksheet where you are pasting the information - you will need to correct the name of the second worksheet (target for copy) and the cells being monitored (pasted into) and being copied

    Please Login or Register  to view this content.
    If you like my contribution click the star icon!

  3. #3
    Registered User
    Join Date
    10-09-2013
    Location
    Netherlands
    MS-Off Ver
    Excel 2003
    Posts
    10

    Re: Copy data from certain cells automatically and then delete the data from 1st worksheet

    i will look into it. Thanks!

  4. #4
    Registered User
    Join Date
    10-09-2013
    Location
    Netherlands
    MS-Off Ver
    Excel 2003
    Posts
    10

    Re: Copy data from certain cells automatically and then delete the data from 1st worksheet

    It doesn't work. Is it because i have a dutch version of excel?

    Also i have changed the cell names to test and simplify the code. The 2nd worksheet is called 'Objecten'

    Please Login or Register  to view this content.

  5. #5
    Forum Expert OllieB's Avatar
    Join Date
    12-20-2012
    Location
    Netherlands
    MS-Off Ver
    Excel 2007 (home) & 2010 (office)
    Posts
    1,542

    Re: Copy data from certain cells automatically and then delete the data from 1st worksheet

    Bill,

    Ducth version has nothing to do with it. I copied the your revised code into an empty workbook under worksheet Sheet1. I then renamed worksheet Sheet2 to "Objecten" and entered values in cells F3 and N13 on worksheet Sheet3. When I copy the range A1:N13 from Sheet3 to Sheet1, the routine gets triggered and copies the value of N13 to column W on worksheets Objecten.

    I believe this is exactly what you asked for. Please see attached test workbook
    Attached Files Attached Files

  6. #6
    Registered User
    Join Date
    10-09-2013
    Location
    Netherlands
    MS-Off Ver
    Excel 2003
    Posts
    10

    Re: Copy data from certain cells automatically and then delete the data from 1st worksheet

    I got it. You're a boss! thanks man!

  7. #7
    Forum Expert OllieB's Avatar
    Join Date
    12-20-2012
    Location
    Netherlands
    MS-Off Ver
    Excel 2007 (home) & 2010 (office)
    Posts
    1,542

    Re: Copy data from certain cells automatically and then delete the data from 1st worksheet

    You are welcome. Please feel free to click on the star icon ("Add Reputation") if you are happy with my contribution.

+ 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] Copy row of data, paste in another worksheet, delete some of the cells copied
    By dev111ski in forum Excel Programming / VBA / Macros
    Replies: 9
    Last Post: 07-14-2012, 05:58 PM
  2. automatically copy data from one worksheet to another
    By LC in forum Excel Formulas & Functions
    Replies: 0
    Last Post: 09-06-2005, 12:05 PM
  3. automatically copy data from one worksheet to another
    By Dave Peterson in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 09-06-2005, 11:05 AM
  4. [SOLVED] automatically copy data from one worksheet to another
    By LC in forum Excel Formulas & Functions
    Replies: 0
    Last Post: 09-06-2005, 12:05 AM
  5. [SOLVED] automatically copy data from one worksheet to another
    By LC in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 07-22-2005, 11: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