|
auto copying
How do I automatically copy cells from the master worksheet to various
worksheets when line 1 goes to worksheet A, line 2 goes worksheet B etc? Is there a formula for this? Thanks for your help! |
auto copying
Jen
Formulas can only "pull" data from sources. They cannot "push" data to targets. Can you look at using linking formulas on the various sheets that pull from the master worksheet? Otherwise you will need to use VBA A good resource for code is Ron deBruin's site. http://www.rondebruin.nl/copy1.htm Gord Dibben MS Excel MVP On Fri, 8 Sep 2006 08:50:02 -0700, Jen wrote: How do I automatically copy cells from the master worksheet to various worksheets when line 1 goes to worksheet A, line 2 goes worksheet B etc? Is there a formula for this? Thanks for your help! |
auto copying
Gord,
That makes sense. I'll check out the website. Thanks for your help! Jen "Gord Dibben" wrote: Jen Formulas can only "pull" data from sources. They cannot "push" data to targets. Can you look at using linking formulas on the various sheets that pull from the master worksheet? Otherwise you will need to use VBA A good resource for code is Ron deBruin's site. http://www.rondebruin.nl/copy1.htm Gord Dibben MS Excel MVP On Fri, 8 Sep 2006 08:50:02 -0700, Jen wrote: How do I automatically copy cells from the master worksheet to various worksheets when line 1 goes to worksheet A, line 2 goes worksheet B etc? Is there a formula for this? Thanks for your help! |
| All times are GMT +1. The time now is 03:22 PM. |
Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com