ExcelBanter - Excel scorecard

ExcelBanter (https://www.excelbanter.com/)

- Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)

- - Excel scorecard (https://www.excelbanter.com/excel-discussion-misc-queries/128020-excel-scorecard.html)

Sue

Excel scorecard

how do I shift the contents of a row down to add another name & data to a
list without changing the row fill colour pattern?

MartinW

Excel scorecard

Hi Sue,

You could use 'copy' and then 'paste values' instead of 'paste'.
Then just delete your original data.

HTH
Martin

All times are GMT +1. The time now is 06:01 PM.