Copy & paste Table

  • Thread starter Thread starter I'm not Barbara
  • Start date Start date
I

I'm not Barbara

I have a weekly table (cells are empty at the beginning of the week an
data is added each day).

This table constructs of few rows of 12.5 Pt. high, others with 15 Pt
and one row 20 Pt.

Now, at the end of the week, I copy this table and paste it below th
previous and delete the data (only from the new table), so I'm read
with empty table for the coming week.

Problem is, after the pasting, the row heights I have define
previously (12.5, 15, 20) aren't being kept and I need to redefined i
each time.

Is there any way to paste and keep the -*Rows height*- definitio
intact
 
INB,
Copy the rows not just the table cells.
You select entire rows by selecting the row header numbers.
--
Jim Cone
San Francisco, USA
http://www.realezsites.com/bus/primitivesoftware


"I'm not Barbara"
wrote in message
I have a weekly table (cells are empty at the beginning of the week and
data is added each day).
This table constructs of few rows of 12.5 Pt. high, others with 15 Pt.
and one row 20 Pt.
Now, at the end of the week, I copy this table and paste it below the
previous and delete the data (only from the new table), so I'm ready
with empty table for the coming week.
Problem is, after the pasting, the row heights I have defined
previously (12.5, 15, 20) aren't being kept and I need to redefined it
each time.
Is there any way to paste and keep the -*Rows height*- definition
intact?
 
Jim said:
INB,
Copy the rows not just the table cells.
You select entire rows by selecting the row header numbers.
Click to expand...

Thanks, it works. You've made my day.

I'm (really) not Barbara
 
You might try copying the area, then pasting only the formats
afterwards. You could record a macro and possibly use the
macro for future updates, depends on your rows begin consistent
month to month including number of rows remaining consistent for
each month. If you do get involved with a macro solution you
might get some help from my insrtrow.htm page which copies
a single row, maintaining formulas and formatting, and removes
constants.
-
HTH,
David McRitchie, Microsoft MVP - Excel [site changed Nov. 2001]
My Excel Pages: http://www.mvps.org/dmcritchie/excel/excel.htm
Search Page: http://www.mvps.org/dmcritchie/excel/search.htm

"I'm not Barbara" <Im.not.Barbara.2c379u_1154814908.8244@excelforum-
 
Back
Top