Cat
Nov 10, 9:48 am show options
Newsgroups: microsoft.public.excel.programming
From: "Cat" <[email protected]> - Find messages by this author
Date: 10 Nov 2005 07:48:00 -0800
Subject: Linked Workbooks - How to Allow for Growth in source books?
Reply | Reply to Author | Forward | Print | Individual Message | Show
original | Report Abuse
I have several workbooks that I have linked together into one. I would
like to be able to show them in the destination workbook in a long
list, without space left in between each subset of data. The issue is,
when I add a new row in the source workbook, it does not get picked up
in the destination workbook. OR, if I select beyond the actual data
subset in the source (blank rows) to allow for the possibility of
additional rows being added, then these rows get all filled with zeros
when copied into the destination - a result I cannot allow since zero
is a valid value in some columns and this skews the data analysis being
done.
Is there a way to get the additional new columns into the destination
workbook without having to initially set it up with blank rows?
Suggestions?
Thanks!
Bookmarks