+ Reply to Thread
Results 1 to 3 of 3

Comparing dynamic date and pasting results

  1. #1
    Registered User
    Join Date
    09-25-2015
    Location
    Chicago, IL
    MS-Off Ver
    2010-2013
    Posts
    2

    Comparing dynamic date and pasting results

    Hi I need help with a macro creation. I have very limited knowledge with macros. Any help would be appreciated
    I’ve created a mock spreadsheet for the project that I’m working on.

    What I need this macro to do is to compare the July and August months for changes and paste the differences to the correct tabs.

    For the “Principal changes” tab it needs to compare row I on both July and August and have the changes for the fund’s total principal to past here.

    For the “Holdings Changes” tab I need the macro to compare the cusip for both months and paste any that aren’t in both months here.

    For the “Maturing in 30 days or less” I need the macro to past the correct funds based on the maturity date
    Attached Files Attached Files

  2. #2
    Forum Expert skywriter's Avatar
    Join Date
    06-09-2014
    Location
    USA
    MS-Off Ver
    2016
    Posts
    2,760

    Re: Comparing dynamic date and pasting results

    It's always best to manually enter the desired results. Not all of us are stock experts. I don't know if you want A-B or B-A, so please enter your desired results based on your sample data and explain the methodology.
    Click the * Add Reputation button in the lower left hand corner of this post to say thanks.

    Don't forget to mark this thread SOLVED by going to the "Thread Tools" drop down list above your first post and choosing solved.

  3. #3
    Registered User
    Join Date
    09-25-2015
    Location
    Chicago, IL
    MS-Off Ver
    2010-2013
    Posts
    2

    Re: Comparing dynamic date and pasting results

    Attached is the updated spreadsheet. For Tab "Holdings changes" this compares column G, Any thing that's not matching in the two months should be posted to this tab. The "Maturing in 30 or less" tab is populated based on info from column K of the latest month.
    Attached Files Attached Files

+ 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] Dynamic value used to put results in cell defined by dynamic value
    By Carrot Top in forum Excel Formulas & Functions
    Replies: 8
    Last Post: 04-24-2013, 03:32 PM
  2. [SOLVED] *solved* Pasting results into a dynamic range on a different worksheet
    By TheRobsterUK in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 08-25-2012, 03:44 PM
  3. [VBA] Comparing two columns and pasting the difference into a third column
    By hydroid in forum Excel Programming / VBA / Macros
    Replies: 12
    Last Post: 02-06-2012, 06:29 PM
  4. Having issue comparing/pasting/using dates from South-Africa and I am in USA..
    By welchs101 in forum Excel Programming / VBA / Macros
    Replies: 6
    Last Post: 12-14-2011, 10:12 AM
  5. Comparing and Pasting
    By himanshu_s123 in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 10-30-2009, 05:13 AM
  6. Pasting Subtotal Results
    By tchen in forum Excel General
    Replies: 1
    Last Post: 08-08-2005, 05:05 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