Hi,
My excel skills sort of ends at (simple) functions, pivot tables and recording macros and since I can't seem fix this issue with this limited excel skillset I'm in need of help.
I've attached a sample workbook that doesn't look exactly as the original one but it resembles it and I hope that's enough to help me out.
Anyways, what I want to do is this:
1. Select one or several rows (always a full row, that is, from column A to D) in sheet1. For example selecting A2:D2.
2. Press "Archive"
3. By pressing Archive the selected data is cut and pasted to same columns in sheet 2 as well as placed in the blank rows in that sheet.
I've tried solving this by creating a macro but I either get an error or it (the macro) keep replacing my previous addition to the table when I press the macro.
I want to solve this as simple as possible because neither me or the users it's designed for have the skills to work out any furher issues nor do we need for more sophisticated
solution than this.
Hope I've provided all necessary information.
//Ejb123Erok
Bookmarks