Linking several worksheets to a results sheet - TechRepublic
Question
June 3, 2009 at 04:14 AM
generalgort

Linking several worksheets to a results sheet

by generalgort . Updated 17 years, 1 month ago

Hi,
I have several worksheets in a workbook, and I want to be able to include a worksheet that includes the results from similar cells in each worksheet, for instance have a column for the C1 cells from each of the other worksheets, another for D6 etc. hopefully this would save the long task of collating and adding up each lot of data.
Also, is it possible to insert into the ‘results’ worksheet, the other worksheet names automatically? I have used the date and then A, B etc. IE 030609A, 030609B, any help would be appreciated,

Phil

This discussion is locked

All Comments