Inputting data to two sheets simultaneously

[Legacy 23678]

I have two worksheets, one for adding up to 1000 rows of data, and another that for displaying certain colums as they are entered.

I have tried linking the colums on the second worksheet (the Data Display sheet) to the data entry sheet, but with over a thousand possible entries that have to be allowed for, and not all of them filled, the formulas in blank fields keeps taking priority when I try to sort them.

What I'd like to be able to do is have the data from a few colums on the data entry worksheet, appear on the second worksheet as soon as a new row is entered, without the need for putting the "='Sheet1'!A1" formulas in that second sheet.

 

[Cbrine]

Hold down the shift key and select both sheets from the sheet selector at the bottom. This will cause any entry, to appear on both sheets, in the same cells.