+ Reply to Thread
Results 1 to 7 of 7

Counting DATA from one sheet and recognizing and input DATA to another "totals" sheet

  1. 12-20-2012, 11:32 AM #1
    jrosko1 is offline
    Registered User
    Join Date
    06-21-2012
    Location
    GB, WI
    MS-Off Ver
    Excel 2010
    Posts
    41

    Counting DATA from one sheet and recognizing and input DATA to another "totals" sheet

    Various names will be input into column A for each month's sheet, along with company name in column B. For the Q1, etc, sheets, I need the names and corresponding companys from the individual month sheets to populate, along with the number of times the name appeared (# of occurrences). I manually input an example on the attached file. There will be a constantly changing group of over 200 names that could be entered in Column A, so having the name as part of the macro/formula won't work. Any help or suggestions on this is appreciated!
    THANK YOU!
    temp.xlsx
    Reply With QuoteRegister To Reply
  2. 01-04-2013, 06:43 AM #2
    arlu1201 is offline
    Forum Contributor arlu1201's Avatar
    Join Date
    09-09-2011
    Location
    Bangalore, India
    MS-Off Ver
    Excel 2003 & 2007
    Posts
    19,166

    Re: Counting DATA from one sheet and recognizing and input DATA to another "totals" sheet

    So do you want that the macro should populate the YEARLY tab with data from sheets Jan to Dec, while the Q1 sheets should take only data belong to Q1 which is Jan - Mar?
    If I have helped, Don't forget to add to my reputation (click on the star below the post)
    Don't forget to mark threads as "Solved" (Thread Tools->Mark thread as Solved)
    Use code tags when posting your VBA code: [code] Your code here [/code]
    Reply With QuoteRegister To Reply
  3. 01-04-2013, 08:53 AM #3
    jrosko1 is offline
    Registered User
    Join Date
    06-21-2012
    Location
    GB, WI
    MS-Off Ver
    Excel 2010
    Posts
    41

    Re: Counting DATA from one sheet and recognizing and input DATA to another "totals" sheet

    Right, and a Q2 tab will only pull from April-June, Q3 august- october, and Q4 oct-dec.... (I thought I could add these later, but if it's helps now.....)
    Reply With QuoteRegister To Reply
  4. 01-04-2013, 09:24 AM #4
    arlu1201 is offline
    Forum Contributor arlu1201's Avatar
    Join Date
    09-09-2011
    Location
    Bangalore, India
    MS-Off Ver
    Excel 2003 & 2007
    Posts
    19,166

    Re: Counting DATA from one sheet and recognizing and input DATA to another "totals" sheet

    If you run the macro once and then make changes to the Jan - Dec sheets and you want to run the macro again, should the data in Q sheets and Yearly sheet be cleared and then fresh data input?
    Reply With QuoteRegister To Reply
  5. 01-04-2013, 09:26 AM #5
    jrosko1 is offline
    Registered User
    Join Date
    06-21-2012
    Location
    GB, WI
    MS-Off Ver
    Excel 2010
    Posts
    41

    Re: Counting DATA from one sheet and recognizing and input DATA to another "totals" sheet

    yes, i think that would be great......
    Reply With QuoteRegister To Reply
  6. 01-04-2013, 09:49 AM #6
    arlu1201 is offline
    Forum Contributor arlu1201's Avatar
    Join Date
    09-09-2011
    Location
    Bangalore, India
    MS-Off Ver
    Excel 2003 & 2007
    Posts
    19,166

    Re: Counting DATA from one sheet and recognizing and input DATA to another "totals" sheet

    Try this code
    Please Login or Register  to view this content.
    Copy the Excel VBA code
    Select the workbook in which you want to store the Excel VBA code
    Hold the Alt key, and press the F11 key, to open the Visual Basic Editor
    Choose Insert | Module
    Where the cursor is flashing, choose Edit | Paste

    To run the Excel VBA code:
    Choose View | Macros
    Select a macro in the list, and click the Run button
    Reply With QuoteRegister To Reply
  7. 01-04-2013, 10:57 AM #7
    jrosko1 is offline
    Registered User
    Join Date
    06-21-2012
    Location
    GB, WI
    MS-Off Ver
    Excel 2010
    Posts
    41

    Re: Counting DATA from one sheet and recognizing and input DATA to another "totals" sheet

    truly awesome. Thank you tremendously for your help!
    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)

Tags for this Thread

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