| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Need help to Copy and Paste array using macro
Hi guys,
i need help here. i have a data in Excel and i want to do copy and paste an array using macro. There are about 1000 rows of data. Each cell, let say A1 has a group of data (B1 : O1), A2 has B2:O2 and so on. How can i copy and paste special as transpose in diff sheets using a macro? Not all cells have a full group of data, like A4 might has data from B4:H4. It should be like this: A1 - B1 A1 - C1 A1 - D1 A2 - B2 A3 - B3 A3 - C3 Appreciate ur help, thanks! |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Copy/Paste array formulae from the newsgroup | Excel Discussion (Misc queries) | |||
| Cannot Copy/Paste Array Formula | Excel Worksheet Functions | |||
| Copy and Paste macro needs to paste to a changing cell reference | Excel Programming | |||
| how to count/sum by function/macro to get the number of record to do copy/paste in macro | Excel Programming | |||
| Macro to Copy/Paste then Paste to Next Line | Excel Programming | |||
Threaded Mode
