Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Copying Cells From Multiple Worksheets to Create Summary Sheet | Excel Discussion (Misc queries) | |||
Create scenarios using macro and data in cells | Excel Programming | |||
Copying cells with a macro | Excel Discussion (Misc queries) | |||
copying a macro to several cells | Excel Programming | |||
copying a macro to several cells | Excel Programming |