+ Reply to Thread
Results 1 to 2 of 2

Copy select data from one sheet to another?

  1. #1
    Registered User
    Join Date
    10-24-2017
    Location
    London
    MS-Off Ver
    2007, 2016 and 2019 Professional
    Posts
    11

    Copy select data from one sheet to another?

    Hi all,

    I would really appreciate some direction / help / solution with this "probably simple" problem.

    The details are:

    Spreadsheet with 10 columns.
    Important data in columns 1 to 4 and 10.
    Quantities in column 10 - move only rows where the quantity is greater than zero (>0).

    Requirements

    Copy important data (columns 1 to 4) and quantities greater than zero ( >0 ) (column 10) and paste onto columns 1 to 5 on a second spreadsheet.

    Is this possible? I have limited understanding of VBA and after watching a Youtube video typed out the code below which simply selects the cell in the second sheet. It is supposed to do that but also copy the data over at the same time alas no.

    Please Login or Register  to view this content.
    Last edited by Togora; 05-01-2019 at 02:04 PM. Reason: Forgot to add that data is required to be copied and pasted to the second sheet. Sorry! Oh! And I forgot to add code tags it seems. Another sorry.

  2. #2
    Forum Moderator alansidman's Avatar
    Join Date
    02-02-2010
    Location
    Steamboat Springs
    MS-Off Ver
    MS Office 365 Win 11 Home 64 Bit
    Posts
    21,469

    Re: Copy select data from one sheet to another?

    Administrative Note:

    Welcome to the forum.

    We would very much like to help you with your query, however you need to include code tags around your code.

    Please take a moment to add the tags. Posting code between [CODE]Please [url=https://www.excelforum.com/login.php]Login or Register [/url] to view this content.[/CODE] tags makes your code much easier to read and copy for testing, and it also maintains VBA formatting.

    Click on Edit to open your post, then highlight your code and click the # icon at the top of your post window. More information about these and other tags can be found here

    (Note: this change is not optional. No help to be offered until this moderation request has been fulfilled.)
    Alan


    Have you debugged your code?
    Database Normalization
    Complete Guide to Power Query
    Man's Mind Stretched to New Dimensions Never Returns to Its Original Form

+ 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. VBA code to move data from a entry sheet to a historical sheet by date
    By rlh in forum Excel Programming / VBA / Macros
    Replies: 5
    Last Post: 04-17-2014, 07:15 PM
  2. [SOLVED] Move coulumns data of a sheet to diff other columns of other sheet in same workbook
    By ROHAN999 in forum Excel Programming / VBA / Macros
    Replies: 16
    Last Post: 09-03-2013, 09:22 AM
  3. Replies: 2
    Last Post: 05-27-2013, 11:21 PM
  4. Split Data Unique Value From 2 Sheet of A column and Move to 2 Sheet with Splited Values
    By breadwinner in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 05-21-2013, 04:21 AM
  5. Move entire row of data from Sheet 1 to sheet 2 when completed date is entered.
    By jt7721 in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 05-18-2013, 11:50 AM
  6. VBA CODE to move rows from one sheet(1) to another sheet(2) based on data in cell
    By fozzieulo in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 05-08-2013, 02:43 PM
  7. [SOLVED] Move rows of data from one sheet to another based on specific values of sheet
    By buntalan80 in forum Excel Programming / VBA / Macros
    Replies: 9
    Last Post: 02-26-2013, 06:21 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