Autonumber based on cell content - include decimals

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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.
 
If your original formulas are configured to return a null ("") if conditions
are not met, then the linked cells of the second file should reflect that
null return and display a blank appearing cell.

Care to post some of the formulas you're using?
 
Sure. Here's the code I am using to do the numbering:

A6
=1

A2
=IF(B7<>"",0.01+A6,"")

With the formula from 'A2' copied to all cells in column A, those cells are
showing up in the linked document, even though they do not contain any data.
 
I never claimed to be overly bright, so I'm lost with your example!

If the formula in A2 is copied down Column A, what happens when it comes to
A6?

And ... what's in B7?
 
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.
 
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.
 
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!
 
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 !
-----------------------------------------------------------------------------------------------

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!
 
Back
Top