+ Reply to Thread
Results 1 to 10 of 10

how to paste next to the cell.....

  1. #1
    Registered User
    Join Date
    08-31-2013
    Location
    India
    MS-Off Ver
    Excel 2007
    Posts
    51

    how to paste next to the cell.....

    Hey guys ,

    i have atteched a file..and also i have written the vba code..

    i want from sheet1 data if am copying and pasting into sheet2...

    if sheet1 a1 to Sheet2 a1
    sheet1 a2 to sheet2 a2

    but

    sheet1 a4 is blank and a5 has text then a5 shoud copy into Sheet2 a4 (need the code )

    thank you
    Attached Files Attached Files

  2. #2
    Forum Expert
    Join Date
    04-22-2013
    Location
    .
    MS-Off Ver
    .
    Posts
    4,418

    Re: how to paste next to the cell.....

    Please Login or Register  to view this content.

  3. #3
    Registered User
    Join Date
    08-31-2013
    Location
    India
    MS-Off Ver
    Excel 2007
    Posts
    51

    Re: how to paste next to the cell.....

    with out offset function is there any way to wright ????????????

  4. #4
    Forum Expert
    Join Date
    04-22-2013
    Location
    .
    MS-Off Ver
    .
    Posts
    4,418

    Re: how to paste next to the cell.....

    Please Login or Register  to view this content.

  5. #5
    Registered User
    Join Date
    08-31-2013
    Location
    India
    MS-Off Ver
    Excel 2007
    Posts
    51

    Re: how to paste next to the cell.....

    k...thank you one more doubt sorry.....if more than one colum is there means

    sh1 a1,b1,c1 should copy to sh2 a1,b1,c2

    if sh1 a2,b2,c2 blank then s
    sh1 a3,b3,c3 to sh2 a2,b2,c2 .......with out offset function

  6. #6
    Forum Expert
    Join Date
    04-22-2013
    Location
    .
    MS-Off Ver
    .
    Posts
    4,418

    Re: how to paste next to the cell.....

    Please Login or Register  to view this content.
    Last edited by Leith Ross; 11-12-2013 at 12:33 PM. Reason: Added Code Tags

  7. #7
    Registered User
    Join Date
    08-31-2013
    Location
    India
    MS-Off Ver
    Excel 2007
    Posts
    51

    Re: how to paste next to the cell.....

    hey if the total row of sh1 is blank and next row shoud copy to sh2 then what kind of code i need to right beacause my concern is if sh1 a10 row is blank
    then sh1 a11 row shoud copy sh2 a9

  8. #8
    Forum Expert
    Join Date
    04-22-2013
    Location
    .
    MS-Off Ver
    .
    Posts
    4,418

    Re: how to paste next to the cell.....

    Sorry I missed a bracket:
    Please Login or Register  to view this content.

  9. #9
    Forum Expert
    Join Date
    04-22-2013
    Location
    .
    MS-Off Ver
    .
    Posts
    4,418

    Re: how to paste next to the cell.....

    The alternative is to copy everything and then delete blank rows
    Please Login or Register  to view this content.

  10. #10
    Registered User
    Join Date
    08-31-2013
    Location
    India
    MS-Off Ver
    Excel 2007
    Posts
    51

    Re: how to paste next to the cell.....

    thank you...i wil do it in my main file if i get any error i will ask you...no problem right???????????????

+ 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 cell A1 and paste value into B1 if B1 has content, paste to B2...etc
    By mhopke in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 12-09-2012, 09:39 PM
  2. Replies: 4
    Last Post: 05-30-2011, 02:06 PM
  3. Replies: 4
    Last Post: 03-27-2005, 09:06 PM
  4. Copy and Paste macro needs to paste to a changing cell reference
    By loulou in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 02-24-2005, 07:06 AM
  5. Replies: 11
    Last Post: 01-13-2005, 07:06 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