Announcement

Collapse
No announcement yet.

Find Last Column in Sheet w/ Data, then Copy/Paste Values in same Column (USD $50.00)

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

  • Find Last Column in Sheet w/ Data, then Copy/Paste Values in same Column (USD $50.00)

    Hello,

    I am looking for VBA code to find the last column with a numerical value (not reference formula) in within a sheet, then copy/paste the values of that column. The reference cells (rows 3-8 and 11-14) are populated daily, and I would like the macro to copy/paste the values of the prior day, so that they are static. Please note, there are blank columns & rows between the data sets as shown in the attachment.

    For instance, in the attachment on 1/4/2017, the macro would find that this was the last column with data and copy/paste the values of B3:B8 & B11:B14. On 1/5/2017, the same would occur but the values of cells C3:C8 & C11:C14 would be copied/pasted, etc. I have a tab at the end of the spreadsheet which shows what the sheet should look like after running the macro daily for 7 days.

    Thank you for your help !
    Attached Files

  • #2
    Re: Find Last Column in Sheet w/ Data, then Copy/Paste Values in same Column (USD $50

    Hi,
    I can look at your request.

    Comment


    • #3
      Re: Find Last Column in Sheet w/ Data, then Copy/Paste Values in same Column (USD $50

      Hi,
      Quick questions:
      - Have you paid the 10% to Ozgrid?
      - Are the number of rows 3-8 and 11-14 will always be the same?

      Comment


      • #4
        Re: Find Last Column in Sheet w/ Data, then Copy/Paste Values in same Column (USD $50

        Yes, I have paid the 10% to Ozgrid via PayPal, and yes the number of rows (and row numbers) will remain the same throughout the sheet.

        Thank you.

        Comment


        • #5
          Re: Find Last Column in Sheet w/ Data, then Copy/Paste Values in same Column (USD $50

          Hello,

          I have a solution ready for you. I will send you my email address via PM and post macro once payment is received.

          Comment


          • #6
            Re: Find Last Column in Sheet w/ Data, then Copy/Paste Values in same Column (USD $50

            Hello,
            Payment received... Thanks.
            Please find macro in attached file.
            Macro should be executed *before* you change the date in the validation list.

            Let me know if you have any questions or comments.
            Attached Files

            Comment


            • #7
              Re: Find Last Column in Sheet w/ Data, then Copy/Paste Values in same Column (USD $50

              Thank you for the quick turnaround GCExcel, the macro works perfectly !

              Comment


              • #8
                Re: Find Last Column in Sheet w/ Data, then Copy/Paste Values in same Column (USD $50

                Excellent... thanks for the feedback! Let me know if you need anything else.

                Comment

                Working...
                X