| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
macro to paste data in alternate cells-pawan
i want to paste data in alternate cells. e.g. i have following 2 columns:
A B PWV3 DIGOUTHG ILA3 DIGOUTHG ILB3 DIGOUTHG PDE3 DIGOUTHG ILC3 DIGOUTHG QWR3 DIGOUTHG PWV4 DIGOUTHG ILA4 DIGOUTHG I want to paste PWV3 in row 1 and 3 of column B. Then I want to paste ILA3 in row 2 and 4 of column B...and so on....it is tedious to do it for large numner of rows. Can we write macro for this... thank you... -Pawan |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Sum of Alternate Cells | Excel Discussion (Misc queries) | |||
| Automatic data entry in alternate cells based on drop-down menu se | Excel Worksheet Functions | |||
| macro copy/paste data from multiple cells to multiple cells | Excel Discussion (Misc queries) | |||
| Using a Macro to paste into Blank Cells | Excel Worksheet Functions | |||
| Hyperlink-Pawan | New Users to Excel | |||
Threaded Mode
