Keeping Excel Columns in sync across sheets

[obiwanfan]

Does anyone know if it is possible to keep a column from one sheet in sync with another column from a different sheet.

Example: sheet 1 column A has a list of employees. I want sheet 2 Column A to have the same list of employees without having to re-type them. Bonus funtionality would be that if a change is made on sheet 1 and same change shows in sheet 2.

 

[Molby]

On sheet2, type =Sheet1!A1, or whatever your cell reference is and then copy this formula down. Any change will be reflected.

 

[xlbo]

This would need code (or a formula copied down a really long way). If you have, say 50 employees and you expect no more than another 100, you can simply type
=if(sheet1!A1="","",Sheet1!A1)
in A1 on sheet 2 and copy down further than your current dataset - that way, any additions / changes will be shown on sheet2. The disadvantage of this is that you are bloating the file by having unncessary formulae and at some point, you will have to copy the formula down further to accomodate more employees.....

Rgds, Geoff

Never test the depth of water with both feet

Help us to help you by reading FAQ222-2244 before you ask a question

 

[Crowley16]

maybe it'd be easier to use a database if there's a LOT of employees...

otherwise, u'd have to limit the number of employees or have to fill down the entire column on sheet2

'=Sheet1!A1'