Hi,
I think the best way could be having an application that automates MS
Excel, to fill the data you can use a single function by passing different
parameters
--------------------
[Quoted Text] >Thread-Topic: Best way to populate several worksheets that contain common
data
>thread-index: AcX0iQJJgOxkL6d7QS2FOkoyJOVfxQ==
>X-WBNR-Posting-Host: 67.187.173.156
>From: =?Utf-8?B?amRm?= <jdf[ at ]discussions.microsoft.com>
>Subject: Best way to populate several worksheets that contain common data
>Date: Mon, 28 Nov 2005 18:02:53 -0800
>Lines: 5
>Message-ID: <70D69340-6050-41A3-AF0F-FA67E28E2EDB[ at ]microsoft.com>
>MIME-Version: 1.0
>Content-Type: text/plain;
> charset="Utf-8"
>Content-Transfer-Encoding: 7bit
>X-Newsreader: Microsoft CDO for Windows 2000
>Content-Class: urn:content-classes:message
>Importance: normal
>Priority: normal
>X-MimeOLE: Produced By Microsoft MimeOLE V6.00.3790.0
>Newsgroups: microsoft.public.officedev
>NNTP-Posting-Host: TK2MSFTNGXA03.phx.gbl 10.40.2.250
>Path: TK2MSFTNGXA02.phx.gbl!TK2MSFTNGXA01.phx.gbl!TK2MSFTNGXA03.phx.gbl
>Xref: TK2MSFTNGXA02.phx.gbl microsoft.public.officedev:18033
>X-Tomcat-NG: microsoft.public.officedev
>
>I have several worksheets that are in different workbooks but, that have
>several cells that require the same data, ie. customer name, phone. I want
to
>develop a solution where I can type the data in one place, perhaps using
>Forms, and the data automatically populates the fields in the various
>worksheets. What is the best way to do this? Any suggestions are welcome.
>
|