Concatenate Column C in multiple sheets into single sheet.
Sorry for lack of info...
By spreadsheets i mean literally different files so all these sheets are not
in one workbook.
To answer David;
No i dont want to concatenate the differents cells into one cell.
I want Column C's entire contents in EACH spreadsheet to display underneath
each other into a singular spreadsheet. EG:
NamesOfStaffInHumanResource.xls
A B C
Elize
Wayne
Tanya
NamesOfStaffInIT.xls
A B C
Jack
Pierre
Frank
Clint
Now in the "Master" or individual file i want it to be displayed like this:
Master.xls
A B C
Elize
Wayne
Tanya
Jack
Pierre
Frank
Clint
The order of which is not important. Cheers
"Bob Phillips" wrote:
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
|