S
Sheri
I am trying to convert my payroll from Quattro Pro to
Excel. I have 2 workbooks (one for the timesheets and one
for the leave accruals). Both workbooks have multiple
sheet named for each employee. I can link the first sheets
in the workbooks, but when I try to copy that link to the
following sheets, it copies exactly rather than
automatically taking the information from the
corresponding sheets. (In Quattro Pro, I would put the
workbook in group mode and copy the reference by pressing
F2 and then pressing Ctrl Enter. Each sheet would then be
linked to the corresponding sheet in the other workbook.)
Is there a way to do this in Excel 97?
Excel. I have 2 workbooks (one for the timesheets and one
for the leave accruals). Both workbooks have multiple
sheet named for each employee. I can link the first sheets
in the workbooks, but when I try to copy that link to the
following sheets, it copies exactly rather than
automatically taking the information from the
corresponding sheets. (In Quattro Pro, I would put the
workbook in group mode and copy the reference by pressing
F2 and then pressing Ctrl Enter. Each sheet would then be
linked to the corresponding sheet in the other workbook.)
Is there a way to do this in Excel 97?