+ Reply to Thread
Results 1 to 3 of 3

Item count and paste to another sheet

  1. #1
    Registered User
    Join Date
    07-10-2017
    Location
    Philippines
    MS-Off Ver
    MS OFFICE 2016
    Posts
    38

    Item count and paste to another sheet

    Hi guys,

    Can you help me modify my code here?
    So what I wanted to do here is, it should only list the columns which have filled color, not all columns regardless of change.
    But it only list the first if condition.

    i've also attached my workbook.

    Please Login or Register  to view this content.
    Attached Files Attached Files

  2. #2
    Forum Guru
    Join Date
    07-25-2011
    Location
    Florida
    MS-Off Ver
    Excel 2003
    Posts
    9,643

    Re: Item count and paste to another sheet

    Please Login or Register  to view this content.
    Surround your VBA code with CODE tags e.g.;
    [CODE]your VBA code here[/CODE]
    The # button in the forum editor will apply CODE tags around your selected text.

  3. #3
    Registered User
    Join Date
    07-10-2017
    Location
    Philippines
    MS-Off Ver
    MS OFFICE 2016
    Posts
    38

    Re: Item count and paste to another sheet

    Quote Originally Posted by AlphaFrog View Post
    Please Login or Register  to view this content.
    Works like a charm! thank you!

+ 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] Vba to match item description and copy/paste item code to other sheet
    By sintek in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 01-31-2017, 11:29 AM
  2. [SOLVED] VBA to count data in Column and paste the count in different sheet
    By shiva_reshs in forum Excel Programming / VBA / Macros
    Replies: 7
    Last Post: 07-02-2014, 03:54 PM
  3. [SOLVED] vlookup list in sheet2 and count from sheet how many times item is entered formula / vba
    By KK1234 in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 04-12-2014, 02:12 PM
  4. Combine Results from one work sheet to another with item count
    By jwbeaty in forum Excel Programming / VBA / Macros
    Replies: 5
    Last Post: 03-16-2012, 10:21 AM
  5. Replies: 2
    Last Post: 03-15-2012, 12:45 PM
  6. Macro: Count rows in sheet A, copy count in sheet B, paste offset in sheet A
    By Agent:Orange in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 01-19-2011, 07:56 AM
  7. [SOLVED] Auto copy/ paste on relevant work sheet when selecting list item
    By Niraj Manglam in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 06-06-2006, 10:15 AM

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