Collect data from a row in multiple sheets

Status
Not open for further replies.

jcsantos

New Member
Joined
Nov 5, 2018
Messages
2
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

Thanks
 

Fluff

MrExcel MVP, Moderator
Joined
Jun 12, 2014
Messages
33,381
Office Version
365
Platform
Windows
Duplicate https://www.mrexcel.com/forum/excel-questions/1076501-collect-data-multiple-worksheets-one-worksheet-post5171641.html#post5171641

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.

 
Status
Not open for further replies.

Forum statistics

Threads
1,084,744
Messages
5,379,581
Members
401,614
Latest member
priokatm

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...
Top