+ Reply to Thread
Results 1 to 6 of 6

copy range A4:A100 and paste on another workbook's sheet but one by one

  1. #1
    Forum Contributor HaroonSid's Avatar
    Join Date
    02-28-2014
    Location
    india
    MS-Off Ver
    Excel 2013
    Posts
    1,997

    copy range A4:A100 and paste on another workbook's sheet but one by one

    hello
    i want to copy a range of sheets("name").range("a4:a100) and paste on another workbook sheets("name").range("a4:a100"), but one by one
    e.g

    sheets("name").range("A4:A100).copy
    and paste new workbook with
    sheets("name").range("A4:A100")
    first paste a4
    secondly paste a5
    third paste a6
    forth paste a7
    ....paste a100

    thanx

  2. #2
    Forum Contributor
    Join Date
    02-28-2012
    Location
    London, England
    MS-Off Ver
    Excel 2003, 2007, 2010
    Posts
    187

    Re: copy range A4:A100 and paste on another workbook's sheet but one by one

    Use a loop replacing (1-100) with 'i'.

    What are the reasons behind doing it this way as opposed to in one block?

  3. #3
    Forum Contributor HaroonSid's Avatar
    Join Date
    02-28-2014
    Location
    india
    MS-Off Ver
    Excel 2013
    Posts
    1,997

    Re: copy range A4:A100 and paste on another workbook's sheet but one by one

    Hello TKCZBW

    i m using below code worksheet change event on my sheets("TO.")
    what does below code?
    when i enter a value in C4 then this generate auto formulas for me, but if i paste here data in range then this is giving a debug and formulas are not generating, so i want to paste here one by one entry,.....plz provide a code with loop
    thanx
    Please Login or Register  to view this content.

  4. #4
    Forum Contributor
    Join Date
    02-28-2012
    Location
    London, England
    MS-Off Ver
    Excel 2003, 2007, 2010
    Posts
    187

    Re: copy range A4:A100 and paste on another workbook's sheet but one by one

    In brief . . .

    Please Login or Register  to view this content.

  5. #5
    Forum Contributor HaroonSid's Avatar
    Join Date
    02-28-2014
    Location
    india
    MS-Off Ver
    Excel 2013
    Posts
    1,997

    Re: copy range A4:A100 and paste on another workbook's sheet but one by one

    sorry TKCZBW
    i m not able to make full code
    plz make full code with range

    copy = sheets("to.").range("c4:c34")
    and
    paste = sheets("to.").range("c4:c34")

  6. #6
    Forum Contributor
    Join Date
    02-28-2012
    Location
    London, England
    MS-Off Ver
    Excel 2003, 2007, 2010
    Posts
    187

    Re: copy range A4:A100 and paste on another workbook's sheet but one by one

    Sorry, that's really a separate question to your initial one, but it is answered above as well. I cannot make the full code, as I cannot fuly understand the code you have already written in terms of what you want it to achieve and what results you expect.

    Select the range as I have described above and then copy. Then select your landing range, in the same way as your 'from' range. then selection.paste.

+ 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. Replies: 6
    Last Post: 03-26-2014, 11:40 PM
  2. Copy same range from multiple sheets and paste into one sheet of active workbook
    By jadown in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 10-15-2013, 01:41 PM
  3. [SOLVED] when updating sheet1 a1:a100, auto updates sheet2 a1:a100.
    By chestersneakers7 in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 03-15-2013, 08:09 AM
  4. [SOLVED] Prvent Duplicates in Range A2:A100 while coping in to another sheet
    By vaibhav2312 in forum Excel Programming / VBA / Macros
    Replies: 13
    Last Post: 08-21-2012, 09:22 AM
  5. Copy A Range of Cells Or Sheet and Paste to A New Workbook
    By Nathan123 in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 11-21-2007, 09:24 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