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
 

Some videos you may like

Excel Facts

Can a formula spear through sheets?
Use =SUM(January:December!E7) to sum E7 on all of the sheets from January through December

Fluff

MrExcel MVP, Moderator
Joined
Jun 12, 2014
Messages
35,943
Office Version
365
Platform
Windows
Duplicate https://www.mrexcel.com/forum/excel...ts-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.

Watch MrExcel Video

Forum statistics

Threads
1,090,109
Messages
5,412,469
Members
403,428
Latest member
ldmcd

This Week's Hot Topics

Top