Is there a reason why, on the "master" sheet, you couldn't use Column A & B
for Sheet1, Columns C & D for Sheet2 ... etc.?
--

Regards,

RD
-----------------------------------------------------------------------------------------------
Please keep all correspondence within the Group, so all may benefit !
-----------------------------------------------------------------------------------------------

"gripnrip" wrote in message
...
I am sorry I have not described things a little better and I am sorry to be
taking up so much of your time. I believe I am going to just import the data
into seperate worksheets to get around this problem. For your information,
below is a more detailed description of my problem hopefully explaining it a
little better. If you know of a solution off the top of your head that would
be great, otherwise please do not worry about it, it is not a major problem.

I greatly appreciate you taking the time to help me.


I have 5 individual spreadsheets that are being updated by different
individuals. Each of these spreadsheets contain the numbering formula I have
been working on, so their tasks are automatically numbered when they enter a
new one and they do not have to worry about numbering. The tasks are entered
in column B and the autonumber is generated in column A.

I have a "Master" spreadsheet that has links to all 5 of these individual
spreadsheets so that another individual can look at everything and not have
to open up 5 different spreadsheets.

My problem is this: When I copy the formula for creating the numbers in
column A down the column, the "Master" spreadsheet that contains a link to
the individual spreadsheets is pulling in every single row, even if there is
not a number in column A or data in column B. I am attempting to put all 5
spreadsheets on the same worksheet and when this is done, there are all of
the empty cells between the linked worksheets, creating a lot of empty
space.

Again, please do not put any more time into this if you do not know a
solution right off.

Thanks!

"Ragdyer" wrote:

If I understand you now, you're linking *just* the cells that contain the
numbering formulas, and the data cells in Column B are left empty
(un-linked) so that you can add other data to those "other" sheets.

If the *only* reason for creating the links is to avoid the necessity of
copying those numbering formulas to "new" sheets, I think you're going
about
it all wrong!

"Linking" is *not* the right way to create copies.

If it were me, I would "group" the sheets, where I could then perform a
single copy down on the main sheet, and have this action duplicated in all
sheets included in the "group".

If new sheets were being created piecemeal, I would perform a copy of the
formulas, which would take no more trouble then if you performed the
linking,
OR
Make a sort of template sheet, containing formulas with no data, which
could
be duplicated, one at a time when the need arises.

If I'm still missing the point of this thread, post back and we'll try
again.
--
Regards,

RD

---------------------------------------------------------------------------
Please keep all correspondence within the NewsGroup, so all may benefit !
---------------------------------------------------------------------------
"gripnrip" wrote in message
...
I'm sorry. I have headers and other data down the first 6 rows, so the
actual
data that I am trying to number begins at row 6, which is why 6 is set
to
a
value of 1 and then from row 7 on, the formula is copied down.

B7 is where the the data is entered that makes the numbering in column A
appear.

So, if B7 doesn't contain any data, A7 doesn't contain a number. If B7
contains any data, then A7 is numbered according to the formula.



"gripnrip" wrote:

Is it possible to exclude cells with formulas and no data from showing
in
another Excel file that is linked?

The formulas only put data in the cell if other conditions are met, so
if
those conditions are not met and the cells do not display data, they
shouldn't be seen in the Excel file that is linked to it.

Hopefully thad made sense.