View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.misc
Bob Phillips Bob Phillips is offline
external usenet poster
 
Posts: 10,593
Default Concatenate Column C in multiple sheets into single sheet.

By spreadsheets, do you mean sheets within a single workbook, or multiple
workbooks?

--
HTH

Bob

(there's no email, no snail mail, but somewhere should be gmail in my addy)

"ant1983" wrote in message
...
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