Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Wrapping cell data to a new column or page in Excel
Ok, I have something that I don't think can be done but I thought I'd
throw it out here to see. I have a workbook that consists of multiple sheets. Each sheet has 2 rows of header data, 24 columns and 78 additional rows of specfic data (81 rows in all). Once you ignore the 3 header rows the data looks something like this: ClmnA ClmnB ClmnC ClmnD ClmnE ClmnF 1st Street A Ave Stcode BLK GRID Stcode BLK GRID 3rd Street B Ave Stcode BLK GRID Stcode BLK GRID Here's what I'd like to do. Let's say I realized that I had missed an entry (each entry being 3 columns and 2 rows worth of data) for 2nd Street. If I inserted two rows of 3 column cells about 3rd street, I would like the 3 columns and 2 rows of data that moved down to wrap up to the top of the next set of columns (D-F). When the data got below the very last row available (row 81) I would like it to wrap to the top of the next worksheet (row 4 actually to leave the header rows intact) and then have the process repeat until all sheets are updated to only 24 columns and 81 rows. Any help anyone could give would be most appreciated. Thanks! |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Wrapping cell data to a new column or page in Excel
On Jan 11, 4:25*pm, wrote:
Correction on part of this, there are 3 rows of header data and not 2 as described. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Wrapping text at end of page, and cells widths different when printout | Excel Discussion (Misc queries) | |||
how do i set wrapping to see cell borders behind a pic in excel | Excel Discussion (Misc queries) | |||
Wrapping in Excel (fitting many lines of text in cell to print rig | Excel Discussion (Misc queries) | |||
Data in Excel is not wrapping within cell consistently | Excel Discussion (Misc queries) | |||
Wrapping data in Excel | Excel Worksheet Functions |