Change source according to data entered in a template.

's Computer Specifications

I am using third party software to enter data into a template. Things seem
to work fine, except I want to vary the source data for the chart in the
template according to how many rows of data have been entered from the third
party. Is there a way to do this??

's Computer Specifications

try using a defined name for the source data
edit>name>define>mysourcerange>refers to
=offset($a$2,0,0,counta($A:$A),6)

--
Don Guillett
SalesAid Software
(E-Mail Removed)
"ANStech" <(E-Mail Removed)> wrote in message
news:823D805C-863C-4F5A-BFB2-(E-Mail Removed)...
>I am using third party software to enter data into a template. Things seem
> to work fine, except I want to vary the source data for the chart in the
> template according to how many rows of data have been entered from the
> third
> party. Is there a way to do this??

Thread Tools
Show Printable Version Email this Page
Rate This Thread
Rate This Thread:

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Print only rows with data entered in an excel template	hellaby	Microsoft Excel Misc	1	9th Aug 2008 04:16 PM
Why won't vlookup read newly entered data from a source file?	=?Utf-8?B?bXdncnV0dGVy?=	Microsoft Excel Misc	3	5th Jun 2007 10:09 PM
sorting through unknown source data as it is entered	=?Utf-8?B?cmxkamRh?=	Microsoft Excel Worksheet Functions	1	8th Feb 2007 01:03 AM
?-Change data series range as data is entered?	isofuncurves	Microsoft Excel Charting	4	24th Jan 2006 06:15 PM
have dates entered from a list of data into an excel template	=?Utf-8?B?RGlhbmU=?=	Microsoft Excel Misc	1	28th Dec 2004 06:33 PM