+ Reply to Thread
Results 1 to 4 of 4

Calculate with the last 125 rows

  1. #1
    Registered User
    Join Date
    10-12-2021
    Location
    Budapest
    MS-Off Ver
    2019
    Posts
    9

    Lightbulb Calculate with the last 125 rows

    Hello guyz!

    My task is to use the last 125 rows from another workbook in Excel until we start entering new data on the other workbook and start taking the numbers from there until the new workbook reaches 125 rows and continue counting on the other workbook, always with the last 125 lines.

    I have an idea to copy the last 125 rows with the macro to the other worksheet and continue by adding the others.

    I tried to describe it more precisely in the following attachments:
    Attached Files Attached Files
    Last edited by Rockraizer; 10-25-2021 at 12:20 PM.

  2. #2
    Forum Expert
    Join Date
    10-06-2017
    Location
    drevni ruchadlo
    MS-Off Ver
    old
    Posts
    2,151

    Re: Calculate with the last 125 rows

    Description of the problem unclear, unintelligible - describe in points (step by step):
    1. what is to be downloaded
    2. where to be downloaded from
    3. where to be copied
    4. what is to be counted
    Attach sample xls files

  3. #3
    Registered User
    Join Date
    10-12-2021
    Location
    Budapest
    MS-Off Ver
    2019
    Posts
    9

    Re: Calculate with the last 125 rows

    Okey, I reedit my post and send sample xls files!
    I'll write in the sample too.

  4. #4
    Forum Guru
    Join Date
    08-28-2014
    Location
    USA
    MS-Off Ver
    Excel 2019
    Posts
    17,552

    Re: Calculate with the last 125 rows

    In my opinion having the Data information and the User information in different workbooks is one of the complications. It would be easier if they were simply two worksheets within the same workbook.
    That said I feel the way to get the data from Data.xlsx to User.xlsx would be to utilize what you have in column L in the data workbook.
    This should work for cells C10:C134 in the User workbook.
    1. Put the following into cell C10 ='C:\Users\dolan\Desktop\[Data.xlsx]Munka'!L2
    2. Drag the fill handle down to cell C134
    Honestly if it were me, I would select cell L2 in the Data workbook Press the Ctrl + Shift + down arrow keys then press Ctrl + c and then select cell C10 in the User workbook and press the Ctrl + v keys.
    Let us know if you have any questions.
    Consider taking the time to add to the reputation of everybody that has taken the time to respond to your query.

+ 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] How To Calculate Rows and Columns
    By paulepage14 in forum Excel Formulas & Functions
    Replies: 5
    Last Post: 01-15-2018, 04:55 PM
  2. Calculate Average Time between Two Rows in a Range of Many Non-Consectuive Rows
    By aferoz in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 10-13-2014, 11:51 PM
  3. Calculate Average Time between Two Rows in a Range of Many Non-Consectuive Rows
    By aferoz in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 09-23-2014, 08:47 PM
  4. calculate sum of rows
    By Michael007 in forum Excel Programming / VBA / Macros
    Replies: 6
    Last Post: 10-24-2011, 06:12 AM
  5. [SOLVED] How to calculate the sum of the alternate rows?
    By Sathish in forum Excel Formulas & Functions
    Replies: 5
    Last Post: 04-12-2011, 09:29 AM
  6. Calculate sum of rows until values changes
    By dmolanov in forum Excel General
    Replies: 2
    Last Post: 02-09-2011, 10:13 AM
  7. How to calculate this on all rows?
    By Albert in forum Excel Programming / VBA / Macros
    Replies: 20
    Last Post: 02-02-2005, 10:06 AM

Tags for this Thread

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