Collect data from multiple worksheets in one worksheet

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
 

Some videos you may like

Excel Facts

Links? Where??
If Excel says you have links but you can't find them, go to Formulas, Name Manager. Look for old links to dead workbooks & delete.

Watch MrExcel Video

Forum statistics

Threads
1,095,418
Messages
5,444,346
Members
405,278
Latest member
karen1

This Week's Hot Topics

Top