Results 1 to 10 of 20

Thread: Macro that concatenates two cells, references a Date and then copy pastes value into

Threaded View

Previous Post Previous Post   Next Post Next Post
  1. #1
    Banned rj1600's Avatar
    Join Date
    Jan 2021
    Posts
    9
    Articles
    0
    Excel Version
    Version 2012

    Macro that concatenates two cells, references a Date and then copy pastes value into

    Would love some help writing this macro
    i tried attaching a file with more explanations within the file if it helps make it clearer. (in yellow highlights & red text)


    I have two sheets. One titled 'Money', the second titled 'Data'
    In the 'Money' tab, there's a section which currently begins from row 41 where the macro would be populating the data it's pulling. For clarity's sake, i'll refer to this section as the Expense section.

    Essentially, the macro is pulling data from the 'Data' tab based on certain criteria (the date). If the criteria is met, it will copy the data of its respective row from the 'Data' tab; will go to the 'Money' tab, look for the last row that contains data in the first portion of the Expense section, creates a new row and pastes values in this new row; making sure not to be pasting over any previous data

    written out as steps:

    if the concatenation of N & O of 'Data' sheet, viewed as Date format, matches the month of today's date; then copy and paste values of the concatenation into the first available row in column B of 'Money' sheet (beginning from B42 onwards)
    then still referencing that same row in 'Data' sheet, copy columns P thru S and paste values into columns C thru F of 'Money' sheet in the same row that was previously referenced.
    then still referencing that same row in 'Data' sheet, copy columns T and U and paste values into columns H & I of 'Money' sheet in the same row that was previously referenced.
    then still referencing that same row in 'Data' sheet, copy column V and paste values into column G of 'Money' sheet in the same row that was previously referenced



    i hope i explained that decently. please let me know if the Excel file isn't any clearer and i'll add more clarity.
    Attached Files Attached Files

Tags for this Thread

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •