Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
Posts: 3
Default 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   Report Post  
Posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
Posts: 3
Default 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
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Wrapping text at end of page, and cells widths different when printout david Excel Discussion (Misc queries) 3 November 7th 07 01:40 AM
how do i set wrapping to see cell borders behind a pic in excel risrael Excel Discussion (Misc queries) 0 December 2nd 06 09:34 PM
Wrapping in Excel (fitting many lines of text in cell to print rig hd3017 Excel Discussion (Misc queries) 3 December 8th 05 01:19 AM
Data in Excel is not wrapping within cell consistently Bronwyn Excel Discussion (Misc queries) 0 March 30th 05 02:29 AM
Wrapping data in Excel Data Auto Filtering and Wrapping Excel Worksheet Functions 1 December 22nd 04 10:34 PM


All times are GMT +1. The time now is 04:20 PM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"