Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
copying "staggered" outline data from one tab to another, lining up the data on the target tab
I have a spreadsheet that contains several tabs. On one tab I have
information in two adjacent cells, e.g., A9 and B9. In subsequent rows this text data may shift over two cells, e.g., c11 and B11. This pattern may go back and forth; picture an outline format if that is helpful. I need to copy these staggered cells, two at a time, to the next tab WITHOUT THE STAGGERED LAYOUT, e.g., all data in columns A:B. Any ideas on macro code to achieve this? |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
copying "staggered" outline data from one tab to another, lining up the data on the target tab
On Oct 17, 2:11 pm, cagey63 wrote:
I have a spreadsheet that contains several tabs. On one tab I have information in two adjacent cells, e.g., A9 and B9. In subsequent rows this text data may shift over two cells, e.g., c11 and B11. This pattern may go back and forth; picture an outline format if that is helpful. I need to copy these staggered cells, two at a time, to the next tab WITHOUT THE STAGGERED LAYOUT, e.g., all data in columns A:B. Any ideas on macro code to achieve this? ? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
"Data Group and Outline Group" feature Limited to 8 levels | Excel Discussion (Misc queries) | |||
Macro to concatenate into "B1" B2 thru B"x" based on new data in "Col A" | Excel Discussion (Misc queries) | |||
How to set the default "summarized by" of a data field to "Sum"? | Excel Discussion (Misc queries) | |||
pictures to work with "data" "sort" option | Excel Discussion (Misc queries) | |||
Change data in a single column from "last, first" to "first last" | Excel Discussion (Misc queries) |