I'm trying to set up a loop to pull data from multiple cells in multiple worksheets

  • Re: I'm trying to set up a loop to pull data from multiple cells in multiple workshee


    Add this line to the end of each Macro I gave, it will change the date in cell N2 which shows when the table was last updated.

    Code
    A_LBVN.[n2] = Date

    We now have a reputation system in place. If my reply helped please "Like" the reply by clicking the "Like" icon at bottom right of my reply.

  • Re: I'm trying to set up a loop to pull data from multiple cells in multiple workshee


    Is the table on your actual file named something other than "Table1"?

    We now have a reputation system in place. If my reply helped please "Like" the reply by clicking the "Like" icon at bottom right of my reply.

  • Re: I'm trying to set up a loop to pull data from multiple cells in multiple workshee


    No, it is named Table1 according to the name box to the left of the formula bar.
    One thing I did change was in the (NAME) field, I made all of the "G" numbers 3 digit numbers. For example G-01 is the NAME of the worksheet, G001 is the (NAME) of the worksheet. I did this because the numbers of all of the "G" go from 1 - 110. Without all of the (NAME) fields being 3 digit numbers, the order of the sheets in the list is not correct. Maybe that has something to do with it?

  • Re: I'm trying to set up a loop to pull data from multiple cells in multiple workshee


    Try changing that macro to:


    That should work no matter how the Table is named.

    We now have a reputation system in place. If my reply helped please "Like" the reply by clicking the "Like" icon at bottom right of my reply.

  • Re: I'm trying to set up a loop to pull data from multiple cells in multiple workshee


    KjBox! YOU WIN THE PRIZE!!! Works perfectly!! YAHOO!!!!


    THANK YOU THANK YOU!!!!
    You have made my weekend!!!

  • Re: I'm trying to set up a loop to pull data from multiple cells in multiple workshee


    You're welcome.


    Have you had a look at the file attached to Trebor's post (Post #19) to see how use of formulas works?

    We now have a reputation system in place. If my reply helped please "Like" the reply by clicking the "Like" icon at bottom right of my reply.

  • Re: I'm trying to set up a loop to pull data from multiple cells in multiple workshee


    Quote

    I have not. But I will. I am anxious to learn more about VBA now.


    Just bare in mind that formulas are always more efficient than code.


    Well done to KjBox for the nifty solution provided :)


    Robert

Participate now!

Don’t have an account yet? Register yourself now and be a part of our community!