Move text in cell to row above

[trevolly]

Hi all,

I'm wondering if anyone would help with this... I have a table that we use to list information for when another shift starts. Sometimes some of this data becomes out of date and we clear the contents / text in the relevant row (I don't want to delete the whole row, the sheet is protected although editing of specific rows is available). This leaves a gap / blank in the table of info.

Id like to be able to highlight the data in the rows below by click shift and then move the typed content up in to the blank rows. I don't want to delete or insert rows.

For example in the screenshot I've attached Id like to click shift (represented by the green box drawn around the content) the three rows of content in rows 35, 36 and 37 and then move them up to fill the two gaps in rows 33, 34 and 35.

Is this possible? I can copy and paste but because they are merged cells I get a warning about pasting over content and if I do if unmerges the cells.

Thank you

 

[mumps]

First of all, you should avoid merging cells because they almost always cause problems, particularly for macros. You could simply widen a column if you need more space or do a little research into "CenterAcrossSelection". This has the same effect as merging without actually merging any cells. I would suggest re-designing your sheet to remove all the merged cells. Secondly, you said that you want to move up three rows of data. Based on the picture you posted, there are only two blank rows above the data you highlighted. Also, if you move any data, that would leave more blank rows. Please clarify in detail and also what you mean by "click shift". It would be easier to help if you could use the XL2BB add-in (icon in the menu) to attach a screenshot (not a picture) of your sheet. Alternately, you could upload a copy of your file to a free site such as www.box.com or www.dropbox.com. Once you do that, mark it for 'Sharing' and you will be given a link to the file that you can post here. Explain in detail what you want to do referring to specific cells, rows, columns and sheets using a few examples from your data (de-sensitized if necessary).