+ Reply to Thread
Results 1 to 5 of 5

Copy cell range from “input sheet” to “output sheet”

  1. #1
    Forum Contributor
    Join Date
    06-08-2012
    Location
    BD
    MS-Off Ver
    Microsoft Office 2016
    Posts
    640

    Copy cell range from “input sheet” to “output sheet”

    Dear all, I am having two sheet ,need to copy particular data range of
    “input sheet” and past to “output sheet “ conditionally . here my
    data range of input sheet is A1:E8, F1:J8,K1:O8 . this range need to
    past to the output sheet in the column rage A:E , I have attached my
    excel sheet & also shown the color mark cell range that need to be
    done ..
    Attached Files Attached Files

  2. #2
    Forum Expert
    Join Date
    03-28-2012
    Location
    TBA
    MS-Off Ver
    Office 365
    Posts
    12,454

    Re: Copy cell range from “input sheet” to “output sheet”

    I am not sure if the attached what you wanted. Why can not you copy the range manually?
    Attached Files Attached Files

  3. #3
    Forum Contributor
    Join Date
    06-08-2012
    Location
    BD
    MS-Off Ver
    Microsoft Office 2016
    Posts
    640

    Re: Copy cell range from “input sheet” to “output sheet”

    Hi AB33, Thanks for replay , what you did that is absolutely correct. i am sorry, i forgot to mention that the data range is not fixed upto K1:O8. manually copy not possible as it will take 4 to 5 hours to complete my whole reports , please treat the data range form column A to column XFD .. please use last column range logic (we always use as "data range as last row" )..

  4. #4
    Forum Expert
    Join Date
    03-28-2012
    Location
    TBA
    MS-Off Ver
    Office 365
    Posts
    12,454

    Re: Copy cell range from “input sheet” to “output sheet”

    I am assuming the number of columns to be copied are 5 at a time.
    Attached Files Attached Files
    Last edited by AB33; 11-23-2014 at 01:44 PM.

  5. #5
    Forum Contributor
    Join Date
    06-08-2012
    Location
    BD
    MS-Off Ver
    Microsoft Office 2016
    Posts
    640

    Re: Copy cell range from “input sheet” to “output sheet”

    Hi AB33, yes it works perfectly ! it will save my many hours. I really appreciate your nice job. I am happy now… Thanks for your valuable time in this regards .

+ 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] Desire data segregate from “input” sheet to “output “sheet
    By nur2544 in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 07-24-2014, 07:10 AM
  2. [SOLVED] Desire data extract from the sheet “input” to the sheet “output”
    By nur2544 in forum Excel Programming / VBA / Macros
    Replies: 18
    Last Post: 06-24-2014, 02:19 PM
  3. 2 Sheets - Input Sheet & Output Sheet - Find unique number and add value to a column
    By bebongtheshark in forum Excel Programming / VBA / Macros
    Replies: 8
    Last Post: 05-16-2014, 01:23 AM
  4. Macro to input value, copy output, paste it to another sheet
    By Settler7 in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 09-18-2013, 10:08 PM
  5. [SOLVED] How to retrieve desire text from input sheet to output sheet ?
    By nur2544 in forum Excel Programming / VBA / Macros
    Replies: 11
    Last Post: 02-12-2013, 06:13 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