Could, somebody help me to create a macro for copying certain data in cells
at different rows and different column in Sheet1. to Sheet2, but tabulated
like tab in access (Column,s & Row's).

your immediate action is really apreciated

Thanks

Brahim

You have to be a little more especific.., maybe you could start using
some simple code like:

Sheet1.Activate
Range("B8:B12").Select
Selection.Copy
Sheet2.Activate
Range("D5").Select
ActiveSheet.Paste

Regards.


--
dbarelli
------------------------------------------------------------------------
dbarelli's Profile: http://www.excelforum.com/member.php...o&userid=31275
View this thread: http://www.excelforum.com/showthread...hreadid=510143

Your request is unclear. Most everything in an Excel worksheet is to some
extent "tabulated", so what is specific about your required format, and how
do you identify *which* "certain" data to copy?

Basically:

with thisworkbook
.sheets("Sheet1").range("A2").copy .sheets("Sheet2").Range("B5")
end with


--
Tim Williams
Palo Alto, CA


"Brahim" wrote in message
...
Could, somebody help me to create a macro for copying certain data in
cells
at different rows and different column in Sheet1. to Sheet2, but tabulated
like tab in access (Column,s & Row's).

your immediate action is really apreciated

Thanks

Brahim