Working with multiple excel worksheets

Deleted User 234324 · 5 Jul 2011 at 15:26

Hey folks,

Question really, is it possible to have multiple worksheets (seperate excel documents) and when ever data is entered into one, the others are automatically updated with the same data but possibly sorted differently?

wonko · 5 Jul 2011 at 16:01

Hi, you can refer to data in other workbooks / sheets using =[Book1.xls]Sheet1!A1. IIRC there's an workbook option to determine whether updating (recalculation) happens automatically. Sorting can be done manually or using pivot tables, but I'm not too sure how easy it would be to make the sorting completely automatic without a manual or macro-invoked 'refresh data'.

Deleted User 234324 · 5 Jul 2011 at 17:20

What im looking to do though is bring data in to a new spread sheet that wont already be defined specifically.

IE

Several rows of data,

1......
2......
3......

When someone adds a new row of data for example 4..... it automatically puts that rows data into a new spread sheet. So would referencing workbooks using Sheet1 etc still be relevant when the number of rows is always increasing?

wonko · 5 Jul 2011 at 19:19

I'm a bit rusty so might be missing an obvious answer here, but in the 'receiving' sheet you could have references to areas of the source sheet that weren't originally filled with any data, i.e. you could have links to (say) 9999 rows which might do what you want. Using named ranges and array formulas might be things to look at but if you're actually inserting rows into the source sheet then you might be looking at some vba.