+ Reply to Thread
Results 1 to 8 of 8

Macro to copy table from sheet1 to sheet2 (qty of rows may vary)

  1. #1
    Registered User
    Join Date
    02-17-2014
    Location
    almaty
    MS-Off Ver
    Excel 2003
    Posts
    13

    Macro to copy table from sheet1 to sheet2 (qty of rows may vary)

    Hi!! can u pls help!!!
    I need to copy table from sheet1 to sheet2
    horizon B14:F23 (qty of rows may vary depending on the amount of inputs from customer)

    expected result: table copied to sheet2 with exact amount of rows as in sheet1 (i.e. macro inserts more rows if needed & inserts the table from sheet1)


    thank uuuu
    Last edited by arkharova.s; 02-18-2014 at 03:53 AM. Reason: wrong title of the post

  2. #2
    Forum Moderator Fotis1991's Avatar
    Join Date
    10-11-2011
    Location
    Athens(The homeland of the Democracy!). Greece
    MS-Off Ver
    Excel 1997!&2003 & 2007&2010
    Posts
    13,744

    Re: Macro to hide rows containing #N/A

    Your title says that you want to hide rows.....

    Your text says that you want to copy cells...

    Finally what do you need to do?
    Regards

    Fotis.

    -This is my Greek whisper to Europe.

    --Remember, saying thanks only takes a second or two. Click the little star * below, to give some Rep if you think an answer deserves it.

    Advanced Excel Techniques: http://excelxor.com/

    --KISS(Keep it simple Stupid)

    --Bring them back.

    ---See about Acropolis of Athens.

    --Visit Greece.

  3. #3
    Forum Expert
    Join Date
    06-12-2012
    Location
    Ridgefield Park, New Jersey
    MS-Off Ver
    Excel 2003,2007,2010
    Posts
    10,241

    Re: Macro to hide rows containing #N/A

    Duplicate post:

    http://www.excelforum.com/excel-prog...ining-n-a.html

  4. #4
    Registered User
    Join Date
    06-27-2012
    Location
    Estonia
    MS-Off Ver
    Excel 2007
    Posts
    49

    Re: Macro to hide rows containing #N/A

    Hi
    Id use a do or For cycle & then if to find rows where is #N/A

    Please Login or Register  to view this content.

  5. #5
    Forum Moderator Fotis1991's Avatar
    Join Date
    10-11-2011
    Location
    Athens(The homeland of the Democracy!). Greece
    MS-Off Ver
    Excel 1997!&2003 & 2007&2010
    Posts
    13,744

    Re: Macro to hide rows containing #N/A

    Quote Originally Posted by JOHN H. DAVIS View Post
    I think thar OP used by mistake the same title as in his other thread. In this thread the describtion of what he wants to do is different....Let's wait for a while...

  6. #6
    Registered User
    Join Date
    02-17-2014
    Location
    almaty
    MS-Off Ver
    Excel 2003
    Posts
    13

    Re: Macro to hide rows containing #N/A

    dears, my apologizes for misleading u, i was opennig 2 threads simultaneously, & used the same subject for different questions.
    my 1st qs on : marco to hide rows containing #N/A was answered by 2 members, both options work great! thank u all!
    my open qs: i want to copy table from sheet1 to sheet2 via macro; amount of rows in table sheet1 may vary depending on # of requests from customers. Current horizon is B14:F23 (but it may change to F27,50,150 etc). So, macro should copy this table to sheet 2 & insert/delete rows if needed, i.e. make exactly the same amount of rows as in sheet1.
    Hope it clarifies

    thank uu, awiaiting for ur responses!!!!

  7. #7
    Forum Moderator Fotis1991's Avatar
    Join Date
    10-11-2011
    Location
    Athens(The homeland of the Democracy!). Greece
    MS-Off Ver
    Excel 1997!&2003 & 2007&2010
    Posts
    13,744

    Re: Macro to hide rows containing #N/A

    To change a Title on your post, click EDIT then Go Advanced and change your title, if 2 days have passed ask a moderator to do it for you.

  8. #8
    Registered User
    Join Date
    02-17-2014
    Location
    almaty
    MS-Off Ver
    Excel 2003
    Posts
    13

    Re: Macro to hide rows containing #N/A

    Hi Fotis1991,
    done, thanks for ur help!

+ 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. Need help creating macro to hide rows based upon whether 1 of 3 rows have data
    By BigEdJr in forum Excel Programming / VBA / Macros
    Replies: 13
    Last Post: 01-17-2014, 02:58 PM
  2. Replies: 0
    Last Post: 05-10-2013, 12:04 PM
  3. Using check boxes to hide and un-hide rows with drop down lists within rows
    By Sparky_Chris in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 06-24-2012, 07:22 AM
  4. Macro to Hide and Unhide Rows but still be able to insert rows
    By majasmi in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 03-01-2011, 09:25 PM
  5. Hide Rows Macro
    By andersenterp in forum Excel General
    Replies: 2
    Last Post: 05-08-2009, 09:53 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