ExcelBanter - Auto fill

ExcelBanter (https://www.excelbanter.com/)

- Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)

- - Auto fill (https://www.excelbanter.com/excel-worksheet-functions/260820-auto-fill.html)

Mikki

Auto fill

When I have a spreadsheet #1 and would like it to automaticaly update
spreadsheet # 3 in the same workbook, how do I do that. I know that there is
a way but I cannot remember.

Eduardo

Auto fill

Hi,
in sheet2 enter a formula like

=sheet1!A1

copy formula

"mikki" wrote:

When I have a spreadsheet #1 and would like it to automaticaly update
spreadsheet # 3 in the same workbook, how do I do that. I know that there is
a way but I cannot remember.

All times are GMT +1. The time now is 05:16 AM.