Consolidate Text

[Huddle]

I don't know if you can even do this.

I have 3 sheets each representing a day. I want the information on each sheet to populate to the Month sheet. I tried to use the consolidate feature but it just told me "No data was consolidated".

I've attached an example. The data on the Month sheet is cut and pasted to show how I would like for it to look.

[Richard Buttrey]

Probably a simple macro would be best
Loop through all three sheets copying the CurrentRegion based on A1 and pasting the data to the next blank row on the Month sheet.

You could use the macro recorder as a starter if you're unfamiliar with macros.

[Pete_UK]

As an alternative to Richard's suggestion, the attached file shows how it can be done with formulae. Most formulae are copied down to row 30 in each sheet - just copy them further if you have more data. This is only set up for sheets 1, 2 and 3, but it's quite straightforward to apply it to the other day sheets.

Hope this helps.

Pete

[Huddle]

Thanks, both great answers