i want to copy an excel sheet to this message. when i copy paste, it missses the table property. i want to copy the exact file with all its property in excel to this message. is it possible? i copied the excel sheet to ms word first. then i copied that to this message, even then the table property is missing.

Hi Sumesh,

Am Fri, 13 Apr 2012 14:52:39 +0000 schrieb sumesh56:

-----------------------------
A B C
-----------------------------
SL.NO TITLE
-----------------------------
1 abc 1
2 wett 1
3 0
4 jkhghj 1
5 0
6 0
7 rloljo 1
8 0
9 0
10 fddde 1
11 0
12 rderu 1

try in B2:
=--SUBTOTAL(3,$B$2:B2)


Regards
Claus Busch
--
Win XP PRof SP2 / Vista Ultimate SP2
Office 2003 SP2 /2007 Ultimate SP2

Hi Sumesh,

Am Fri, 13 Apr 2012 21:48:03 +0200 schrieb Claus Busch:

try in B2:
=--SUBTOTAL(3,$B$2:B2)

sorry, above is a typo
try in A2:
=--SUBTOTAL(3,$B$2:B2)


Regards
Claus Busch
--
Win XP PRof SP2 / Vista Ultimate SP2
Office 2003 SP2 /2007 Ultimate SP2

Here's one method I use to auto-number entries in a table. Removing
rows will cause the remaining rows to automatically renumber, adjusting
for rows that are added/removed...

Select cell A2
Open the Define Names dialog;

In the Name box type: '<sheetname'!LastCell
..where you substitute the actual sheetname for <sheetname;

In the RefersTo box enter =A1
Click the OK button to close the dialog

In cell A2 enter 1
In all the cells below enter =LastCell+1

If you want the cells to display a format then use Custom on the Number
Format tab of the Format Cells dialog.


Another way:
If you don't want to use a defined name then you can use the Row()
function as follows...

Scenario is Row1 has headers, data starts in Row2

In A2 type =Row()-1

Optionally, you just need to minus the row number immediately above the
first row of data if the start row isn't Row2. So.., if data starts in
Row6 then the formula to auto-number the data is...

=Row()-5

--
Garry

Free usenet access at http://www.eternal-september.org
ClassicVB Users Regroup!
comp.lang.basic.visual.misc
microsoft.public.vb.general.discussion

dear Garry,
it is perfect. it works.this is what i was searching for.thanks a lot and have a nice day.

i would like to give a description of my experience to those who want it.
1.suppose you have data in col A.there are blank rows in between data rows. you want to delete the blank rows and to get the data rows serial numbered.
2.give a name to the sheet(eg=test)
3.insert a col on the left. now the data in col B.
4.you have a header in B1.data from B2
5.select col A2.enter =Row()-1
in col A3 enter =A2+1
home-find-goto A50 pressing the shift p enter. then press control D. now you have serial numbers in col A from 1 to 50.

6.now home-find-goto-enter-A50:B50
pressing the shift p enter.find-goto special-blanks-p enter
7.then you press the delete btn on the tool bar. now the blank rows have been deleted and you get the data rows fully numbered.

-----------------------

i get reply for the questions i asked somewhere else(in another post).i am still waiting a reply for this problem. thanks.the admin may guide me whether i should repost this to get a reply.