Using Marco - moving a line of data..

try this;

Please Login or Register  to view this content.

Upload your file. Attach a sample workbook. Make sure there is just enough data to demonstrate your need. Include a BEFORE sheet and an AFTER sheet in the workbook if needed to show the process you're trying to complete or automate. Make sure your desired results are shown, mock them up manually if necessary.

Remember to desensitize the data.

Click on GO ADVANCED and use the paperclip icon to open the upload window.

View Pic

Matt--
It would be a lot easier to make happen if the completed were moved to a new sheet instead of the bottom of the existing sheet. In my example attached that is what I have done. Before you apply the Macro, however, you need to unmerge all your headings. VBA and Merged cells do not play well together. If you fail to unmerge the cells before running the macro, the macro will do it and will change your headings in the destination sheet.

Please Login or Register  to view this content.