Good Afternoon,
I am trying to take data off of multiple worksheets and then put it into a single column on another worksheet in the same workbook. I can use the transpose function to move a column from a single worksheet to another worksheet, but I need to do that from 58 sheets on data that can change from time to time. I would like to automate the process so as data in 1 sheet is updated it will update the master list as well. I have been unable to figure this out as of yet.
I am trying to take data off of multiple worksheets and then put it into a single column on another worksheet in the same workbook. I can use the transpose function to move a column from a single worksheet to another worksheet, but I need to do that from 58 sheets on data that can change from time to time. I would like to automate the process so as data in 1 sheet is updated it will update the master list as well. I have been unable to figure this out as of yet.