Results 1 to 8 of 8

vba code to sum the values of a column by year

Threaded View

abhi_jain80 vba code to sum the values of... 06-18-2021, 04:21 PM
TMS Re: vba code to sum the... 06-18-2021, 06:08 PM
abhi_jain80 Re: vba code to sum the... 06-19-2021, 05:00 PM
TMS Re: vba code to sum the... 06-19-2021, 05:11 PM
abhi_jain80 Re: vba code to sum the... 06-21-2021, 04:44 AM
TMS Re: vba code to sum the... 06-21-2021, 05:47 AM
abhi_jain80 Re: vba code to sum the... 06-21-2021, 12:16 PM
TMS Re: vba code to sum the... 06-21-2021, 12:26 PM
  1. 06-18-2021, 04:21 PM #1
    abhi_jain80 is offline
    Registered User
    Join Date
    08-10-2016
    Location
    Ireland
    MS-Off Ver
    2013
    Posts
    67

    vba code to sum the values of a column by year

    Hi experts,

    Please refer the sample data attached. I need to sum the values of column B if the year in column A is 2021 in "Sheet1" and need the result in "Sheet2". There are no fixed number of rows in the columns.
    I need the vba script but I am struggling to write it. Can somebody help me please?

    Apologies if this has been solved earlier and thanks in advance...

    Abhi
    Attached Files Attached Files
    Reply With QuoteRegister To Reply
« 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. Getting current year/month/day values and inserting them into macro code
    By joe_schmo95 in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 03-26-2021, 04:05 AM
  2. [SOLVED] macro code for comparing month-year then add next column value
    By k1dr0ck in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 06-04-2018, 04:47 AM
  3. VBA code to search through column and allocate to year
    By pokopikos13 in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 05-23-2017, 10:08 AM
  4. Year values in the column
    By Lana74 in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 10-18-2016, 04:58 PM
  5. Sum values for month and year where cells in column contain word
    By serverlift in forum Excel Formulas & Functions
    Replies: 6
    Last Post: 11-25-2015, 05:08 PM
  6. [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
  7. Sorting Column Values (Ascending Year)
    By jimmy_nora in forum Excel Programming / VBA / Macros
    Replies: 5
    Last Post: 11-12-2010, 04:18 AM

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