| Home |
| Search |
| Today's Posts |
|
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
Columns to rows
Hi Dave,
You're welcome. The macro is a bit bigger now, see SNAKECOLS, How to snake columns to use fewer pages http://www.mvps.org/dmcritchie/excel...l.htm3simplify look for Split_2_splits() and your own customization would be needed. It will copy an paste the formats used --- HTH, David McRitchie, Microsoft MVP - Excel [site changed Nov. 2001] My Excel Pages: http://www.mvps.org/dmcritchie/excel/excel.htm "Dave" wrote Woaaa! That's a big macro! Thanks much for your help. I have used macros before, but not this sophisticated. I'll take some time to digest this. But thanks again. Your help is much appreciated. Oh, my name is Dave Schiffer |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Rows & Columns in Excel | Excel Worksheet Functions | |||
| convert columns to rows & rows to columns | Excel Discussion (Misc queries) | |||
| How to swap rows and columns? | Excel Discussion (Misc queries) | |||
| hidden rows & columns slow file open | Excel Discussion (Misc queries) | |||
| Removing Near-Duplicate Rows, Leaving Those w/Most Data in Specific Columns | Excel Discussion (Misc queries) | |||
Threaded Mode
