Announcement

Collapse
No announcement yet.

$40 - Create spreadsheet from Source sheet based on criteria - VBA.

Collapse
X
  • Filter
  • Time
  • Show
Clear All
new posts

  • $40 - Create spreadsheet from Source sheet based on criteria - VBA.



    Hi All,

    Need help with getting data from a source spreadsheet into another sheet based on four different scenarios. Each scenario results in two rows of output. The final output will be placed in the tab called Acct_Genex and will be sent to my Accounting team.
    The scenarios can be broken up into “Fee” or non fee transactions, and whether or not the “Amount” value in the Source tab is positive or negative.

    I have the Criteria/Logic laid out in the attached workbook in the Criteria tab. Hopefully that will explain better what I am looking to accomplish.
    I have example data in the “Source” tab as well as the anticipated results will look like in the “Example Output” tab.

    I envision a click of the button approach where on a daily basis, I copy the Source data into the “Source”tab, and once the macro is run, it will populate the “Acct_Genex” tab with the required results.
    Again there should be two rows of data in the “Acct-Genex” tab to every row of data in the “Source” sheet.

    Not sure how much work this is, so I am flexible to the rate. Just let me know if the starting fee is not fair.

    I hope this all makes sense. Please ask if you have any questions.

    Thanks for taking a look!

    Jeff

    Paid 10% to Oz....

    Transaction ID
    7SG35431BJ0951126
    Attached Files

  • #2
    Hi,

    I should be able to help you with your request. I will look at your file and let you know if I have any questions.
    Thanks,

    Comment


    • #3
      Great! Thanks a bunch.

      Comment


      • #4
        Hello,
        I have a solution ready for you. I will send you payment details via private message.

        Comment


        • #5
          Just sent payment. Thanks!!

          Comment


          • #6
            Payment received and file sent via PM. Thanks.

            Comment


            • #7


              Outstanding! Couldn't be more pleased. Thank you very much!!!

              Comment

              Working...
              X