Concatenate Column C in multiple sheets into single sheet.
I have multiple (identical) spreadsheets which are job descriptions for each
employee in our company.
In Column C i have their "Outputs" (the actual work they need to do). This
is a text string.
I want to "Concatenate" all of these "Outputs" (Column C's) in each
spreadsheet into a singular spreadsheet so that i have a central place to go
look (kinda like a logsheet or whatever.
I say it cannot be done without HUGE programming - My boss disagrees. Can
anyone help???
Many thanks,
Wayne
|