+ Reply to Thread
Results 1 to 4 of 4

Copy and paste data according count greater then 0(zero) of column w

  1. 04-29-2014, 07:16 AM #1
    HaroonSid
    HaroonSid is offline
    Forum Contributor HaroonSid's Avatar
    Join Date
    02-28-2014
    Location
    india
    MS-Off Ver
    Excel 2013
    Posts
    2,080

    Copy and paste data according count greater then 0(zero) of column w

    hello
    i musing below formula to copy paste data

    i want counta formula only count from range W4:W53 which is greater then 0(zero)

    Please Login or Register  to view this content.
    Reply With QuoteRegister To Reply
  2. 04-29-2014, 07:42 AM #2
    sktneer
    sktneer is offline
    Forum Guru sktneer's Avatar
    Join Date
    04-30-2011
    Location
    Kanpur, India
    MS-Off Ver
    Office 365
    Posts
    9,648

    Re: Copy and paste data according count greater then 0(zero) of column w

    Change this line of code.....

    Please Login or Register  to view this content.
    Regards
    sktneer

    Treat people the way you want to be treated. Talk to people the way you want to be talked to.
    Respect is earned NOT given.
    Reply With QuoteRegister To Reply
  3. 04-29-2014, 07:47 AM #3
    HaroonSid
    HaroonSid is offline
    Forum Contributor HaroonSid's Avatar
    Join Date
    02-28-2014
    Location
    india
    MS-Off Ver
    Excel 2013
    Posts
    2,080

    Re: Copy and paste data according count greater then 0(zero) of column w

    THANX sktneer

    works perfect

    +1 will add u
    Reply With QuoteRegister To Reply
  4. 04-29-2014, 07:49 AM #4
    sktneer
    sktneer is offline
    Forum Guru sktneer's Avatar
    Join Date
    04-30-2011
    Location
    Kanpur, India
    MS-Off Ver
    Office 365
    Posts
    9,648

    Re: Copy and paste data according count greater then 0(zero) of column w

    You're welcome.
    Reply With QuoteRegister To Reply
+ Reply to Thread
« Previous Thread | Next Thread »

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. VBA to copy data from a column with number greater than zero...???
    By CarJon0767 in forum Excel Programming / VBA / Macros
    Replies: 6
    Last Post: 06-12-2013, 10:57 PM
  2. Count ID numbers - Cut & Paste any greater than a certain number
    By WCE_123 in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 05-03-2013, 07:30 PM
  3. Vba - find next empty column, insert column, copy paste values & copy paste formulas
    By DoodlesMama in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 12-20-2012, 12:43 PM
  4. [SOLVED] Trying to count cells greater than # in one column if another column meets criteria
    By lorne17 in forum Excel Formulas & Functions
    Replies: 7
    Last Post: 08-14-2012, 07:01 PM
  5. Macro to copy and paste special values for column data and filter column data
    By ascottbag in forum Excel Programming / VBA / Macros
    Replies: 9
    Last Post: 03-10-2012, 02:15 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

Forum Rules


Search Engine Friendly URLs by vBSEO 3.6.0 RC 1