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

  • Thread starter Thread starter Guest
  • Start date Start date
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.
 
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
 
Well it's not really up to me, is there anyway to do this...or is that
getting too complicated?
 
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
 
Back
Top