+ Reply to Thread
Results 1 to 2 of 2

Vba to copy and paste only specific cells to a new sheet

  1. #1
    Forum Guru Sintek's Avatar
    Join Date
    12-04-2015
    Location
    Cape Town
    MS-Off Ver
    O365 V2408
    Posts
    15,156

    Vba to copy and paste only specific cells to a new sheet

    Hi All

    I have the below code which needs some tweaking to allow for the desired result displayed in my attached file.
    Sheets("BP") will give the result of current code when macro button is pressed
    Sheets("BP result wanted") is what I am trying to achieve.....Can any one assist....pretty please.
    Please Login or Register  to view this content.
    Attached Files Attached Files

  2. #2
    Forum Guru Sintek's Avatar
    Join Date
    12-04-2015
    Location
    Cape Town
    MS-Off Ver
    O365 V2408
    Posts
    15,156

    Re: Vba to copy and paste only specific cells to a new sheet

    K, I've managed to get close but still no cigar
    Changed this
    Please Login or Register  to view this content.
    to this
    Please Login or Register  to view this content.
    Now it populates from 3 row and not 5th as desired

+ 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 & Paste specific cells to a summary sheet
    By JackSmith123 in forum Excel Programming / VBA / Macros
    Replies: 5
    Last Post: 05-27-2016, 02:08 AM
  2. [SOLVED] Copy only specific cells contents to another sheet and paste at the bottom of a column
    By markDuffy in forum Excel Programming / VBA / Macros
    Replies: 7
    Last Post: 08-21-2015, 06:43 AM
  3. Replies: 6
    Last Post: 10-29-2014, 06:00 AM
  4. copy a range of cells N times and paste in separate sheet and also change a specific colum
    By maramkarthik in forum Excel Programming / VBA / Macros
    Replies: 5
    Last Post: 09-21-2013, 04:27 AM
  5. Copy specific data from differint cells and paste in one sheet
    By cyberzard in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 05-14-2013, 02:25 AM
  6. Copy active row and paste to specific cells on different sheet
    By XxCMoneyxX in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 02-27-2013, 03:03 PM
  7. [SOLVED] Copy and paste data from sheet 2 to sheet 1 based on specific criteria on sheet 1
    By VBADUD in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 12-05-2012, 04:18 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