Results 1 to 10 of 10

Data Copy from one sheet and paste special in another sheet

Threaded View

  1. #1
    Forum Contributor
    Join Date
    05-14-2010
    Location
    India
    MS-Off Ver
    Excel 2007
    Posts
    155

    Data Copy from one sheet and paste special in another sheet

    Dear Experts,
    Please find attached file and help for code as per the following query: -

    Sheet Tab - FORM
    Cell I10 = Project (Integration Feed or Well Pads)
    Cell I12 = Numbers of Document being request (maximum 100 document can be request in one form)

    Based on the cell value I12, Blank Rows are hiding from H23:H122

    Once the "Submit Request" Button Clicked in the FORM tab, data should copy and paste special value in the Sheet Tab "Log Sheet"
    Data should copy from "FORM" sheet Range D23 to K122 (filled cell only, not hidden row should coppy) in to next blank row of sheet "Log Sheet" B to I (Paste Special)

    Thanks in advance.
    Attached Files Attached Files
    Rajeev Kumar

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. Copy Filtered column data and Paste Special Values to another sheet
    By mr_newbie in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 03-04-2016, 11:39 AM
  2. Replies: 2
    Last Post: 03-18-2015, 05:31 AM
  3. VBA script problem - Copy and Paste Special data from one sheet to another.
    By akarev in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 03-05-2013, 12:19 PM
  4. [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
  5. Copy/Paste special form one sheet to another into first open colum
    By GeorgeD in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 05-28-2010, 05:50 PM
  6. Replies: 0
    Last Post: 05-24-2010, 05:17 PM
  7. [SOLVED] Create new sheet from cell-info and then copy/paste special
    By Ingve in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 01-19-2006, 07:00 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