Hi Nick/Norman,

all of my sheet have same format.

I want to copy all the data present in the respective cell of Column D
e.g.

D10
D12
D14
D20
D22
D24
D30
D32
D48
D50
D52
D54
D70
D87
D102
D118
D137
D141
D145
D162
D164
D166
D168

I dont want to copy the formats.(ONLY VALUES)

I only want all the values of the above mentioned Cells in Vertical
position.

This is the only requirement which i had asked for.

Thanks

Akash Maheshwari


On May 11, 7:30 am, "NickHK" wrote:
You will have explain more clearly, as this latest example is completely
different to you initial 24 labels/text and the headings Form No, Client
Name / Company, Location, Version.

NickHK

"Akash" wrote in message

ups.com...



On May 10, 6:57 pm, "Norman Jones"
wrote:
HiAkash,

'----------------
Based on your mail i viewed the site mentioned by you.

I tried to copy this code and tried to run it.

[...]
But it showing me error as Compiler Error: Sub or Function not
Defined.
Last = LastRow(DestSh)

What should i do in this regards.

Awaiting for a resolution from your end.

[...]
'----------------

If you look again at Ron's page, you will see:

'-----------------
Important: The macro examples use the functions that you
can find in the last section of this page.
'-----------------

Therefore, try copying the function LastRow into
your code module and then retry Ron's code.

---
Regards,
Norman

Hi Norman,

Thanks for the Help but i dont want this. I want something else
Norman.

Let me tell u more precisely...

I have data in the below mentioned cells.

D10 D54
D12 D70
D14 D87
D20 D102
D22 D118
D24 D137
D30 D141
D32 D145
D48 D162
D50 D164
D52 D166
D168

All the 100 Sheets is having the data in these Cells only.

Now what i want is to accumulate the data in one sheet named as
Summary.

Thanks

Akash- Hide quoted text -

- Show quoted text -