create a macro for copying certain data in cells
 

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

create a macro for copying certain data in cells
 

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

create a macro for copying certain data in cells
 

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