Hello,
Sorry if this is not clear, but I will do my best to make sure it is.
I have generated 12 tabs on the bottom of one workbook with all of the months. I have a 13th tab which I want to convert all of the data (columns and rows) from the 12 monthly tabs. I have been messing around with the "Consolidate" button under the "Data" tab, but this is not working for me. When doing that, it is leaving out some of the information that is not number based.
Again, what I am looking to do is make it so when I fill in 4 rows from "january" I want those 4 rows to convert to "annual". I want to then do the same for the rest of the months. Lastly, if I add rows to "january" or any month for that matter, I would like these rows to be added to the "annual" tab at the end.
Is there a way to do this? I am fairly proficient in Excel, but this is stumping me. I do not even know the proper key words to type in to search this.
Thanks in advance.
Bookmarks