Data Population for multiple sheets

[Shaun]

I'm looking to build a spreadsheet with one main page that can be populated
with data and automatically pull that data over to other more specific
sheets.

For example, If I have sales on the main sheet and have check boxes for more
specific sales on the same sheet (i.e. liquor sales, food sales etc..) I want
that number to poulate on the specific sales sheet.

I'm assumming I have to wite an IF/Then Statement to say if an "x" is put
into a cell then copy and past the data in the specified cells within that
row and pull that information over to sheet Y.

 

[Gord Dibben]

Shaun

Formulas cannot "push" data to another cell or sheet.

You can use linking formulas on the target sheet that refer back to cells on the
Master sheet.

i.e. in salesheet1 enter =main!A1

If you wish to "push" the data without using formulas you will need VBA.

See Ron de Bruin's site for various types of code.

http://www.rondebruin.nl/tips.htm

Look under Copy/Paste/Merge Examples.


Gord Dibben MS Excel MVP