Loading
Ozgrid Excel Help & Best Practices Forums

Excel Training / Excel Dashboards Reports



Results 1 to 8 of 8

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

  1. #1
    Join Date
    5th January 2017
    Posts
    9

    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. REMINDER! OzGrid accepts no responsibility for ANY adverse effects as a result from downloading attached files. ALWAYS run an up-to-date virus scan and disable macros.

  2. #2
    Join Date
    27th March 2013
    Location
    Québec, Canada
    Posts
    706

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

    Hi,
    I can look at your request.

  3. #3
    Join Date
    27th March 2013
    Location
    Québec, Canada
    Posts
    706

    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?

  4. #4
    Join Date
    5th January 2017
    Posts
    9

    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.

  5. #5
    Join Date
    27th March 2013
    Location
    Québec, Canada
    Posts
    706

    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.

  6. #6
    Join Date
    27th March 2013
    Location
    Québec, Canada
    Posts
    706

    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. REMINDER! OzGrid accepts no responsibility for ANY adverse effects as a result from downloading attached files. ALWAYS run an up-to-date virus scan and disable macros.

  7. #7
    Join Date
    5th January 2017
    Posts
    9

    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 !

  8. #8
    Join Date
    27th March 2013
    Location
    Québec, Canada
    Posts
    706

    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.

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Possible Answers

  1. Replies: 9
    Last Post: June 16th, 2013, 13:38
  2. Replies: 16
    Last Post: December 16th, 2012, 22:25
  3. Replies: 5
    Last Post: August 19th, 2011, 07:19
  4. Replies: 7
    Last Post: August 12th, 2008, 17:25
  5. Replies: 2
    Last Post: May 12th, 2006, 10:48

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
  •  
porno