Removing Rows from one sheet to another (with freeze panes)

[emilyloz]

Hi,

I once solved this problem, but when I solved it, I didn't have frozen panes involved in my sheet.

I'm trying to use this code:

Please Login or Register  to view this content.

and I also have code that does the same thing, but searches for a 'y'

Please Login or Register  to view this content.

When I press this button, it removes everything from the table and pastes it into the other sheet with about 10 blank lines above the entires. Also, it messes with the frozen panes from the previous sheet (once frozen at row 9, press button, becomes frozen at row 6).

I have attached my workbook

the password, when prompted, is "MillSteel"

Please Help!

[AndyLitch]

The basic problem is that you are copying and pasting the rows across.
You don't really need to do that - you can just transfer the values in something like the following form

Please Login or Register  to view this content.

followed by :

Please Login or Register  to view this content.

[emilyloz]

Okay I tried that. and it's still doing the same thing.

Please Login or Register  to view this content.

[emilyloz]

Actually, now its not even pasting the values anywhere?
they're all gone.

[tehneXus]

Hi,

check "UndoHistory_Click" in the appropriate sheet in the following file, you have to take case to place your data into the table "Table5", not below that: MillSteel-Maintenance.xlsm

[emilyloz]

that's great that its working!! thanks

can you explain what you mean by : "you have to take case to place your data into the table "Table5", not below that"

[emilyloz]

when I type 'n' and press undo history. the entries are rewriting the entries already listed in the current sheet.

they're not adding to the list?

[tehneXus]

When there is a record with "n" in column G in the table of "History Maintenance" its copied to the next free row in "Current Maintenance". The last row is checked in column A, as you haven't entered any priority it will always be row 10 to paste the rows, with with column B is checked:

Please Login or Register  to view this content.

[emilyloz]

Great! thanks so much!

[emilyloz]

Ahh, sorry tehneXus.

I changed that line of code and now its pasting the values in the B column. Everything is shifted to the right.

[tehneXus]

This time tested:

Please Login or Register  to view this content.