+ Reply to Thread
Results 1 to 6 of 6

Have data in sheets in month by Month, want to record them in one Sheet every time updates

  1. #1
    Registered User
    Join Date
    10-17-2020
    Location
    Nairobi,Kenya
    MS-Off Ver
    office 2010
    Posts
    8

    Have data in sheets in month by Month, want to record them in one Sheet every time updates

    Hi There,
    need help on how to be recording every time different sheets are updated in a common sheet named All Months as shown in sample without involving VBA.

    Thanks in advance.
    Attached Files Attached Files

  2. #2
    Forum Moderator Glenn Kennedy's Avatar
    Join Date
    07-08-2012
    Location
    Digital Nomad... occasionally based in Ireland.
    MS-Off Ver
    O365 (PC) V 2403
    Posts
    44,139

    Re: Have data in sheets in month by Month, want to record them in one Sheet every time upd

    It is not clear what your expected results should look like. Please add them for any one month.
    Glenn




    None of us get paid for helping you... we do this for fun. So DON'T FORGET to say "Thank You" to all who have freely given some of their time to help YOU

  3. #3
    Registered User
    Join Date
    10-17-2020
    Location
    Nairobi,Kenya
    MS-Off Ver
    office 2010
    Posts
    8

    Re: Have data in sheets in month by Month, want to record them in one Sheet every time upd

    Can use VBA if it will be the solution.
    Thanks in Advance.

  4. #4
    Forum Moderator Glenn Kennedy's Avatar
    Join Date
    07-08-2012
    Location
    Digital Nomad... occasionally based in Ireland.
    MS-Off Ver
    O365 (PC) V 2403
    Posts
    44,139

    Re: Have data in sheets in month by Month, want to record them in one Sheet every time upd

    It can be done with formula, but I need to know WHAT WAY the results should look. So, amend your sheet as I requested.

  5. #5
    Registered User
    Join Date
    10-17-2020
    Location
    Nairobi,Kenya
    MS-Off Ver
    office 2010
    Posts
    8

    Re: Have data in sheets in month by Month, want to record them in one Sheet every time upd

    Please find attached as requested,
    Attached Files Attached Files

  6. #6
    Forum Moderator Glenn Kennedy's Avatar
    Join Date
    07-08-2012
    Location
    Digital Nomad... occasionally based in Ireland.
    MS-Off Ver
    O365 (PC) V 2403
    Posts
    44,139

    Re: Have data in sheets in month by Month, want to record them in one Sheet every time upd

    My next question is why do you need one sheet for every month? Since you are making no summary - just copying ALL of the information over, it makes no sense to have the individual monthly sheets. If it's all in ons sheet, right from the start, you can easily use filters to get an overview of a month's activity. All you are really doing is doubling the size of your workbook for no good reason at all.

+ 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. Help with copying data from master sheet to multiple sheets based on month
    By maym in forum Excel Programming / VBA / Macros
    Replies: 63
    Last Post: 01-09-2023, 01:58 AM
  2. [SOLVED] Return Month-on-Month growth using current month-prior month/prior month per country
    By losincog in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 08-21-2020, 05:37 AM
  3. [SOLVED] create a new sheets & copy data from sheet to multiples and sum based on month
    By ABDELFATTA in forum Excel Programming / VBA / Macros
    Replies: 18
    Last Post: 08-11-2020, 09:56 AM
  4. Replies: 3
    Last Post: 05-16-2020, 05:09 PM
  5. Replies: 1
    Last Post: 11-14-2018, 09:22 AM
  6. Record time spent on project numbers accross a whole month timesheet.
    By stanners88 in forum Excel Formulas & Functions
    Replies: 4
    Last Post: 11-21-2014, 10:59 AM
  7. Replies: 0
    Last Post: 11-08-2008, 02:44 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