+ Reply to Thread
Results 1 to 8 of 8

VBA to count data in Column and paste the count in different sheet

  1. #1
    Forum Contributor
    Join Date
    07-17-2012
    Location
    India
    MS-Off Ver
    Excel 2007, 2010
    Posts
    657

    VBA to count data in Column and paste the count in different sheet

    Hello,

    I need help in VBA which would count data in Column F of dump Sheet and paste the count in master sheet B2 Cell.
    Please advice.

    Thanks,
    Shiva
    Keep the Forum clean :


    1. Use [ code ] code tags [ /code ]. It keeps posts clean, easy-to-read, and maintains VBA formatting.
    2. Show appreciation to those who have helped you by clicking * Add Reputation below their posts.
    3. If you are happy with a solution to your problem, mark the thread as [SOLVED] using the tools at the top.

  2. #2
    Forum Moderator Richard Buttrey's Avatar
    Join Date
    01-14-2008
    Location
    Stockton Heath, Cheshire, UK
    MS-Off Ver
    Office 365, Excel for Windows 2010 & Excel for Mac
    Posts
    27,782

    Re: VBA to count data in Column and paste the count in different sheet

    Hi,

    Why do you NEED VBA when a simple COUNTIF function would seem the obvious solution.
    Richard Buttrey

    If any of the responses have helped then please consider rating them by clicking the small star icon below the post.

  3. #3
    Forum Contributor
    Join Date
    07-17-2012
    Location
    India
    MS-Off Ver
    Excel 2007, 2010
    Posts
    657

    Re: VBA to count data in Column and paste the count in different sheet

    am not good with formula . How can we achieve with formula? It would do helps if it can be done with only formula..

    Thanks,
    Shiva

  4. #4
    Forum Guru
    Join Date
    03-28-2012
    Location
    TBA
    MS-Off Ver
    Office 365
    Posts
    12,122

    Re: VBA to count data in Column and paste the count in different sheet

    Please Login or Register  to view this content.

  5. #5
    Forum Moderator Richard Buttrey's Avatar
    Join Date
    01-14-2008
    Location
    Stockton Heath, Cheshire, UK
    MS-Off Ver
    Office 365, Excel for Windows 2010 & Excel for Mac
    Posts
    27,782

    Re: VBA to count data in Column and paste the count in different sheet

    Quote Originally Posted by shiva_reshs View Post
    am not good with formula . How can we achieve with formula? It would do helps if it can be done with only formula..

    Thanks,
    Shiva
    Hi,

    Upload your workbook and no doubt we can help further when we see your request in context.

  6. #6
    Forum Contributor
    Join Date
    07-17-2012
    Location
    India
    MS-Off Ver
    Excel 2007, 2010
    Posts
    657

    Re: VBA to count data in Column and paste the count in different sheet

    Thanks AB.. Code works well. But I need help in Searching the Row instead of just putting F:F. The file I receives, the column which I want to count can be placed anywhere in the dump sheet.

    I have below code which helps me to search Status Column.. But How can I tweak your code to do the same.

    Search the column and count the data?

    Please Login or Register  to view this content.
    Thanks

  7. #7
    Forum Guru
    Join Date
    03-28-2012
    Location
    TBA
    MS-Off Ver
    Office 365
    Posts
    12,122

    Re: VBA to count data in Column and paste the count in different sheet

    Please Login or Register  to view this content.

  8. #8
    Forum Contributor
    Join Date
    07-17-2012
    Location
    India
    MS-Off Ver
    Excel 2007, 2010
    Posts
    657

    Re: VBA to count data in Column and paste the count in different sheet

    Thanks a lot.. ...

+ 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 count Cell value and paste the number in Another sheet.
    By shiva_reshs in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 06-10-2014, 11:40 AM
  2. [SOLVED] Count values in column, paste current year in another column that many times
    By johnstevens in forum Excel Programming / VBA / Macros
    Replies: 9
    Last Post: 06-05-2014, 02:32 PM
  3. [SOLVED] Copy and paste data according count greater then 0(zero) of column w
    By HaroonSid in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 04-29-2014, 07:49 AM
  4. 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
  5. Replies: 1
    Last Post: 02-09-2010, 06:16 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