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