| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
copy range on every worksheet (diff names) to a master worksheet (to be created)
Any ideas?? I need to copy a range (same location) on every worksheet (diff names to a master worksheet (to be created). I also need this range to be pasted special (transform) so the range o 4-5 cells is horizontal for a mailmerge instead of vertical. Please help??!! :confused -- Berni ----------------------------------------------------------------------- Bernie's Profile: http://www.excelforum.com/member.php...fo&userid=1457 View this thread: http://www.excelforum.com/showthread.php?threadid=26236 |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
copy range on every worksheet (diff names) to a master worksheet (to be created)
Hi Bernie
http://www.rondebruin.nl/copy2.htm You can use PasteSpecial to transpose -- Regards Ron de Bruin http://www.rondebruin.nl "Bernie" wrote in message ... Any ideas?? I need to copy a range (same location) on every worksheet (diff names) to a master worksheet (to be created). I also need this range to be pasted special (transform) so the range of 4-5 cells is horizontal for a mailmerge instead of vertical. Please help??!!  -- Bernie ------------------------------------------------------------------------ Bernie's Profile: http://www.excelforum.com/member.php...o&userid=14571 View this thread: http://www.excelforum.com/showthread...hreadid=262361 |
|
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
copy range on every worksheet (diff names) to a master worksheet (to be created)
Why "
"did you try doing it with the macro recorder turned on and then couldn't understand the results. Range("B3:E12").Select Selection.Copy Sheets("Sheet2").Select Range("C4").Select Selection.PasteSpecial Paste:=xlValues, Operation:=xlNone, SkipBlanks:= _ False, Transpose:=True What part is confusing? You don't know how to generalize it and copy progressively. -- Regards, Tom Ogilvy "Bernie" wrote in message ... Any ideas?? I need to copy a range (same location) on every worksheet (diff names) to a master worksheet (to be created). I also need this range to be pasted special (transform) so the range of 4-5 cells is horizontal for a mailmerge instead of vertical. Please help??!! -- Bernie ------------------------------------------------------------------------ Bernie's Profile: http://www.excelforum.com/member.php...o&userid=14571 View this thread: http://www.excelforum.com/showthread...hreadid=262361 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Auto Refresh data from original worksheet to newly created copy | Excel Discussion (Misc queries) | |||
| Copy Value of Active cell and 25 rows above to a diff worksheet | Excel Discussion (Misc queries) | |||
| Automatically copy from Master worksheet to others | Excel Worksheet Functions | |||
| Copy ranges of data from Master worksheet. Thanks | Excel Programming | |||
| How? Macro to copy range to new worksheet, name new worksheet, loop | Excel Programming | |||
![Bernie[_2_] is offline](https://www.excelbanter.com/images/SultanThemeVB3R/statusicon/user_offline.gif)
Hybrid Mode
