How can I change the tab but keep the row and column constant when

[Dave Peterson]

My suggestion is to not do this. Don't add an empty row.

If you want to make it look pretty, then just increase the rowheight so that it
looks double spaced.

 

[Peo Sjoblom]

Oops! My bad

See Dave's answer to you design question, I agree 100% with him

 

[Bernie Deitrick]

MG,

It depends on what you mean by "skip a row in between data"...

Enter this in cell I5:

=INDIRECT(TEXT((ROW()-ROW($I$4)-1)/2 +1,"000") & "!$L$46")

Leave I6 blank.

Then, select I5:I6, and copy.

Select I7 down to I???, enough for 2 rows for each sheet, then paste.

HTH,
Bernie
MS Excel MVP

 

[Guest]

Well it's not really up to me, is there anyway to do this...or is that
getting too complicated?

 

[Dave Peterson]

Maybe Peo will know.

Well it's not really up to me, is there anyway to do this...or is that
getting too complicated?

 

[Bernie Deitrick]

MG,

Here's my reply from a different part of this thread, in case you missed it.....

It depends on what you mean by "skip a row in between data"...

Enter this in cell I5:

=INDIRECT(TEXT((ROW()-ROW($I$4)-1)/2 +1,"000") & "!$L$46")

Leave I6 blank.

Then, select I5:I6, and copy.

Select I7 down to I???, enough for 2 rows for each sheet, then paste.

HTH,
Bernie
MS Excel MVP