Hi guys
Ok i'm setting up a delay reporting system for products,
and it will be someone's duty to report on all these delays, and
so for every delay, he will receive an attached
spreadsheet, which will be just one row with about 10
columns on info. He will receive roughly 30-50 a month of these separate sheets via email attachments.
Now, he needs to take each individual worksheet attached and collate them into one monthly report.
My question-does excel facilitate the collation of separate worksheets at all ? Or is really the simplest way of gettin the values of these different sheets into one workbook, to cut and paste everything?
Any help greatly appreciated
cheers
olly
Ok i'm setting up a delay reporting system for products,
and it will be someone's duty to report on all these delays, and
so for every delay, he will receive an attached
spreadsheet, which will be just one row with about 10
columns on info. He will receive roughly 30-50 a month of these separate sheets via email attachments.
Now, he needs to take each individual worksheet attached and collate them into one monthly report.
My question-does excel facilitate the collation of separate worksheets at all ? Or is really the simplest way of gettin the values of these different sheets into one workbook, to cut and paste everything?
Any help greatly appreciated
cheers
olly