Is it possible to choose a certain amount of rows and have them ex

  • Thread starter Thread starter ocean
  • Start date Start date
O

ocean

I would like to choose lets say 50 rows of data and have every 50 rows go on
each tab? Is that possible? I have already entered the data into the rows and
when I tried to cut and paste, all of the formatting was lost. Thank you.
 
You can group sheets so data entry, formatting, etc is copied to all
grouped sheets as you amend a single sheet.

To group sheets:
- Click on the first sheet tab you want group
- Press the Shift key and click on the last sheet tab that you want
grouped.

Start typing, formatting, etc.

- To ungroup, click a sheet tab other than the sheet that has focus.

To speed things up, try pasting using Ctrl-V instead of Excel menus.


--
Lil





I would like to choose lets say 50 rows of data and have every 50 rows
go on each tab? Is that possible? I have already entered the data into
the rows and when I tried to cut and paste, all of the formatting was
lost. Thank you.
Click to expand...



--
 
I don;t understand your answer.

Let me be sure you understand my question

Let's say, I have 300 rows of data on one sheet. What I want to do is tell
excel that I would like to put every 100 rows onto a separate tab. How do I
do that?
 
OK, that is clearer. I thought your need was to have fifty rows of data
repeated on every sheet. Your problem is the loss of formatting when
pasting. Column widths being a likely candidate.

Rather than cut and paste, use copy and paste special. For the first paste
special option, choose 'all'. When you see the result is missing something
(say - column widths), just paste special again (no need to copy again) and
select the missing component to paste. Once all is to your satisfaction, go
back to your original sheet and press delete to clear.

XL2003

Edit, Paste Special

XL2007

Home tab, Clipboard group, click the Paste Button, and then click Paste
Special.




I don;t understand your answer.

Let me be sure you understand my question

Let's say, I have 300 rows of data on one sheet. What I want to do is
tell excel that I would like to put every 100 rows onto a separate
tab. How do I do that?
Click to expand...



--
 
Thank you. I get the feeling that what I want to do is not possible. It looks
like my only option is to copy and paste, but I wanted to tell excel to put a
certain range of data on each tab. For example, ask excel to put my 100 rows
of data I have already entered onto one tab and so on. Thank you for your
help.
 
I would not say "cannot be done" about anything in Excel. It is amazing
what some perople can achieve. My perception of your reqirements are
currently very scant in detail - you want to copy data fifty rows at a time
to other sheets; copy paste does not do what you wish. If you describe in
more detail what you need and your general aim in doing this, perhaps your
problem may be relatively easy to resolve? Perhaps a simple macro will
automate a task for you? Perhaps there is an alternative solution?


--Lil
 
Hi Lil,

I am just brain storming here, but I was thinking if you can reference a
cell to other sheets/tabs. Maybe you can reference multiple cells to
accomplish what I would like to do. I have created over 400 rows of data. I
would to have lets say every 100 rows of that data put on 4 different tabs so
it is spread out. wiithout having to copy and paste all of the work. There
must be a way to do that like you mean.
 
Back
Top