Collect data from a row in multiple sheets

Not open for further replies.


New Member
Nov 5, 2018
I have monthly workbooks (October, November, etc.) with data, and in each month
-there's cycle of work of seven days (call it sheets:1,2,3,4,5,6,7)
-after each cycle it stops for two days (sheets:8 and 9)
-and it starts again (sheets:10,11,12...16)

I want to resume the data from some columns of each cycle in sheets called (cycle1, cycle2, cycle3...)
-For example I want it to collect the data from the column C, from row 3 till the last fulfilled cell with limit row 33 (because the number of cells fill vary by day) and put it in sheet"cycle1" from cell B5 downwards.
-And I need to do the same task for another column E3 till last fulfilled one (limit E33, and collect it in the row of sheet "cycle1" from C5 downwards
-sometimes the cycle has to collect data from two different workbooks (October and November for example)
-and I would like to put in row A from cell A5 down the sheet origin of the collected data



MrExcel MVP, Moderator
Jun 12, 2014
Office Version

Please do not post the same question multiple times. All clarifications, follow-ups, and bumps should be posted back to the original thread.
Per forum rules, posts of a duplicate nature will be locked or deleted (rule 12 here: Forum Rules).

If you do not receive a response, you can "bump" it by replying to it again, though we advise you to wait 24 hours before doing and not to bump a thread more than once a day.

Not open for further replies.

Forum statistics

Latest member

Some videos you may like

This Week's Hot Topics

  • VBA code giving errors and stopping Excel
    Hello Experts, I have this code being used to loop through files in a file path, and copy specific data to another sheet. It is giving me several...
  • Disable MsgBox message
    Morning, I have a userform where if i leave a ComboBox empty i see a MsgBox warning me that i must enter an invoice number. It is this MsgBox i...
  • Macro Recorder into VBA, Copy Paste Data Filled Cells
    Hi Everyone, I have a macro recorder file that takes a selection of data, copies, then pastes into a new sheet on ("A2:B2") The issue is my...
  • Number format changes while pasting into a cell
    Hi, I am trying to paste a number 180204524303 from an email to an excel cell, however, whenever i try to do so , the the paste value appears as...
  • Collating data
    Hello all. Could someone please help. I am trying to pull all column data from multiple sheets (24 I total so far) into 1 master sheet without...
  • Sum Multiple Columns Based on Multiple Criteria
    I am trying to consolidate data by summing columns G through M based on material, plant, vendor, and fiscal year being identical. The period does...