+ Reply to Thread
Results 1 to 3 of 3

VBA copy cells (not entire row) from Sheet1 onto Sheet2 if criteria is met upon entry

  1. #1
    Registered User
    Join Date
    04-01-2021
    Location
    Logan, Utah
    MS-Off Ver
    Microsoft 365
    Posts
    1

    VBA copy cells (not entire row) from Sheet1 onto Sheet2 if criteria is met upon entry

    This might be a simple problem and I've been scouring the internet, but I haven't quite found the solution yet. I have two sheets, "Master Parts List" is my master list with column B having the line number. What I want to do is manually enter the line number into column B in "Template" and have the data from the row with that same line number from "Master Parts List" in columns C,D,E,F,G,H,I,J,N,O,Q,R,S copied to "Template" in Columns C,D,E,F,G,H,I,J,K,L,M,N,O. I think some sort of VLookup will work, but I don't know enough about VBA to really know what the code should look like. I could input a formula into the cells on "Template", but I worry about the formula getting deleted by accident so I'd rather do a VBA code. Any help would be greatly appreciated!!

  2. #2
    Registered User
    Join Date
    03-10-2021
    Location
    Paryzevo
    MS-Off Ver
    2k3
    Posts
    20

    Re: VBA copy cells (not entire row) from Sheet1 onto Sheet2 if criteria is met upon entry

    Something like that ?
    (macro pasted in the vba module of the "Template" sheet)
    Please Login or Register  to view this content.

  3. #3
    Valued Forum Contributor
    Join Date
    07-14-2017
    Location
    Poland
    MS-Off Ver
    Office 2010
    Posts
    467

    Re: VBA copy cells (not entire row) from Sheet1 onto Sheet2 if criteria is met upon entry

    Give this a go...
    Code in the 'Template' sheet module.
    Please Login or Register  to view this content.
    Best Regards,
    Maras.

+ 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 to copy/paste from Sheet1 to Sheet2 if criteria is met
    By casper_01 in forum Excel Programming / VBA / Macros
    Replies: 6
    Last Post: 05-22-2020, 02:44 PM
  2. Replies: 14
    Last Post: 07-14-2019, 04:35 AM
  3. copy entire row from sheet1 into sheet2 matching ID and column header
    By dileepkmr319 in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 03-18-2018, 12:02 PM
  4. Insert a Copy of an Entire Row (including formatting) from Sheet2 to Sheet1
    By a99x1 in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 01-24-2016, 05:51 PM
  5. Replies: 6
    Last Post: 07-25-2013, 02:58 PM
  6. [SOLVED] Copy and Paste Entire Row from Sheet1->Sheet2 based on text string match in Sheet1 Row
    By dmlovic in forum Excel Programming / VBA / Macros
    Replies: 6
    Last Post: 05-17-2012, 08:42 AM
  7. Find random variable from sheet1, in sheet2, and copy entire row to sheet3
    By TMorville in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 08-12-2010, 06:27 AM

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

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1