Results 1 to 9 of 9

Cut & paste selected cells, by pressing button, to first blank row in table

Threaded View

Ejb123erok Cut & paste selected cells,... 04-29-2013, 03:26 AM
:) Sixthsense :) Re: Cut & paste selected... 04-29-2013, 03:38 AM
AndyLitch Re: Cut & paste selected... 04-29-2013, 03:47 AM
Ejb123erok Re: Cut & paste selected... 04-29-2013, 03:56 AM
:) Sixthsense :) Re: Cut & paste selected... 04-29-2013, 04:16 AM
AndyLitch Re: Cut & paste selected... 04-29-2013, 04:05 AM
AB33 Re: Cut & paste selected... 04-29-2013, 04:43 AM
Ejb123erok Re: Cut & paste selected... 04-29-2013, 06:54 AM
Ejb123erok Re: Cut & paste selected... 04-30-2013, 08:11 AM
  1. #1
    Registered User
    Join Date
    04-29-2013
    Location
    Uppsala
    MS-Off Ver
    Excel 2010
    Posts
    24

    Cut & paste selected cells, by pressing button, to first blank row in table

    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
    Attached Files Attached Files

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1